Spreadsheet constants

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

WLanguage

WLanguage functions

Controls, pages and windows

Spreadsheet functions

Prefixed syntax

Spreadsheet constants

See also

Spreadsheet constants

Display constants used by prefixed syntaxes only

Display constants used by non-prefixed syntaxes only

The following constants are used by the functions for managing the Spreadsheet controls:

Constant	Affects	Used by the functions

psheetAlignmentH	Attribute to find or modify: Horizontal alignment	SpreadsheetStyleSelection
psheetAlignmentV	Attribute to find or modify: Vertical alignment	SpreadsheetStyleSelection
Versions 23 and later psheetAutomaticLineWrap New in version 23 psheetAutomaticLineWrap psheetAutomaticLineWrap	Attribute to find or modify: Management of automatic line wrap.	SpreadsheetStyleSelection
psheetBackgroundColor	Attribute to find or modify: Background color of text	SpreadsheetStyleSelection
psheetBold	Attribute to find or modify: Bold character	SpreadsheetStyleSelection
psheetfFormula	Customizing the formula bar: The control allows you to type the formula for the current cell in the Spreadsheet control.	SpreadsheetControlFormula
Versions 23 and later psheetFontAngle New in version 23 psheetFontAngle psheetFontAngle	Attribute to find or modify: Rotation angle of text	SpreadsheetStyleSelection
psheetFontName	Attribute to find or modify: Name of font used	SpreadsheetStyleSelection
psheetFontSize	Attribute to find or modify: Font size	SpreadsheetStyleSelection
psheetfSelection	Customizing the formula bar: The control displays the current selection (cell or range of cells) in the Spreadsheet control.	SpreadsheetControlFormula
Versions 23 and later psheetInfoSortCriteria New in version 23 psheetInfoSortCriteria psheetInfoSortCriteria	Requested information: Used to find out the last sort criteria used to sort the Spreadsheet control.	Versions 23 and later SpreadsheetGetSortInfo New in version 23 SpreadsheetGetSortInfo SpreadsheetGetSortInfo
Versions 23 and later psheetInfoSortSelection New in version 23 psheetInfoSortSelection psheetInfoSortSelection	Requested information: Used to know selection that will be sorted by the AAF (Automatic Application Features) for sorting the Spreadsheet control.	Versions 23 and later SpreadsheetGetSortInfo New in version 23 SpreadsheetGetSortInfo SpreadsheetGetSortInfo
psheetItalic	Attribute to find or modify: Italic character	SpreadsheetStyleSelection
psheetLoadDefault	Mode for loading the XLSX file: The XLSX file loaded in the Spreadsheet control is opened in write mode.	SpreadsheetLoad
Versions 24 and later psheetLoadKeepPassword New in version 24 psheetLoadKeepPassword psheetLoadKeepPassword	Mode for loading the XLSX file: The password of the XLSX file loaded in the Spreadsheet control is kept in memory.	SpreadsheetLoad
psheetLoadUnlinked	Mode for loading the XLSX file: The XLSX file loaded in the Spreadsheet control is loaded in memory only. The ".xlxs" file can be opened by another application.	SpreadsheetLoad
psheetOverwriteAllowed	Mode for saving the file: If the XLSX file already exists and if it is not opened (in the Spreadsheet control or in another application), it is overwritten.	SpreadsheetSave
Versions 23 and later psheetSearchAnyWorksheet New in version 23 psheetSearchAnyWorksheet psheetSearchAnyWorksheet	Search option: Search in all worksheets of workbook.	SpreadsheetSeek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchContain New in version 23 psheetSearchContain psheetSearchContain	Search option: "Contains" search.	SpreadsheetSeek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchCurrentWorksheet New in version 23 psheetSearchCurrentWorksheet psheetSearchCurrentWorksheet	Search option: Search in the current worksheet.	SpreadsheetSeek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchExact New in version 23 psheetSearchExact psheetSearchExact	Search option: "Exact" search.	SpreadsheetSeek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchInFormula New in version 23 psheetSearchInFormula psheetSearchInFormula	Search option: Search in the formulas only.	SpreadsheetSeek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchNoCase New in version 23 psheetSearchNoCase psheetSearchNoCase	Search option: Search while ignoring the case.	SpreadsheetSeek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchWithCase New in version 23 psheetSearchWithCase psheetSearchWithCase	Search option: Search while taking the case into account.	SpreadsheetSeek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSelAll New in version 23 psheetSelAll psheetSelAll	Type of selection: The entire worksheet is selected.	psheetSelection variable
Versions 23 and later psheetSelEmpty New in version 23 psheetSelEmpty psheetSelEmpty	Type of selection: No selection.	psheetSelection variable
Versions 23 and later psheetSelMultiCell New in version 23 psheetSelMultiCell psheetSelMultiCell	Type of selection: Several cells are selected.	psheetSelection variable
Versions 23 and later psheetSelMultiHeader New in version 23 psheetSelMultiHeader psheetSelMultiHeader	Type of selection: Several headers are selected.	psheetSelection variable
Versions 23 and later psheetSelRectCell New in version 23 psheetSelRectCell psheetSelRectCell	Type of selection: Several cells are selected and they define a rectangle.	psheetSelection variable
Versions 23 and later psheetSelSimpleCell New in version 23 psheetSelSimpleCell psheetSelSimpleCell	Type of selection: A single cell is selected.	psheetSelection variable
Versions 23 and later psheetSelSimpleHeader New in version 23 psheetSelSimpleHeader psheetSelSimpleHeader	Type of selection: A single header is selected.	psheetSelection variable
Versions 23 and later psheetSortInfoWithTitle New in version 23 psheetSortInfoWithTitle psheetSortInfoWithTitle	Requested information: Used to know whether the selection sorted by the AAF (Automatic Application Features) for sorting the Spreadsheet control contains a title	Versions 23 and later SpreadsheetGetSortInfo New in version 23 SpreadsheetGetSortInfo SpreadsheetGetSortInfo
psheetStrikeOut	Attribute to find or modify: Struck-out character	SpreadsheetStyleSelection
psheetTextColor	Attribute to find or modify: Text color	SpreadsheetStyleSelection
psheetTopLeft	The display of Spreadsheet control is modified in order for the specified cell to be positioned in the top left corner of visible control area.	SpreadsheetPosition
psheetUnderlined	Attribute to find or modify: Underlined character	SpreadsheetStyleSelection
psheetVisible	The display of Spreadsheet control is modified in order for the specified cell to be visible in the Spreadsheet control. The display of control is not modified if the specified cell is already visible in the Spreadsheet control.	SpreadsheetPosition

