I am using the footer:
This cannot be done on an active LiveBindings. Please use the LoadAllAndDisconnect method and then apply the calculations.
I have found out that footer and calculations enabled with livebinding do not let me edit and save the cell content.
That is correct. Unfortunately, calculations, sorting/filtering is done on an inactive dataset, editing needs to be done on an active dataset.
Is there any development planned for a FMX Grid more like dxGrid by TMS in the near future?
I have found that if you make field changes, use the table Afterpost Event and had the following lines:
PORITEMSGrid.UpdateCalculation(13);
poritemsgrid.Cells[13, PORITEMSGRID.RowCount - PORITEMSGRID.FixedFooterRows] := formatfloat('#.00',poritemsgrid.AllFloats[13, PORITEMSGRID.RowCount - PORITEMSGRID.FixedFooterRows]);
PORITEMSGRID.Cells[3, PORITEMSGRID.RowCount - PORITEMSGRID.FixedFooterRows] := 'Subtotal';
Seems to work ok!
You can ofcourse make the grid work together if you implement this logic. But out of the box there is still a lot of work needed to make the data manipulations/updates sync with the dataset.