VCL Spreadsheet Controls: Supported Commands List
- 27 minutes to read
The Spreadsheet and Report Designer controls provide a comprehensive set of commands that manipulate cells and their content (including editing and formatting), perform general spreadsheet-related operations, invoke various built-in dialogs, etc. In order to allow end-users to execute any of these commands, you can link them manually to elements of your UI or employ the automatic Ribbon or Toolbar UI generation feature provided by ExpressSpreadSheet Suite.
You can use most of the supported commands with any control that provides the Action property. However, the commands that allow end-users to enter specific values (i.e., assign a color value, font, etc.) instead of performing simple predefined operations (such as invoking a dialog), are designed to be used with bar item editors, including but not limited to, the TdxRibbonColorGalleryItem, TcxFontNameComboBox, and TcxComboBox components. For detailed information on using such commands with custom UI elements, refer to the full list of commands below and their corresponding action class descriptions.
Core Spreadsheet Commands
A
- AlignHorizontalCenter
Centers the content horizontally within all selected cells. To apply the other two horizontal cell content alignments, use the AlignHorizontalLeft and AlignHorizontalRight commands.
To localize the AlignHorizontalCenter command’s Caption and Hint, use the sdxSpreadSheetActionAlignHorizontalCenterCaption and sdxSpreadSheetActionAlignHorizontalCenterHint resource strings.
- AlignHorizontalLeft
Aligns the content to the left borders of all selected cells. To apply the other two horizontal cell content alignments, use the AlignHorizontalCenter and AlignHorizontalRight commands.
To localize the AlignHorizontalLeft command’s Caption and Hint, use the sdxSpreadSheetActionAlignHorizontalLeftCaption and sdxSpreadSheetActionAlignHorizontalLeftHint resource strings.
- AlignHorizontalRight
Aligns the content to the right borders of all selected cells. To apply the other two horizontal cell content alignments, use the AlignHorizontalLeft and AlignHorizontalCenter commands.
To localize the AlignHorizontalRight command’s Caption and Hint, use the sdxSpreadSheetActionAlignHorizontalRightCaption and sdxSpreadSheetActionAlignHorizontalRightHint resource strings.
- AlignVerticalBottom
Aligns the content to the bottom borders of all selected cells. To apply the other two vertical cell content alignments, use the AlignVerticalCenter and AlignVerticalTop commands.
To localize the AlignVerticalBottom command’s Caption and Hint, use the sdxSpreadSheetActionAlignVerticalBottomCaption and sdxSpreadSheetActionAlignVerticalBottomHint resource strings.
- AlignVerticalCenter
Centers the content vertically within all selected cells. To apply the other two vertical cell content alignments, use the AlignVerticalBottom and AlignVerticalTop commands.
To localize the AlignVerticalCenter command’s Caption and Hint, use the sdxSpreadSheetActionAlignVerticalCenterCaption and sdxSpreadSheetActionAlignVerticalCenterHint resource strings.
- AlignVerticalTop
Aligns the content to the top borders of all selected cells. To apply the other two vertical cell content alignments, use the AlignVerticalBottom and AlignVerticalCenter commands.
To localize the AlignVerticalTop command’s Caption and Hint, use the sdxSpreadSheetActionAlignVerticalTopCaption and sdxSpreadSheetActionAlignVerticalTopHint resource strings.
- AutoFitColumnWidth
Adjusts the widths of cells (and, therefore, columns) according to their content’s size.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionAutoFitColumnWidthCaption and sdxSpreadSheetActionAutoFitColumnWidthHint resource strings.
- AutoFitRowHeight
Adjusts the heights of cells according to their content’s size.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionAutoFitRowHeightCaption and sdxSpreadSheetActionAutoFitRowHeightHint resource strings.
- AutoSumGallery
- Implements the auto sum gallery.
B
- BordersAll
Assigns the sscbsThin style to all cell borders within all currently selected cell ranges.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionBordersAllCaption and sdxSpreadSheetActionBordersAllHint resource strings.
- BordersBottom
Assigns the sscbsThin style to the cell borders matching the bottom boundaries of all currently selected cell ranges. To apply different styles to the same cell borders, use the BordersBottomDouble and BordersBottomThick commands.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionBordersBottomCaption and sdxSpreadSheetActionBordersBottomHint resource strings.
- BordersBottomDouble
Assigns the sscbsDouble style to the cell borders matching the bottom boundaries of all currently selected cell ranges. To apply different styles to the same cell borders, use the BordersBottom and BordersBottomThick commands.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionBordersBottomDoubleCaption and sdxSpreadSheetActionBordersBottomDoubleHint resource strings.
- BordersBottomThick
Assigns the sscbsThick style to the cell borders matching the bottom boundaries of all current cell selections. To apply different styles to the same cell borders, use the BordersBottom and BordersBottomDouble commands.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionBordersBottomThickCaption and sdxSpreadSheetActionBordersBottomThickHint resource strings.
- BordersLeft
Assigns the sscbsThin style to the cell borders matching the left boundaries of all current cell selections.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionBordersLeftCaption and sdxSpreadSheetActionBordersLeftHint resource strings.
- BordersMore
Invokes the Format Cells dialog with the active Border tab for the current cell selection.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionBordersMoreCaption and sdxSpreadSheetActionBordersMoreHint resource strings.
- BordersNone
Restores the default border style for the current cell selection.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionBordersNoneCaption and sdxSpreadSheetActionBordersNoneHint resource strings.
- BordersOutside
Assigns the sscbsThin style to the cell borders matching the perimeters of all current cell selections.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionBordersOutsideCaption and sdxSpreadSheetActionBordersOutsideHint resource strings.
- BordersOutsideThick
Assigns the sscbsThick style to the cell borders matching the perimeters of all current cell selections.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionBordersOutsideThickCaption and sdxSpreadSheetActionBordersOutsideThickHint resource strings.
- BordersRight
Assigns the sscbsThin style to the cell borders matching the right boundaries of all currently selected cell ranges.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionBordersRightCaption and sdxSpreadSheetActionBordersRightHint resource strings.
- BordersTop
Assigns the sscbsThin style to the cell borders matching the top boundaries of all current cell selections.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionBordersTopCaption and sdxSpreadSheetActionBordersTopHint resource strings.
- BordersTopAndBottom
Assigns the sscbsThin style to the cell borders matching the top and bottom boundaries of all currently selected cell ranges. To apply different styles to the same cell borders, use the BordersTopAndBottomDouble and BordersTopAndBottomThick commands.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionBordersTopAndBottomCaption and sdxSpreadSheetActionBordersTopAndBottomHint resource strings.
- BordersTopAndBottomDouble
Assigns the sscbsDouble style to the cell borders matching the top and bottom boundaries of all currently selected cell ranges. To apply different styles to the same borders, use the BordersTopAndBottom and BordersTopAndBottomThick commands.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionBordersTopAndBottomDoubleCaption and sdxSpreadSheetActionBordersTopAndBottomDoubleHint resource strings.
- BordersTopAndBottomThick
Assigns the sscbsThick style to the cell borders matching the top and bottom boundaries of all currently selected cell ranges. To apply different styles to the same borders, use the BordersTopAndBottom and BordersTopAndBottomDouble commands.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionBordersTopAndBottomThickCaption and sdxSpreadSheetActionBordersTopAndBottomThickHint resource strings.
C
- ChangeFillColor
Link this command to a TcxColorComboBox or TdxRibbonColorGalleryItem element in a Ribbon or Toolbar UI to allow end-users to set the required color as a background for all selected cells. If you need to use the ChangeFillColor command with a custom control, refer to the TdxSpreadSheetChangeFillColor class description.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionChangeFillColorCaption and sdxSpreadSheetActionChangeFillColorHint resource strings.
- ChangeFontColor
Link this command to a TcxColorComboBox or TdxRibbonColorGalleryItem element in a Ribbon or Toolbar UI to allow end-users to change the font color used to display:
- The values in all selected cells.
- The text selection within an in-place cell editor (only if the rich content formatting functionality is enabled in the Spreadsheet/Report Designer control).
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionChangeFontColorCaption and sdxSpreadSheetActionChangeFontColorHint resource strings.
- ChangeFontName
Link this command to a TcxFontNameComboBox item control in a Ribbon or Toolbar UI to allow end-users to change the typeface of the font used to display:
- The values in all selected cells.
- The text selection within an in-place cell editor (only if the rich content formatting functionality is enabled in the Spreadsheet/Report Designer control).
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionChangeFontNameCaption and sdxSpreadSheetActionChangeFontNameHint resource strings.
- ChangeFontSize
Link this command to a TcxComboBox item control in a Ribbon or Toolbar UI to allow end-users to change the size of the font used to display:
- The values in all selected cells.
- The text selection within an in-place cell editor (only if the rich content formatting functionality is enabled in the Spreadsheet/Report Designer control).
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionChangeFontSizeCaption and sdxSpreadSheetActionChangeFontSizeHint resource strings.
- ClearAll
Clears values stored in all currently selected cells and restores their default style settings. To clear cells without affecting their custom style settings, use the ClearContents command. The ClearFormats command restores the default cell style settings without affecting the stored values.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionClearAllCaption and sdxSpreadSheetActionClearAllHint resource strings.
- ClearContents
Deletes values stored in the selected cells while keeping their custom style settings. To restore the default cell style settings, use the ClearAll or ClearFormats command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionClearContentsCaption and sdxSpreadSheetActionClearContentsHint resource strings.
- ClearFormats
Restores the default style settings for all selected cells without affecting their values. To clear the cell contents, use the ClearAll or ClearContents command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionClearFormatsCaption and sdxSpreadSheetActionClearFormatsHint resource strings.
- ClearPrintArea
Restores the active worksheet‘s default print area.
To localize the command’s caption and hint, use the sdxSpreadSheetActionClearPrintAreaCaption and sdxSpreadSheetActionClearPrintAreaHint resource strings.
- CopySelection
Copies the currently selected cell/cell range or floating container (including comments) to the clipboard. To paste the clipboard content into the active worksheet, use the PasteSelection command. An end-user can reproduce the CopySelection command’s effect by pressing the Ctrl+C or Ctrl+Insert key combination.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionCopySelectionCaption and sdxSpreadSheetActionCopySelectionHint resource strings.
- CompatibilityFormulasGallery
- Implements a gallery with functions from the “Compatibility” category.
- CreateDefinedName
Invokes the “New Name” dialog.
To localize the command’s Caption, use the sdxSpreadSheetActionCreateDefinedNameCaption resource string.
- CreateDefinedNamesFromSelection
Invokes the “Create Names from Selection” dialog.
To localize the command’s Caption, use the sdxSpreadSheetActionCreateDefinedNamesFromSelectionCaption resource string.
- CutSelection
Moves the currently selected cell/cell range or floating container (including comments) to the clipboard. To paste the clipboard content into the active worksheet, use the PasteSelection command. An end-user can reproduce the CutSelection command’s effect by pressing the Ctrl+X or Shift+Del key combination.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionCutSelectionCaption and sdxSpreadSheetActionCutSelectionHint resource strings.
D
- DateAndTimeFormulasGallery
- Implements a gallery with functions from the “Date and Time” category.
- DecreaseFontSize
Decreases the cell font size by one position within the control’s set of predefined font size values. This command affects the font used to display:
- The values in all selected cells.
- The text selection within an in-place cell editor (only if rich content formatting functionality is enabled in the Spreadsheet/Report Designer control).
Use the ChangeFontSize command to specify the exact font size value instead of using the predefined list.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionDecreaseFontSizeCaption and sdxSpreadSheetActionDecreaseFontSizeHint resource strings.
- DeleteColumns
Deletes all columns that intersect the current selection area. To delete rows, use the DeleteRows command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionDeleteColumnsCaption and sdxSpreadSheetActionDeleteColumnsHint resource strings.
- DeleteComments
Deletes all comment containers associated with cells within the current selection area. To create new or edit existing cell comments, use the NewComment or EditComment command, respectively.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionDeleteCommentsCaption and sdxSpreadSheetActionDeleteCommentsHint resource strings.
- DeleteRows
Deletes all rows that intersect the current selection area. To delete columns, use the DeleteColumns command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionDeleteRowsCaption and sdxSpreadSheetActionDeleteRowsHint resource strings.
- DeleteSheet
Removes the active sheet from a spreadsheet document. If the document contains only one visible worksheet, the DeleteSheet command is not available.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionDeleteSheetCaption and sdxSpreadSheetActionDeleteSheetHint resource strings.
E
- EditComment
Invokes the Customize Object dialog with the active Text tab for a comment container whose cell is currently focused. The EditComment command is not available for the cells without associated comment containers. To delete comments, use the DeleteComments command.
An end-user can reproduce the EditComment command’s effect by pressing the Shift+F2 key combination.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionEditCommentCaption and sdxSpreadSheetActionEditCommentHint resource strings.
F
- FinancialFormulasGallery
- Implements a gallery populated with functions from the “Financial” category.
- FindAndReplace
Invokes the Find and Replace dialog. An end-user can reproduce the FindAndReplace command’s effect by pressing the Ctrl+F key combination.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionFindAndReplaceCaption and sdxSpreadSheetActionFindAndReplaceHint resource strings.
- FreezeFirstColumn
Immobilizes the leftmost worksheet column in the visible View area. To unlock the frozen column, you can use either the FreezeTopRow or UnfreezePanes command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionFreezeFirstColumnCaption and sdxSpreadSheetActionFreezeFirstColumnHint resource strings.
- FreezePanes
Immobilizes a number of left columns and top rows in the active worksheet simultaneously. To unlock frozen columns and rows, use the UnfreezePanes command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionFreezePanesCaption and sdxSpreadSheetActionFreezePanesHint resource strings.
- FreezeTopRow
Immobilizes the first worksheet row at the top of the visible View area. To unlock the frozen row, you can use either the FreezeFirstColumn or UnfreezePanes command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionFreezeTopRowCaption and sdxSpreadSheetActionFreezeTopRowHint resource strings.
G
- GroupColumns
Groups all columns intersecting the current selection area. If these columns are already grouped, the GroupColumns command creates a nested group. To ungroup columns, use the UngroupColumns command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionGroupColumnsCaption and sdxSpreadSheetActionGroupColumnsHint resource strings.
- GroupRows
Groups all rows intersecting the current selection area. If these rows are already grouped, the GroupRows command creates a nested group. To ungroup rows, use the UngroupRows command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionGroupRowsCaption and sdxSpreadSheetActionGroupRowsHint resource strings.
H
- HideColumns
Hides all columns that intersect the current selection area. To display previously hidden columns, use the UnhideColumns commands. An end-user can reproduce the HideColumns command’s effect by pressing the Ctrl+0 key combination.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionHideColumnsCaption and sdxSpreadSheetActionHideColumnsHint resource strings.
- HideRows
Hides all rows that intersect the current selection area. To display previously hidden rows, use the UnhideRows command. An end-user can reproduce the HideRows command’s effect by pressing the Ctrl+9 key combination.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionHideRowsCaption and sdxSpreadSheetActionHideRowsHint resource strings.
- HideSheet
Hides the active worksheet. To display hidden sheets, use the UnhideSheet command. The HideSheet command is not available if the current spreadsheet document has only one visible sheet.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionHideSheetCaption and sdxSpreadSheetActionHideSheetHint resource strings.
I
- IncreaseFontSize
Increases the font size by one position within the control’s set of predefined font size values. This command affects the font used to display:
- The values in all selected cells.
- The text selection within an in-place cell editor (only if the rich content formatting functionality is enabled in the Spreadsheet/Report Designer control).
Use the ChangeFontSize command to specify the exact font size value instead of using the predefined list.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionIncreaseFontSizeCaption and sdxSpreadSheetActionIncreaseFontSizeHint resource strings.
- InformationFormulasGallery
- Implements a gallery populated with functions from the “Information” category.
- InsertColumns
Inserts a number of columns matching the absolute width (in cells) of the current selection area. To delete columns, use the DeleteColumns command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionInsertColumnsCaption and sdxSpreadSheetActionInsertColumnsHint resource strings.
- InsertPageBreak
Inserts a custom row and/or column page break into the active worksheet according to the focused cell‘s position. Use the ResetAllPageBreaks or RemovePageBreak command to remove all or only a specific custom page break.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionInsertPageBreakCaption and sdxSpreadSheetActionInsertPageBreakHint resource strings.
- InsertPicture
Invokes the Insert Picture dialog allowing an end-user to select an image for inserting to a worksheet as the floating picture container.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionInsertPictureCaption and sdxSpreadSheetActionInsertPictureHint resource strings.
- InsertRows
Inserts a number of rows matching the absolute height (in cells) of the current selection area. To delete rows, use the DeleteRows command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionInsertRowsCaption and sdxSpreadSheetActionInsertRowsHint resource strings.
- InsertSheet
Inserts a new worksheet into the current spreadsheet document and makes it active. To delete sheets, use the DeleteSheet command. An end-user can reproduce the InsertSheet command’s effect by pressing the Shift+F11 key combination.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionInsertSheetCaption and sdxSpreadSheetActionInsertSheetHint resource strings.
L
- LogicalFormulasGallery
- Implements a gallery populated with functions from the “Logical” category.
- LookupAndReferenceFormulasGallery
- Implements a gallery populated with functions from the “Lookup and Reference” category.
M
- MathAndTrigFormulasGallery
- Implements a gallery populated with functions from the “Math and Trigonometry” category.
- MergeCells
Creates merged cells from all currently selected cell ranges. To split a merged cell, use the UnmergeCells command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionMergeCellsCaption and sdxSpreadSheetActionMergeCellsHint resource strings.
- MergeCellsAcross
Creates merged cells across multiple cells within each individual row that intersects the currently selected cell ranges. To create a merged cell that occupies the entire selected cell range, use the MergeCells and MergeCellsAndCenter commands. The UnmergeCells command splits merged cells into the original worksheet cells.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionMergeCellsAcrossCaption and sdxSpreadSheetActionMergeCellsAcrossHint resource strings.
- MergeCellsAndCenter
Creates merged cells from all currently selected cell ranges and centers their resulting content horizontally at the bottom. To split a merged cell, use the UnmergeCells command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionMergeCellsAndCenterCaption and sdxSpreadSheetActionMergeCellsAndCenterHint resource strings.
- MorePageMargins
Invokes the “Page Setup” dialog with the active “Margins” tab for the active worksheet. Use the MorePaperSizes or PrintTitles command to display this dialog with the active “Page” or “Sheet” tab, respectively.
To localize the command’s Caption, use the sdxSpreadSheetActionMorePageMarginsCaption resource string.
- MorePaperSizes
Invokes the “Page Setup” dialog with the active “Page” tab for the active worksheet. Use the MorePageMargins or PrintTitles command to display this dialog with the active “Margins” or “Sheet” tab, respectively.
To localize the command’s Caption, use the sdxSpreadSheetActionMorePaperSizesCaption resource string.
N
- NewComment
Creates a new comment container for the focused cell. If the cell already has a comment, the NewComment command is not available. To customize or delete existing comments, use the EditComment or DeleteComments command, respectively.
An end-user can reproduce the NewComment command’s effect for a non-commented cell by pressing the Shift+F2 key combination.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionNewCommentCaption and sdxSpreadSheetActionNewCommentHint resource strings.
- NewDocument
Creates a blank spreadsheet that replaces the current content of the control. To save the current document or open an existing file, use the SaveDocumentAs or OpenDocument commands, respectively.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionNewDocumentCaption and sdxSpreadSheetActionNewDocumentHint resource strings.
- NextComment
Moves focus to the nearest comment container located to the right and/or below the current focus position. To move focus in the opposite direction, use the PreviousComment command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionNextCommentCaption and sdxSpreadSheetActionNextCommentHint resource strings.
O
- OpenDocument
Invokes the Open dialog that allows end-users to load a document file into the Spreadsheet control, replacing the active document. To save the current document to a file or create a blank spreadsheet, use the SaveDocumentAs or NewDocument command, respectively.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionOpenDocumentCaption and sdxSpreadSheetActionOpenDocumentHint resource strings.
P
- PageMarginsGallery
- Implements a gallery populated with page margin options.
- PageOrientationGallery
- Implements a gallery populated with page orientation options.
- PageSizeGallery
- Implements a gallery populated with available paper sizes.
- PasteSelection
Pastes the current clipboard content (whether it is a bitmap image, floating container, or cell/cell range) into the active worksheet. To copy or cut the cell/cell range or floating container, use the CopySelection or CutSelection commands. An end-user can reproduce the PasteSelection command’s effect by pressing the Ctrl+V or Shift+Insert key combination.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionPasteSelectionCaption and sdxSpreadSheetActionPasteSelectionHint resource strings.
- PreviousComment
Moves focus to the nearest comment container located to the left and/or above the current focus position. To move focus in the opposite direction, use the NextComment command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionPreviousCommentCaption and sdxSpreadSheetActionPreviousCommentHint resource strings.
- PrintTitles
Invokes the “Page Setup” dialog with the active “Sheet” tab for the active worksheet. Use the MorePageMargins or MorePaperSizes command to display this dialog with the active “Margins” or “Page” tab, respectively.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionPrintTitlesCaption and sdxSpreadSheetActionPrintTitlesHint resource strings.
- ProtectSheet
Enables/disables the active worksheet‘s protection.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionProtectSheetCaption and sdxSpreadSheetActionProtectSheetHint resource strings.
- ProtectWorkbook
Enables/disables the opened spreadsheet document’s protection.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionProtectWorkbookCaption and sdxSpreadSheetActionProtectWorkbookHint resource strings.
R
- Redo
The Undo and Redo commands allow end-users to employ the Spreadsheet control’s history functionality that can be enabled by setting the OptionsBehavior.History property to True.
Link this command to a UI element to allow end-users to redo actions cancelled by using the Undo command or invoking the Spreadsheet control’s History.Undo procedure. UI elements linked to the Redo command are disabled if there are no undone actions within the currently opened document. An end-user can reproduce the Redo command’s effect by pressing the Ctrl+Y key combination.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionRedoCaption and sdxSpreadSheetActionRedoHint resource strings.
- RemovePageBreak
Removes a custom column and/or row page break immediately to the left of and/or above the focused cell, respectively. Use the ResetAllPageBreaks command to remove all custom page breaks.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionRemovePageBreakCaption and sdxSpreadSheetActionRemovePageBreakHint resource strings.
- ResetAllPageBreaks
Removes all custom page breaks from the active worksheet. Use the InsertPageBreak command to create new custom column and row page breaks.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionResetAllPageBreaksCaption and sdxSpreadSheetActionResetAllPageBreaksHint resource strings.
S
- SaveDocumentAs
Invokes the Save dialog that allows end-users to save the current spreadsheet document to a specified file. To open an existing document file or create a blank spreadsheet, use the OpenDocument or NewDocument command, respectively.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionSaveDocumentAsCaption and sdxSpreadSheetActionSaveDocumentAsHint resource strings.
- SetLandscapePageOrientation
- Switches the orientation to landscape for printout pages.
- SetPortraitPageOrientation
- Switches the orientation to portrait for printout pages.
- SetPrintArea
Sets the current cell selection as the active worksheet‘s custom print area.
To localize the command’s caption and hint, use the sdxSpreadSheetActionSetPrintAreaCaption and sdxSpreadSheetActionSetPrintAreaHint resource strings.
- ShowDefinedNameManager
Invokes the “Name Manager” dialog that allows end users to manage defined names in a spreadsheet document.
To localize the command’s Caption, use the sdxSpreadSheetActionShowDefinedNameManagerCaption resource string.
- ShowPageSetupForm
Invokes the Page Setup dialog. Note that the ShowPageSetupForm command requires both the TdxComponentPrinter component and a valid spreadsheet report link.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionPageSetupCaption and sdxSpreadSheetActionPageSetupHint resource strings.
- ShowPrintForm
Invokes the Print dialog. Note that the ShowPrintForm command requires both the TdxComponentPrinter component and a valid spreadsheet report link.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionPrintCaption and sdxSpreadSheetActionPrintHint resource strings.
- ShowPrintPreviewForm
Invokes the Print Preview dialog. Note that the ShowPrintPreviewForm command requires both the TdxComponentPrinter component and a valid spreadsheet report link.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionPrintPreviewCaption and sdxSpreadSheetActionPrintPreviewHint resource strings.
- ShowHideComments
Switches the visibility of all comment containers located in the active worksheet.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionShowHideCommentsCaption and sdxSpreadSheetActionShowHideCommentsHint resource strings.
- ShowHyperlinkEditor
Invokes the Insert Hyperlink or Edit Hyperlink dialog depending on the current selection. An end-user can reproduce the ShowHyperlinkEditor command’s effect by pressing the Ctrl+K key combination.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionShowHyperlinkEditorCaption and sdxSpreadSheetActionShowHyperlinkEditorHint resource strings.
- SortAscending
Sorts cell data within the current selection area against multiple columns in ascending order. To perform sort operation in descending order, use the SortDescending command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionSortAscendingCaption and sdxSpreadSheetActionSortAscendingHint resource strings.
- SortDescending
Sorts cell data within the current selection area against multiple columns in descending order. To perform sort operation in ascending order, use the SortAscending command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionSortDescendingCaption and sdxSpreadSheetActionSortDescendingHint resource strings.
- StatisticalFormulasGallery
- Implements a gallery populated with functions from the “Statistical” category.
T
- TextFormulasGallery
- Implements a gallery populated with functions from the “Text” category.
- TextIndentDecrease
Decreases the horizontal cell text indent by 2 pixels for the current selection. To increase the horizontal indent value, use the TextIndentIncrease command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionTextIndentDecreaseCaption and sdxSpreadSheetActionTextIndentDecreaseHint resource strings.
- TextIndentIncrease
Increases the horizontal cell text indent by 2 pixels for the current selection. To decrease the horizontal indent value, use the TextIndentDecrease command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionTextIndentIncreaseCaption and sdxSpreadSheetActionTextIndentIncreaseHint resource strings.
- TextWrap
Applies/removes the word wrap attribute to the style of all selected cells.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionTextWrapCaption and sdxSpreadSheetActionTextWrapHint resource strings.
- ToggleFontBold
Applies/removes the Bold attribute to/from the current font.
If the in-place text formatting functionality is unavailable, the ToggleFontBold command is applicable only to the current cell selection. Otherwise, end-users can execute this command to format text in an in-place cell editor.
Press the Ctrl+B or Ctrl+2 key combination to reproduce the command’s effect.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionToggleFontBoldCaption and sdxSpreadSheetActionToggleFontBoldHint resource strings.
- ToggleFontItalic
Applies/removes the Italic attribute to/from the current font.
If the in-place text formatting functionality is unavailable, the ToggleFontItalic command is applicable only to the current cell selection. Otherwise, end-users can execute the command to format text in an in-place cell editor.
Press the Ctrl+I or Ctrl+3 key combination to reproduce the command’s effect.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionToggleFontItalicCaption and sdxSpreadSheetActionToggleFontItalicHint resource strings.
- ToggleFontStrikeout
Applies/removes the Strikeout attribute to/from the current font.
If the in-place text formatting functionality is unavailable, the ToggleFontStrikeout command is applicable only to the current cell selection. Otherwise, end-users can execute the command to format text in an in-place cell editor.
The Ctrl+5 key combination reproduces the command’s effect.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionToggleFontStrikeoutCaption and sdxSpreadSheetActionToggleFontStrikeoutHint resource strings.
- ToggleFontUnderline
Applies/removes the Underline attribute to/from the current font.
If the in-place text formatting functionality is unavailable, the ToggleFontUnderline command is applicable only to the current cell selection. Otherwise, end-users can execute the command to format text in an in-place cell editor.
Press the Ctrl+U or Ctrl+4 key combination to reproduce the command’s effect.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionToggleFontUnderlineCaption and sdxSpreadSheetActionToggleFontUnderlineHint resource strings.
U
- Undo
The Undo and Redo commands allow end-users to employ the Spreadsheet control’s history functionality that can be enabled by setting the OptionsBehavior.History property to True.
Link this command to a UI element to allow end-users to undo actions performed within the Spreadsheet control. UI elements linked to the Undo command, are disabled if the currently active document is either unmodified or already returned to the original state by using the Undo command or the Spreadsheet control’s History.Undo procedure. An end-user can reproduce the Undo command’s effect by pressing the Ctrl+Z or Alt+Backspace key combination.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionUndoCaption and sdxSpreadSheetActionUndoHint resource strings.
- UnfreezePanes
Unlocks all frozen columns and rows in the active sheet. To freeze columns and/or rows, use the FreezeFirstColumn, FreezeTopRow, and FreezePanes commands.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionUnfreezePanesCaption and sdxSpreadSheetActionUnfreezePanesHint resource strings.
- UngroupColumns
Ungroups all columns intersecting the current selection area. To ungroup rows, use the UngroupRows command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionUngroupColumnsCaption and sdxSpreadSheetActionUngroupColumnsHint resource strings.
- UngroupRows
Ungroups all rows intersecting the current selection area. To ungroup columns, use the UngroupColumns command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionUngroupRowsCaption and sdxSpreadSheetActionUngroupRowsHint resource strings.
- UnhideColumns
Displays all hidden columns that intersect the current selection area. To hide columns, use the HideColumns command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionUnhideColumnsCaption and sdxSpreadSheetActionUnhideColumnsHint resource strings.
- UnhideRows
Displays all hidden rows that intersect the current selection area. To hide rows, use the HideRows command.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionUnhideRowsCaption and sdxSpreadSheetActionUnhideRowsHint resource strings.
- UnhideSheet
Invokes the Unhide dialog that allows end-users to display previously hidden sheets.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionUnhideSheetCaption and sdxSpreadSheetActionUnhideSheetHint resource strings.
- UnmergeCells
Splits all merged cells in the current selection area. To merge cells, you can use the MergeCells, MergeCellsAcross, and MergeCellsAndCenter commands.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionUnmergeCellsCaption and sdxSpreadSheetActionUnmergeCellsHint resource strings.
- UseDefinedNameInFormula
Creates a new formula expression from a selected defined name in the document or inserts the defined name into an existing formula expression.
To localize the command’s Caption, use the sdxSpreadSheetActionUseDefinedNameInFormulaCaption resource string.
Z
- ZoomDefault
Restores the default zoom factor value for the active worksheet. To zoom the sheet in or out, use the ZoomIn and ZoomOut commands.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionZoomDefaultCaption and sdxSpreadSheetActionZoomDefaultHint resource strings.
- ZoomIn
Zooms the active worksheet in by 10%. To zoom the sheet out or restore the default zoom factor, use the ZoomOut or ZoomDefault command, respectively.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionZoomInCaption and sdxSpreadSheetActionZoomInHint resource strings.
- ZoomOut
Zooms the active worksheet out by 10%. To zoom the sheet in or restore the default zoom factor, use the ZoomIn or ZoomDefault command, respectively.
To localize the command’s Caption and Hint, use the sdxSpreadSheetActionZoomOutCaption and sdxSpreadSheetActionZoomOutHint resource strings.
Report Designer Commands
D
- DataMember
Associates a dataset with the selected report template section. The DataMember command is only a wrapper for a custom implementation.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionDetailDataMemberCaption and sdxSpreadSheetReportDesignerActionDetailDataMemberHint resource strings.
- DesignView
Enables or disables the report template section and placeholder field highlighting.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionDesignViewCaption and sdxSpreadSheetReportDesignerActionDesignViewHint resource strings.
- DetailLevel
Creates a nested detail report template section for building master-detail reports.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionDetailLevelSectionCaption and sdxSpreadSheetReportDesignerActionDetailLevelSectionHint resource strings.
- DetailSection
Creates a detail report template section matching the current cell selection.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionDetailSectionCaption and sdxSpreadSheetReportDesignerActionDetailSectionHint resource strings.
E
- EditFilter
Allows an end-user to specify the data filtering settings. The EditFilter command is only a wrapper for a custom implementation.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionEditFilterCaption and sdxSpreadSheetReportDesignerActionEditFilterHint resource strings.
F
- FooterSection
Creates the common footer report template section matching the current cell selection.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionFooterSectionCaption and sdxSpreadSheetReportDesignerActionFooterSectionHint resource strings.
G
- GroupFooterSection
Creates a group footer section within a detail report template section.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionGroupFooterCaption and sdxSpreadSheetReportDesignerActionGroupFooterHint resource strings.
- GroupHeaderSection
Creates a group header section within a detail report template section.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionGroupHeaderCaption and sdxSpreadSheetReportDesignerActionGroupHeaderHint resource strings.
H
- HeaderSection
Creates the common header report template section matching the current cell selection.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionHeaderSectionCaption and sdxSpreadSheetReportDesignerActionHeaderSectionHint resource strings.
- HorizontalOrientation
Enables the horizontal report orientation mode.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionHorizontalOrientationCaption and sdxSpreadSheetReportDesignerActionHorizontalOrientationHint resource strings.
M
- MultipleDocumentsReportMode
Enables the multiple documents mode, allowing end-users to build master-detail reports on multiple spreadsheet documents.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionMultipleDocumentsReportModeCaption and sdxSpreadSheetReportDesignerActionMultipleDocumentsReportModeHint resource strings.
- MultipleSheetsReportMode
Enables the multiple sheets mode, allowing end-users to build master-detail reports on multiple sheets within a single spreadsheet document.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionMultipleSheetsReportModeCaption and sdxSpreadSheetReportDesignerActionMultipleSheetsReportModeHint resource strings.
R
- ReportPreview
Builds and displays the report preview based on the current template. The ReportPreview command is only a wrapper for a custom implementation.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionReportPreviewCaption and sdxSpreadSheetReportDesignerActionReportPreviewHint resource strings.
- ResetFilter
Clears the data filtering settings.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionResetFilterCaption and sdxSpreadSheetReportDesignerActionResetFilterHint resource strings.
- ResetSection
Deletes a report template section.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionResetSectionCaption and sdxSpreadSheetReportDesignerActionResetSectionHint resource strings.
S
- SingleSheetReportMode
Enables the single sheet mode, allowing end-users to build any reports on a single sheet within the destination spreadsheet document.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionSingleSheetReportModeCaption and sdxSpreadSheetReportDesignerActionSingleSheetReportModeHint resource strings.
- SortFields
The SortFields command is only a wrapper for a custom implementation.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionSortFieldsCaption and sdxSpreadSheetReportDesignerActionSortFieldsHint resource strings.
V
- VerticalOrientation
Enables the vertical report orientation mode.
To localize the command’s Caption and Hint, use the sdxSpreadSheetReportDesignerActionVerticalOrientationCaption and sdxSpreadSheetReportDesignerActionVerticalOrientationHint resource strings.