TdxSpreadSheetChange Enum

Enumerates changes made in an opened spreadsheet document.

Declaration

TdxSpreadSheetChange = (
    sscData,
    sscLayout,
    sscZoom,
    sscStyle,
    sscDimension,
    sscOptionsPrint,
    sscModified,
    sscBiDiMode,
    sscMetadata
);

Members

Name
sscData
sscLayout
sscZoom
sscStyle
sscDimension
sscOptionsPrint
sscModified
sscBiDiMode
sscMetadata

Remarks

Options include:

Value	Description
sscData	Indicates a cell change (that is, a cell create, delete, or move operation, or a cell value change).
sscLayout	The most common spreadsheet change flag. Indicates a document structure change (that is, worksheet create, delete, rearrange, or rename operation) or a worksheet view/content change (that is, a cell object operation, a change to cell value or formatting, a zoom factor change, etc.).
sscZoom	Indicates a zoom in or out operation.
sscStyle	Indicates a style change in a cell or cell range.
sscDimension	Indicates that a worksheet’s populated area has shrunk or expanded due to a cell create or delete operation.
sscOptionsPrint	Indicates that a print setting was changed in a worksheet’s OptionsPrint property set.
sscModified	Indicates any change in an opened document. This flag always changes a spreadsheet control‘s Modified property to True and raises the OnModifiedChanged event.
sscBiDiMode	Indicates that one of the following property values has changed: A spreadsheet control’s BiDiMode property. A worksheet’s Options.RightToLeftLayout property.
sscMetadata	Indicates a manual change in a spreadsheet control’s OptionsMetadata property set. This flag is not present when the spreadsheet control automatically updates metadata when a change in the opened document occurs or when a print operation is performed.

The TdxSpreadSheetChanges type references the TdxSpreadSheetChange type.