Versions 23 and later
The functions for managing Spreadsheet controls use the following constants (prefixed syntax):

Constant	Affects	Used by the functions

psheetAlignmentH	Attribute to find or modify: Horizontal alignment	<Spreadsheet>.StyleSelection
psheetAlignmentV	Attribute to find or modify: Vertical alignment	<Spreadsheet>.StyleSelection
Versions 23 and later psheetAutomaticLineWrap New in version 23 psheetAutomaticLineWrap psheetAutomaticLineWrap	Attribute to find or modify: Management of automatic line wrap.	<Spreadsheet>.StyleSelection
psheetBackgroundColor	Attribute to find or modify: Background color of text	<Spreadsheet>.StyleSelection
psheetBold	Attribute to find or modify: Bold character	<Spreadsheet>.StyleSelection
psheetfFormula	Customizing the formula bar: The control allows you to type the formula for the current cell in the Spreadsheet control.	<Spreadsheet>.ControlFormula
Versions 23 and later psheetFontAngle New in version 23 psheetFontAngle psheetFontAngle	Attribute to find or modify: Rotation angle of text	<Spreadsheet>.StyleSelection
psheetFontName	Attribute to find or modify: Name of font used	<Spreadsheet>.StyleSelection
psheetFontSize	Attribute to find or modify: Font size	<Spreadsheet>.StyleSelection
psheetfSelection	Customizing the formula bar: The control displays the current selection (cell or range of cells) in the Spreadsheet control.	<Spreadsheet>.ControlFormula
Versions 23 and later psheetInfoSortCriteria New in version 23 psheetInfoSortCriteria psheetInfoSortCriteria	Requested information: Used to find out the last sort criteria used to sort the Spreadsheet control.	Versions 23 and later SpreadsheetGetSortInfo New in version 23 SpreadsheetGetSortInfo SpreadsheetGetSortInfo
Versions 23 and later psheetInfoSortSelection New in version 23 psheetInfoSortSelection psheetInfoSortSelection	Requested information: Used to know selection that will be sorted by the AAF (Automatic Application Features) for sorting the Spreadsheet control.	Versions 23 and later SpreadsheetGetSortInfo New in version 23 SpreadsheetGetSortInfo SpreadsheetGetSortInfo
psheetItalic	Attribute to find or modify: Italic character	<Spreadsheet>.StyleSelection
psheetLoadDefault	Mode for loading the XLSX file: The XLSX file loaded in the Spreadsheet control is opened in write mode.	<Spreadsheet>.Load
psheetLoadUnlinked	Mode for loading the XLSX file: The XLSX file loaded in the Spreadsheet control is loaded in memory only. The ".xlxs" file can be opened by another application.	<Spreadsheet>.Load
psheetOverwriteAllowed	Mode for saving the file: If the XLSX file already exists and if it is not opened (in the Spreadsheet control or in another application), it is overwritten.	<Spreadsheet>.Save
Versions 23 and later psheetSearchAnyWorksheet New in version 23 psheetSearchAnyWorksheet psheetSearchAnyWorksheet	Search option: Search in all worksheets of workbook.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchContain New in version 23 psheetSearchContain psheetSearchContain	Search option: "Contains" search.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchCurrentWorksheet New in version 23 psheetSearchCurrentWorksheet psheetSearchCurrentWorksheet	Search option: Search in the current worksheet.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchExact New in version 23 psheetSearchExact psheetSearchExact	Search option: "Exact" search.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchInFormula New in version 23 psheetSearchInFormula psheetSearchInFormula	Search option: Search in the formulas only.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchNoCase New in version 23 psheetSearchNoCase psheetSearchNoCase	Search option: Search while ignoring the case.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchWithCase New in version 23 psheetSearchWithCase psheetSearchWithCase	Search option: Search while taking the case into account.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSelAll New in version 23 psheetSelAll psheetSelAll	Type of selection: The entire worksheet is selected.	psheetSelection variable
Versions 23 and later psheetSelEmpty New in version 23 psheetSelEmpty psheetSelEmpty	Type of selection: No selection.	psheetSelection variable
Versions 23 and later psheetSelMultiCell New in version 23 psheetSelMultiCell psheetSelMultiCell	Type of selection: Several cells are selected.	psheetSelection variable
Versions 23 and later psheetSelMultiHeader New in version 23 psheetSelMultiHeader psheetSelMultiHeader	Type of selection: Several headers are selected.	psheetSelection variable
Versions 23 and later psheetSelRectCell New in version 23 psheetSelRectCell psheetSelRectCell	Type of selection: Several cells are selected and they define a rectangle.	psheetSelection variable
Versions 23 and later psheetSelSimpleCell New in version 23 psheetSelSimpleCell psheetSelSimpleCell	Type of selection: A single cell is selected.	psheetSelection variable
Versions 23 and later psheetSelSimpleHeader New in version 23 psheetSelSimpleHeader psheetSelSimpleHeader	Type of selection: A single header is selected.	psheetSelection variable
Versions 23 and later psheetSortInfoWithTitle New in version 23 psheetSortInfoWithTitle psheetSortInfoWithTitle	Requested information: Used to know whether the selection sorted by the AAF (Automatic Application Features) for sorting the Spreadsheet control contains a title	Versions 23 and later SpreadsheetGetSortInfo New in version 23 SpreadsheetGetSortInfo SpreadsheetGetSortInfo
psheetStrikeOut	Attribute to find or modify: Struck-out character	<Spreadsheet>.StyleSelection
psheetTextColor	Attribute to find or modify: Text color	<Spreadsheet>.StyleSelection
psheetTopLeft	The display of Spreadsheet control is modified in order for the specified cell to be positioned in the top left corner of visible control area.	<Spreadsheet>.Position
psheetUnderlined	Attribute to find or modify: Underlined character	<Spreadsheet>.StyleSelection
psheetVisible	The display of Spreadsheet control is modified in order for the specified cell to be visible in the Spreadsheet control. The display of control is not modified if the specified cell is already visible in the Spreadsheet control.	<Spreadsheet>.Position

