Contents
- Index
- Previous
- Next
SpreadsheetOptions property
Applies to
TProfGrid component
Declaration
property SpreadsheetOptions: TProfGridSpreadsheetOptions;
Description
Specifies various display and behavioral properties of the grid, in addition to the Options property.
SpreadsheetOptions is a set drawn from the following values:
soExcelStyleHeadings
The grid draws the spreadsheet headings using the same drawing style as Microsoft Excel uses (which is different from the default drawing of cells in the fixed area of the grid).
soExcelStyleHeadingHighlight
Spreadsheet headings are automatically highlighted to indicate the current selection in the grid.
soExcelStyleSelection
The grid displays the focused cell and any selected cells using the same drawing style as Microsoft Excel uses.
soExcelStyleNavigation
The grid processes the navigational keyboard combinations in the same way as Microsoft Excel does.
soExcelStyleComments
The grid displays any cell-wise hints in the same manner as Microsoft Excel displays its cell-wise comments.
soColRowHeadingClickSelect
The grid automatically selects an entire column (row) when the user clicks the column (row) heading.
soMouseBuildUpFormula
The option provides an ability to use the mouse to build up formulae (references and ranges) by clicking on other cells while editing a formula in a cell.