Spread 8.0 Documentation
ActiveX
Support Options

Glossary Item Box

ActiveX


To monitor data changes

  1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
  2. Using the SetCellDirtyFlag method,
    1. Set the Col parameter to the column number of the cell to monitor, or set the value to –1 to specify an entire row.
    2. Set the Row parameter to the row number of the cell or cells to monitor.
    3. Set the Dirty parameter to TRUE to flag changed cells.
  3. Use the GetCellDirtyFlag method to check whether a specific cell's data has been changed.
© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.