New in version 23
The functions for managing Spreadsheet controls use the following constants (prefixed syntax):

Constant	Affects	Used by the functions

psheetAlignmentH	Attribute to find or modify: Horizontal alignment	<Spreadsheet>.StyleSelection
psheetAlignmentV	Attribute to find or modify: Vertical alignment	<Spreadsheet>.StyleSelection
Versions 23 and later psheetAutomaticLineWrap New in version 23 psheetAutomaticLineWrap psheetAutomaticLineWrap	Attribute to find or modify: Management of automatic line wrap.	<Spreadsheet>.StyleSelection
psheetBackgroundColor	Attribute to find or modify: Background color of text	<Spreadsheet>.StyleSelection
psheetBold	Attribute to find or modify: Bold character	<Spreadsheet>.StyleSelection
psheetfFormula	Customizing the formula bar: The control allows you to type the formula for the current cell in the Spreadsheet control.	<Spreadsheet>.ControlFormula
Versions 23 and later psheetFontAngle New in version 23 psheetFontAngle psheetFontAngle	Attribute to find or modify: Rotation angle of text	<Spreadsheet>.StyleSelection
psheetFontName	Attribute to find or modify: Name of font used	<Spreadsheet>.StyleSelection
psheetFontSize	Attribute to find or modify: Font size	<Spreadsheet>.StyleSelection
psheetfSelection	Customizing the formula bar: The control displays the current selection (cell or range of cells) in the Spreadsheet control.	<Spreadsheet>.ControlFormula
Versions 23 and later psheetInfoSortCriteria New in version 23 psheetInfoSortCriteria psheetInfoSortCriteria	Requested information: Used to find out the last sort criteria used to sort the Spreadsheet control.	Versions 23 and later SpreadsheetGetSortInfo New in version 23 SpreadsheetGetSortInfo SpreadsheetGetSortInfo
Versions 23 and later psheetInfoSortSelection New in version 23 psheetInfoSortSelection psheetInfoSortSelection	Requested information: Used to know selection that will be sorted by the AAF (Automatic Application Features) for sorting the Spreadsheet control.	Versions 23 and later SpreadsheetGetSortInfo New in version 23 SpreadsheetGetSortInfo SpreadsheetGetSortInfo
psheetItalic	Attribute to find or modify: Italic character	<Spreadsheet>.StyleSelection
psheetLoadDefault	Mode for loading the XLSX file: The XLSX file loaded in the Spreadsheet control is opened in write mode.	<Spreadsheet>.Load
psheetLoadUnlinked	Mode for loading the XLSX file: The XLSX file loaded in the Spreadsheet control is loaded in memory only. The ".xlxs" file can be opened by another application.	<Spreadsheet>.Load
psheetOverwriteAllowed	Mode for saving the file: If the XLSX file already exists and if it is not opened (in the Spreadsheet control or in another application), it is overwritten.	<Spreadsheet>.Save
Versions 23 and later psheetSearchAnyWorksheet New in version 23 psheetSearchAnyWorksheet psheetSearchAnyWorksheet	Search option: Search in all worksheets of workbook.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchContain New in version 23 psheetSearchContain psheetSearchContain	Search option: "Contains" search.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchCurrentWorksheet New in version 23 psheetSearchCurrentWorksheet psheetSearchCurrentWorksheet	Search option: Search in the current worksheet.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchExact New in version 23 psheetSearchExact psheetSearchExact	Search option: "Exact" search.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchInFormula New in version 23 psheetSearchInFormula psheetSearchInFormula	Search option: Search in the formulas only.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchNoCase New in version 23 psheetSearchNoCase psheetSearchNoCase	Search option: Search while ignoring the case.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchWithCase New in version 23 psheetSearchWithCase psheetSearchWithCase	Search option: Search while taking the case into account.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSelAll New in version 23 psheetSelAll psheetSelAll	Type of selection: The entire worksheet is selected.	psheetSelection variable
Versions 23 and later psheetSelEmpty New in version 23 psheetSelEmpty psheetSelEmpty	Type of selection: No selection.	psheetSelection variable
Versions 23 and later psheetSelMultiCell New in version 23 psheetSelMultiCell psheetSelMultiCell	Type of selection: Several cells are selected.	psheetSelection variable
Versions 23 and later psheetSelMultiHeader New in version 23 psheetSelMultiHeader psheetSelMultiHeader	Type of selection: Several headers are selected.	psheetSelection variable
Versions 23 and later psheetSelRectCell New in version 23 psheetSelRectCell psheetSelRectCell	Type of selection: Several cells are selected and they define a rectangle.	psheetSelection variable
Versions 23 and later psheetSelSimpleCell New in version 23 psheetSelSimpleCell psheetSelSimpleCell	Type of selection: A single cell is selected.	psheetSelection variable
Versions 23 and later psheetSelSimpleHeader New in version 23 psheetSelSimpleHeader psheetSelSimpleHeader	Type of selection: A single header is selected.	psheetSelection variable
Versions 23 and later psheetSortInfoWithTitle New in version 23 psheetSortInfoWithTitle psheetSortInfoWithTitle	Requested information: Used to know whether the selection sorted by the AAF (Automatic Application Features) for sorting the Spreadsheet control contains a title	Versions 23 and later SpreadsheetGetSortInfo New in version 23 SpreadsheetGetSortInfo SpreadsheetGetSortInfo
psheetStrikeOut	Attribute to find or modify: Struck-out character	<Spreadsheet>.StyleSelection
psheetTextColor	Attribute to find or modify: Text color	<Spreadsheet>.StyleSelection
psheetTopLeft	The display of Spreadsheet control is modified in order for the specified cell to be positioned in the top left corner of visible control area.	<Spreadsheet>.Position
psheetUnderlined	Attribute to find or modify: Underlined character	<Spreadsheet>.StyleSelection
psheetVisible	The display of Spreadsheet control is modified in order for the specified cell to be visible in the Spreadsheet control. The display of control is not modified if the specified cell is already visible in the Spreadsheet control.	<Spreadsheet>.Position

