You can reset various settings on various parts of the Spread component interface back to default or original values. You can also clear parts of the data area of various items, both data and formatting.
The ways in which parts of the component can be reset include:
- Reset the component to its original state using the FpSpread class Reset method.
- Reset the sheet to its original state using the SheetView class Reset method.
- Reset the skin properties for a sheet or sheets using the DefaultSkins class Reset method.
- Reset the value of a cell or the text in a cell to empty using the Cell class, ResetText or ResetValue method.
- Reset all the named style properties to their default values using the NamedStyle class Reset method. There are also individual reset methods for each of the settings in a style:
- Reset all the style settings in the StyleInfo object to the default settings using the StyleInfo class Reset method.
Reset the settings for cells, rows, or columns using the individual reset methods for each setting in the Cell or Row or Column or StyleInfo class.
- ResetBackColor Method
- ResetBackground Method
- ResetBorder Method
- ResetCellType Method
- ResetFont Method
- ResetForeColor Method
- ResetHorizontalAlignment Method
- ResetLocked Method
- ResetTabStop Method
- ResetText Method
- ResetValue Method
- ResetVerticalAlignment Method
Reset all the named style properties to their default values using the NamedStyle class Reset method. There are also individual reset methods for each of the settings in a style.
- StyleInfo ResetEditor Method
- StyleInfo ResetFormatter Method
- StyleInfo ResetRenderer Method
Resetting the component or a sheet to its default settings returns the component or the sheet to its initial state prior to any design-time or run-time changes. It clears data, resets colors, and returns cells to the default cell type. Resetting the component resets everything in the component to the state when the component is first drawn on the form.
Resetting the component or a sheet clears the data in the sheet(s) as well as the formatting. If you provide a way for users to reset their sheet(s), be sure to have them confirm the action before resetting the sheet(s).