The following constants are used by the functions for managing 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 laterpsheetFontAngle New in version 23psheetFontAngle | Attribute to find or modify: Text rotation angle | SpreadsheetStyleSelection |
| psheetStrikeOut | Attribute to find or modify: Struck-out character | SpreadsheetStyleSelection |
| psheetLoadDefault | Mode for loading the XLSX file: The XLSX file loaded in the Spreadsheet control is opened in write mode. | 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 |
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 |
| psheetBackgroundColor | Attribute to find or modify: Background color of text | SpreadsheetStyleSelection |
| psheetTextColor | Attribute to find or modify: Text color | SpreadsheetStyleSelection |
| psheetOverwriteAllowed | Mode for saving the file: If the XLSX file already exists and is not open (in the Spreadsheet control or another application), it is overwritten. | SpreadsheetSave |
| psheetfFormula | Customizing the formula bar: The control allows you to type the formula for the current cell in the Spreadsheet control. | SpreadsheetControlFormula |
| psheetfSelection | Customizing the formula bar: The control displays the current selection (cell or range of cells) in the Spreadsheet control. | SpreadsheetControlFormula |
| psheetBold | Attribute to find or modify: Bold character | SpreadsheetStyleSelection |
| psheetTopLeft | The display of Spreadsheet control is modified in order for the specified cell to be positioned in the upper-left corner of visible control area. | SpreadsheetPosition |
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 |
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 |
| psheetFontName | Attribute to find or modify: Name of font used | SpreadsheetStyleSelection |
Versions 23 and laterpsheetSearchWithCase New in version 23psheetSearchWithCase psheetSearchWithCase | Search option: Search while taking the case into account. | SpreadsheetSeek, SpreadsheetReplace |
Versions 23 and laterpsheetSearchContain New in version 23psheetSearchContain psheetSearchContain | Search option: "Contains" search. | SpreadsheetSeek, SpreadsheetReplace |
Versions 23 and laterpsheetSearchInFormula New in version 23psheetSearchInFormula psheetSearchInFormula | Search option: Search in the formulas only. | SpreadsheetSeek, SpreadsheetReplace |
Versions 23 and laterpsheetSearchExact New in version 23psheetSearchExact psheetSearchExact | Search option: "Exact" search. | SpreadsheetSeek, SpreadsheetReplace |
Versions 23 and laterpsheetSearchCurrentWorksheet New in version 23psheetSearchCurrentWorksheet psheetSearchCurrentWorksheet | Search option: Search in the current worksheet. | SpreadsheetSeek, SpreadsheetReplace |
Versions 23 and laterpsheetSearchNoCase New in version 23psheetSearchNoCase psheetSearchNoCase | Search option: Search ignoring the case. | SpreadsheetSeek, SpreadsheetReplace |
Versions 23 and laterpsheetSearchAnyWorksheet New in version 23psheetSearchAnyWorksheet psheetSearchAnyWorksheet | Search option: Search in all worksheets of workbook. | SpreadsheetSeek, SpreadsheetReplace |
Versions 23 and laterpsheetAutomaticLineWrap New in version 23psheetAutomaticLineWrap psheetAutomaticLineWrap | Attribute to find or modify: Management of automatic line wrap. | SpreadsheetStyleSelection |
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 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 |
| psheetUnderlined | Attribute to find or modify: Underlined character | SpreadsheetStyleSelection |
| psheetFontSize | Attribute to find or modify: Font size | 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 |