The functions for managing Spreadsheet controls use the following constants (prefixed syntax):

Constant	Affects	Used by the functions

psheetAlignmentH	Attribute to find or modify: Horizontal alignment	<Spreadsheet>.StyleSelection
psheetAlignmentV	Attribute to find or modify: Vertical alignment	<Spreadsheet>.StyleSelection
Versions 23 and later psheetAutomaticLineWrap New in version 23 psheetAutomaticLineWrap psheetAutomaticLineWrap	Attribute to find or modify: Management of automatic line wrap.	<Spreadsheet>.StyleSelection
psheetBackgroundColor	Attribute to find or modify: Background color of text	<Spreadsheet>.StyleSelection
psheetBold	Attribute to find or modify: Bold character	<Spreadsheet>.StyleSelection
psheetfFormula	Customizing the formula bar: The control allows you to type the formula for the current cell in the Spreadsheet control.	<Spreadsheet>.ControlFormula
Versions 23 and later psheetFontAngle New in version 23 psheetFontAngle psheetFontAngle	Attribute to find or modify: Rotation angle of text	<Spreadsheet>.StyleSelection
psheetFontName	Attribute to find or modify: Name of font used	<Spreadsheet>.StyleSelection
psheetFontSize	Attribute to find or modify: Font size	<Spreadsheet>.StyleSelection
psheetfSelection	Customizing the formula bar: The control displays the current selection (cell or range of cells) in the Spreadsheet control.	<Spreadsheet>.ControlFormula
Versions 23 and later psheetInfoSortCriteria New in version 23 psheetInfoSortCriteria psheetInfoSortCriteria	Requested information: Used to find out the last sort criteria used to sort the Spreadsheet control.	Versions 23 and later SpreadsheetGetSortInfo New in version 23 SpreadsheetGetSortInfo SpreadsheetGetSortInfo
Versions 23 and later psheetInfoSortSelection New in version 23 psheetInfoSortSelection psheetInfoSortSelection	Requested information: Used to know selection that will be sorted by the AAF (Automatic Application Features) for sorting the Spreadsheet control.	Versions 23 and later SpreadsheetGetSortInfo New in version 23 SpreadsheetGetSortInfo SpreadsheetGetSortInfo
psheetItalic	Attribute to find or modify: Italic character	<Spreadsheet>.StyleSelection
psheetLoadDefault	Mode for loading the XLSX file: The XLSX file loaded in the Spreadsheet control is opened in write mode.	<Spreadsheet>.Load
psheetLoadUnlinked	Mode for loading the XLSX file: The XLSX file loaded in the Spreadsheet control is loaded in memory only. The ".xlxs" file can be opened by another application.	<Spreadsheet>.Load
psheetOverwriteAllowed	Mode for saving the file: If the XLSX file already exists and if it is not opened (in the Spreadsheet control or in another application), it is overwritten.	<Spreadsheet>.Save
Versions 23 and later psheetSearchAnyWorksheet New in version 23 psheetSearchAnyWorksheet psheetSearchAnyWorksheet	Search option: Search in all worksheets of workbook.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchContain New in version 23 psheetSearchContain psheetSearchContain	Search option: "Contains" search.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchCurrentWorksheet New in version 23 psheetSearchCurrentWorksheet psheetSearchCurrentWorksheet	Search option: Search in the current worksheet.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchExact New in version 23 psheetSearchExact psheetSearchExact	Search option: "Exact" search.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchInFormula New in version 23 psheetSearchInFormula psheetSearchInFormula	Search option: Search in the formulas only.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchNoCase New in version 23 psheetSearchNoCase psheetSearchNoCase	Search option: Search while ignoring the case.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSearchWithCase New in version 23 psheetSearchWithCase psheetSearchWithCase	Search option: Search while taking the case into account.	<Spreadsheet>.Seek, Versions 23 and later SpreadsheetReplace New in version 23 SpreadsheetReplace SpreadsheetReplace
Versions 23 and later psheetSelAll New in version 23 psheetSelAll psheetSelAll	Type of selection: The entire worksheet is selected.	psheetSelection variable
Versions 23 and later psheetSelEmpty New in version 23 psheetSelEmpty psheetSelEmpty	Type of selection: No selection.	psheetSelection variable
Versions 23 and later psheetSelMultiCell New in version 23 psheetSelMultiCell psheetSelMultiCell	Type of selection: Several cells are selected.	psheetSelection variable
Versions 23 and later psheetSelMultiHeader New in version 23 psheetSelMultiHeader psheetSelMultiHeader	Type of selection: Several headers are selected.	psheetSelection variable
Versions 23 and later psheetSelRectCell New in version 23 psheetSelRectCell psheetSelRectCell	Type of selection: Several cells are selected and they define a rectangle.	psheetSelection variable
Versions 23 and later psheetSelSimpleCell New in version 23 psheetSelSimpleCell psheetSelSimpleCell	Type of selection: A single cell is selected.	psheetSelection variable
Versions 23 and later psheetSelSimpleHeader New in version 23 psheetSelSimpleHeader psheetSelSimpleHeader	Type of selection: A single header is selected.	psheetSelection variable
Versions 23 and later psheetSortInfoWithTitle New in version 23 psheetSortInfoWithTitle psheetSortInfoWithTitle	Requested information: Used to know whether the selection sorted by the AAF (Automatic Application Features) for sorting the Spreadsheet control contains a title	Versions 23 and later SpreadsheetGetSortInfo New in version 23 SpreadsheetGetSortInfo SpreadsheetGetSortInfo
psheetStrikeOut	Attribute to find or modify: Struck-out character	<Spreadsheet>.StyleSelection
psheetTextColor	Attribute to find or modify: Text color	<Spreadsheet>.StyleSelection
psheetTopLeft	The display of Spreadsheet control is modified in order for the specified cell to be positioned in the top left corner of visible control area.	<Spreadsheet>.Position
psheetUnderlined	Attribute to find or modify: Underlined character	<Spreadsheet>.StyleSelection
psheetVisible	The display of Spreadsheet control is modified in order for the specified cell to be visible in the Spreadsheet control. The display of control is not modified if the specified cell is already visible in the Spreadsheet control.	<Spreadsheet>.Position