GetCellDirtyFlag Method
Applies To
fpSpread control
Description
Returns whether a cell in a bound sheet has been marked as changed.
Syntax
BOOL CSpreadSheet::GetCellDirtyFlag (long Col, long Row);
fpSpread.GetCellDirtyFlag(ByVal Col As Long, ByVal Row As Long) As Boolean
Parameters
The following parameters are available:
Parameter | Description |
---|---|
Col | Column number of cell being checked Set to –1 to return whether any cell in the specified row has been flagged as changed. |
Row | Row number of cell being checked |
Remarks
This method returns whether a cell in the sheet is flagged to be written to the database when either the active cell moves to another row and the DAutoSave property is set to True or, when the DAutoSave property is set to False, and the application calls the DataSave method. If an entire row is flagged, all cells within that row are written to the database.
Set the Col parameter to –1 to return whether any cell in the specified row has been flagged to be written to the database.
This method is called for the current sheet setting unless you first set the Sheet property to specify the sheet with which you want to work.
When the user changes the data in a cell, the sheet automatically sets the flag when the cell leaves edit mode. However, if the application changes data in a cell through properties, you must call the SetCellDirtyFlag method if you want the data flagged to be saved.
If the DAutoSave property is set to True, once the active cell has moved to another row the cell is no longer marked to be saved. If the DAutoSave property is set to False, the cell is no longer marked to be saved after the data is saved to the database or when you call the SetCellDirtyFlag method and set the Dirty parameter to False.
Return Type
True if the cell is marked as changed, and False if the cell has not been marked.
See Also
Monitoring Data Changes in the Sheet
SetCellDirtyFlag method
DataSave method