Resetting Parts of the Interface

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 size of the component to its original size using the FpSpread class DefaultSize property.
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 class:

Resetting Desired	Method Name
background color for individual cells or for row or column of cells	ResetBackColor
border for individual cells or for row or column of cells	ResetBorder
cell type for individual cells or for row or column of cells	ResetCellType
text font for individual cells or for row or column of cells	ResetFont
foreground color for individual cells or for row or column of cells	ResetForeColor
row height	ResetHeight
cell contents horizontal alignment for individual cells or for row or column of cells	ResetHorizontalAlignment
cell header label	ResetLabel
locked status for individual cells or for row or column of cells	ResetLocked
merge policy for a row or column of cells	ResetMergePolicy
cell note indicator color for individual cells or for row or column of cells	ResetNoteIndicatorColor
parent style name for individual cells or for row or column of cells	ResetParentStyleName
column resizable	ResetResizable
column sort indicator	ResetSortIndicator
cell contents vertical alignment for individual cells or for row or column of cells	ResetVerticalAlignment
row or column visible	ResetVisible
column width	ResetWidth

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:

Method Name	Resetting Desired
Reset	all the properties of the style
ResetBackColor	background color of a cell
ResetBorder	border around a cell
ResetCanFocus	whether the cell can receive focus
ResetCellType	cell type of the cell
ResetEditor	editor used for editing the cell
ResetFont	font face used in the text of the cell
ResetForeColor	text (foreground) color in a cell
ResetFormatter	formatter for formatting the contents of the cell
ResetHorizontalAlignment	horizontal alignment of text in a cell
ResetLocked	whether the cell is marked as locked
ResetName	default name of the style
ResetNoteIndicatorColor	color of the cell note indicator
ResetNoteStyle	cell note style
ResetParent (Inherited from StyleInfo)	parent style name
ResetProperty	specified setting property
ResetRenderer	renderer for painting the cell
ResetTabStop	whether the user can set focus to the cell using the Tab key
ResetVerticalAlignment	vertical alignment of text in a cell

If you are setting the background color for an individual cell, then ResetBackColor resets that cell's background color to its default color. If, instead, you set the background color using the BackColor property for a Row object, then you must use the ResetBackColor for that Row. If you want to loop all the cells setting the color to White, you can speed this up by invalidating the painting in the Spread while you are looping the cells.

FpSpread1.SuspendLayout()

FpSpread1.Sheets(0).Cells(0, 0, 499, 499).BackColor = Color.White

FpSpread1.ResumeLayout(True)

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.

Note: 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).

You can find out the default size of the component using the FpSpread DefaultSize property.

For more information about clearing data, refer to Removing Data from a Sheet.

For information on resetting values creating during the design using Spread Designer, refer to explanation of this procedure in the Spread Designer Guide.