The following constants are used by the functions for managing the Spreadsheet controls:
| | |
| Constant | Description | 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 laterpsheetAutomaticLineWrap New in version 23psheetAutomaticLineWrap | 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 laterpsheetFontAngle New in version 23psheetFontAngle 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 laterpsheetInfoSortCriteria New in version 23psheetInfoSortCriteria psheetInfoSortCriteria | Requested information: Used to find out the last sort criteria used to sort the Spreadsheet control. | SpreadsheetGetSortInfo |
Versions 23 and laterpsheetInfoSortSelection New in version 23psheetInfoSortSelection psheetInfoSortSelection | Requested information: Used to know selection that will be sorted by the AAF (Automatic Application Features) for sorting the Spreadsheet control. | 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 laterpsheetLoadKeepPassword New in version 24psheetLoadKeepPassword 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 is not opened (in the Spreadsheet control or another application), it is overwritten. | SpreadsheetSave |
Versions 23 and laterpsheetSearchAnyWorksheet New in version 23psheetSearchAnyWorksheet psheetSearchAnyWorksheet | Search option: Search in all worksheets of workbook. | SpreadsheetSeek, SpreadsheetReplace |
Versions 23 and laterpsheetSearchContain New in version 23psheetSearchContain psheetSearchContain | Search option: "Contains" search. | SpreadsheetSeek, SpreadsheetReplace |
Versions 23 and laterpsheetSearchCurrentWorksheet New in version 23psheetSearchCurrentWorksheet psheetSearchCurrentWorksheet | Search option: Search in the current worksheet. | SpreadsheetSeek, SpreadsheetReplace |
Versions 23 and laterpsheetSearchExact New in version 23psheetSearchExact psheetSearchExact | Search option: "Exact" search. | SpreadsheetSeek, SpreadsheetReplace |
Versions 23 and laterpsheetSearchInFormula New in version 23psheetSearchInFormula psheetSearchInFormula | Search option: Search in the formulas only. | SpreadsheetSeek, SpreadsheetReplace |
Versions 23 and laterpsheetSearchNoCase New in version 23psheetSearchNoCase psheetSearchNoCase | Search option: Search while ignoring the case. | SpreadsheetSeek, SpreadsheetReplace |
Versions 23 and laterpsheetSearchWithCase New in version 23psheetSearchWithCase psheetSearchWithCase | Search option: Search while taking the case into account. | SpreadsheetSeek, SpreadsheetReplace |
Versions 23 and laterpsheetSelAll New in version 23psheetSelAll psheetSelAll | Type of selection: The entire worksheet is selected. | psheetSelection variable |
Versions 23 and laterpsheetSelEmpty New in version 23psheetSelEmpty psheetSelEmpty | Type of selection: No selection. | psheetSelection variable |
Versions 23 and laterpsheetSelMultiCell New in version 23psheetSelMultiCell psheetSelMultiCell | Type of selection: Several cells are selected. | psheetSelection variable |
Versions 23 and laterpsheetSelMultiHeader New in version 23psheetSelMultiHeader psheetSelMultiHeader | Type of selection: Several headers are selected. | psheetSelection variable |
Versions 23 and laterpsheetSelRectCell New in version 23psheetSelRectCell psheetSelRectCell | Type of selection: Several cells are selected and they define a rectangle. | psheetSelection variable |
Versions 23 and laterpsheetSelSimpleCell New in version 23psheetSelSimpleCell psheetSelSimpleCell | Type of selection: A single cell is selected. | psheetSelection variable |
Versions 23 and laterpsheetSelSimpleHeader New in version 23psheetSelSimpleHeader psheetSelSimpleHeader | Type of selection: A single header is selected. | psheetSelection variable |
Versions 23 and laterpsheetSortInfoWithTitle New in version 23psheetSortInfoWithTitle psheetSortInfoWithTitle | Requested information: Used to know whether the selection sorted by the AAF (Automatic Application Features) for sorting the Spreadsheet control contains a title | 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 |