When you delete a cell with vk_back then the spreadsheet will be calculated deleting with vk_delete does not "fire up recalculate event".
Is this bug or feature?
Write in the cells a1..a5 nummer values and a6 the formula "=sum(a1:a5)".
Now when you delete one of the cells a1..a5 with vk_back key then the cell a6 will be updated. But when you delete it wih vk_delete then a6 has still old value. ( press for deleting: vk_back + vk_enter or vk_delete + vk_enter).
Very strange is that in fpspreadsheetgrid.pas there is no key handler for vk_back key. It is handled only in base class TCustomDrawGrid.
For additional info look at my comments.
procedure TsCustomWorksheetGrid.KeyDown(var Key : Word; Shift : TShiftState);
//..
case Key of
//..
VK_DELETE: // when you add here VK_BACK then spreedsheat will be also not recalculated
if (ssCtrl in Shift) then
Worksheet.DeleteSelection
else
Worksheet.EraseSelection(true);
// Maybe Recalculate ore something similar for vk_delete must be called.
end;
end;