| | |
Constant | Description | Used by |
---|
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 get or set: Horizontal alignment | SpreadsheetStyleSelection |
psheetAlignmentV | Attribute to get or set: Vertical alignment | SpreadsheetStyleSelection |
psheetFontAngle | Attribute to get or set: Text rotation angle | SpreadsheetStyleSelection |
psheetStrikeOut | Attribute to get or set: Strikethrough text in the cell | SpreadsheetStyleSelection |
psheetLoadDefault | XLSX file loading mode: The XLSX file loaded in the Spreadsheet control is opened in write mode. | SpreadsheetLoad |
psheetLoadUnlinked | XLSX file loading mode: The XLSX file loaded in the Spreadsheet control is loaded in memory only. The ".xlxs" file can be opened by another application. | SpreadsheetLoad |
psheetLoadKeepPassword | XLSX file loading mode: The password of the XLSX file loaded in the Spreadsheet control is kept in memory. | SpreadsheetLoad |
psheetBackgroundColor | Attribute to get or set: Text background color | SpreadsheetStyleSelection |
psheetTextColor | Attribute to get or set: Text color | SpreadsheetStyleSelection |
psheetOverwriteAllowed | File save mode: If the XLSX file already exists and is not open (in the Spreadsheet control or another application), it is overwritten. | SpreadsheetSave |
psheetfFormula | Formula bar customization: The control allows you to type the formula for the current cell in the Spreadsheet control. | SpreadsheetControlFormula |
psheetfSelection | Formula bar customization: The control displays the current selection (cell or range of cells) in the Spreadsheet control. | SpreadsheetControlFormula |
psheetBold | Attribute to get or set: Bold text in the cell | SpreadsheetStyleSelection |
psheetTopLeft | The Spreadsheet control displays the specified cell in the upper-left corner of the control's visible area. | SpreadsheetPosition |
psheetSortInfoWithTitle | Desired information: Determines if the selection sorted by the Automatic Application Features (AAFs) in the Spreadsheet control contains a title | SpreadsheetGetSortInfo |
psheetInfoSortCriteria | Desired information: Gets the last sort criteria used in the Spreadsheet control. | SpreadsheetGetSortInfo |
psheetInfoSortSelection | Desired information: Gets the selection that will be sorted via the Automatic Application Features (AAFs) in the Spreadsheet control. | SpreadsheetGetSortInfo |
psheetItalic | Attribute to get or set: Italicized text in the cell | SpreadsheetStyleSelection |
psheetFontName | Attribute to get or set: Name of font used | SpreadsheetStyleSelection |
psheetSearchWithCase | Search option: Case-sensitive search. | SpreadsheetSeek, SpreadsheetReplace |
psheetSearchContain | Search option: "Contains" search. | SpreadsheetSeek, SpreadsheetReplace |
psheetSearchInFormula | Search option: Search only in formulas. | SpreadsheetSeek, SpreadsheetReplace |
psheetSearchExact | Search option: Exact-match search. | SpreadsheetSeek, SpreadsheetReplace |
psheetSearchCurrentWorksheet | Search option: Search in the current worksheet. | SpreadsheetSeek, SpreadsheetReplace |
psheetSearchNoCase | Search option: Case-insensitive search. | SpreadsheetSeek, SpreadsheetReplace |
psheetSearchAnyWorksheet | Search option: Search in all sheets of the workbook. | SpreadsheetSeek, SpreadsheetReplace |
psheetAutomaticLineWrap | Attribute to get or set: 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 get or set: Underlined text in the cell | SpreadsheetStyleSelection |
psheetFontSize | Attribute to get or set: Font size | SpreadsheetStyleSelection |
psheetVisible | The specified cell is visible in the Spreadsheet control. If the specified cell is already visible, the Spreadsheet control does not change. | SpreadsheetPosition |