Spread 8.0 Documentation
GetCellDirtyFlag Method
Support Options
ActiveX Reference > ActiveX Methods > GetCellDirtyFlag Method

Glossary Item Box

GetCellDirtyFlag Method


See Also    Example

Applies To

fpSpread control

Description

Returns whether a cell in a bound sheet has been marked as changed.

Syntax

C++

BOOL CSpreadSheet::GetCellDirtyFlag (long Col, long Row);

Visual Basic

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

DAutoSave, Sheet properties

SetCellDirtyFlag method

DataSave method

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.