| | |
| Constant | Description | Used by the functions |
|---|
| mergeCellCenter | Merge cells of a Spreadsheet control: merges the cells and centers the contents. | SpreadsheetMergeCell |
| mergeCell | Merge cells of a Spreadsheet control: merges the cells without centering the contents. | SpreadsheetMergeCell |
| psheetAlignmentH | Attribute to find or modify: Horizontal alignment | SpreadsheetStyleSelection |
| psheetAlignmentV | Attribute to find or modify: Vertical alignment | SpreadsheetStyleSelection |
| psheetFontAngle | 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 |
| 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 |
| 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 |
| psheetInfoSortCriteria | Requested information: Used to find out the last sort criteria used to sort the Spreadsheet control. | SpreadsheetGetSortInfo |
| 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 |
| psheetSearchWithCase | Search option: Search while taking the case into account. | SpreadsheetSeek, SpreadsheetReplace |
| psheetSearchContain | Search option: "Contains" search. | SpreadsheetSeek, SpreadsheetReplace |
| psheetSearchInFormula | Search option: Search in the formulas only. | SpreadsheetSeek, SpreadsheetReplace |
| psheetSearchExact | Search option: "Exact" search. | SpreadsheetSeek, SpreadsheetReplace |
| psheetSearchCurrentWorksheet | Search option: Search in the current worksheet. | SpreadsheetSeek, SpreadsheetReplace |
| psheetSearchNoCase | Search option: Search ignoring the case. | SpreadsheetSeek, SpreadsheetReplace |
| psheetSearchAnyWorksheet | Search option: Search in all worksheets of workbook. | SpreadsheetSeek, SpreadsheetReplace |
| psheetAutomaticLineWrap | Attribute to find or modify: Management of automatic line wrap. | SpreadsheetStyleSelection |
| psheetSelMultiCell | Type of selection: Several cells are selected. | psheetSelection variable |
| psheetSelMultiHeader | Type of selection: Several headers are selected. | psheetSelection variable |
| psheetSelRectCell | Type of selection: Several cells are selected and they define a rectangle. | psheetSelection variable |
| psheetSelSimpleCell | Type of selection: A single cell is selected. | psheetSelection variable |
| psheetSelSimpleHeader | Type of selection: A single header is selected. | psheetSelection variable |
| psheetSelAll | Type of selection: The entire worksheet is selected. | psheetSelection variable |
| 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 |