Represents a ribbon-style toolbar that provides a comprehensive user interface for RadSpreadsheet functionality. Contains tabs and groups organized by feature categories including Home, Insert, Page Layout, Formulas, Data, View, and Review.
Definition
Namespace:Telerik.WinControls.UI
Assembly:Telerik.WinControls.RadSpreadsheet.dll
Syntax:
[TelerikToolboxCategory("Spreadsheet")]
public class RadSpreadsheetRibbonBar : RadRibbonBar, IDropTarget, ISynchronizeInvoke, IWin32Window, IBindableComponent, IComponent, IDisposable, INotifyPropertyChanged, ISupportInitializeNotification, ISupportInitialize, IComponentTreeHandler, ILayoutHandler, IAnalyticsProvider
Inheritance: objectMarshalByRefObjectComponentControlScrollableControlRadControlRadNonClientUIControlRadRibbonBarRadSpreadsheetRibbonBar...
Implements:
Inherited Members
Constructors
Initializes a new instance of the RadSpreadsheetRibbonBar class with default settings and UI components.
public RadSpreadsheetRibbonBar()
Fields
protected RadRibbonBarButtonGroup accountingFormatPercentCommaStylesButtonGroup
protected RadMenuSeparatorItem accountingNumberFormatMenuSeparatorItem
protected RadSplitButtonElement accountingNumberFormatSplitButton
protected RadButtonElement addHyperlinkButton
protected RadMenuItem addToPrintAreaMenuItem
protected RadRibbonBarButtonGroup alignmentButtonGroup
protected RibbonBarGroupSeparator alignmentGroupSeparator
protected RadMenuItem autoFitColumnsWidthMenuItem
protected RadMenuItem autoFitRowsHeightMenuItem
protected RadDropDownButtonElement autoSumDropDownButton
protected RadMenuSeparatorItem autoSumMenuSeparatorItem
protected RadMenuItem averageMenuItem
protected BackstageButtonItem backstageButtonNew
protected BackstageButtonItem backstageButtonOpen
protected BackstageButtonItem backstageButtonPrint
protected BackstageButtonItem backstageButtonSave
protected RadToggleButtonElement bottomAlignToggleButton
protected RadMenuItem bringForwardMenuItem
protected RadSplitButtonElement bringForwardSplitButton
protected RadMenuItem bringToFrontMenuItem
protected RadButtonElement buttonBackColor
protected RadButtonElement buttonDecreaseFontSize
protected RadRibbonBarButtonGroup buttonGroupBackHighlightColors
protected RadRibbonBarButtonGroup buttonGroupCutCopy
protected RadRibbonBarButtonGroup buttonGroupFontFontSizeIncreaseDecreaseFont
protected RadRibbonBarButtonGroup buttonGroupFontStyles
protected RadRibbonBarButtonGroup buttonGroupFontStylesBordersBackForeColors
protected RadRibbonBarButtonGroup buttonGroupIncreaseDecreaseFont
protected RadButtonElement buttonHighlightColor
protected RadButtonElement buttonIncreaseFontSize
protected RadButtonElement buttonQARedo
protected RadButtonElement buttonQASave
protected RadButtonElement buttonQAUndo
protected RadMenuHeaderItem cellsSizeMenuHeaderItem
protected RadToggleButtonElement centerAlignToggleButton
protected RadMenuItem chineseFormatMenuItem
protected RadMenuItem circleInvalidDataMenuItem
protected RadMenuItem clearAllMenuItem
protected RadMenuItem clearContentsMenuItem
protected RadDropDownButtonElement clearDropDownButton
protected RadButtonElement clearFiltersButton
protected RadMenuItem clearFiltersMenuItem
protected RadMenuItem clearFormatsMenuItem
protected RadMenuItem clearHyperlinksMenuItem
protected RadMenuSeparatorItem clearMenuSeparatorItem
protected RadMenuItem clearPrintAreaMenuItem
protected RadMenuItem clearValidationCirclesMenuItem
protected RadRibbonBarButtonGroup colorsAndFontsButtonGroup
protected ThemeColorDropDownButtonElement colorsDropDownButton
protected RadButtonElement commaStyleButton
protected RadButtonElement copyButton
protected RadMenuItem customSortMenuItem
protected RadButtonElement cutButton
protected RadRibbonBarButtonGroup dataTabFilterButtonGroup
protected RadSplitButtonElement dataValidationSplitButton
protected RadDropDownButtonElement dateAndTimeDropDownButton
protected RadButtonElement decreaseDecimalButton
protected RadButtonElement decreaseIndentButton
protected RadRibbonBarButtonGroup definedNamesButtonGroup
protected RadSplitButtonElement defineNameSplitButton
protected RadDropDownButtonElement deleteCellsDropDownButton
protected RadMenuItem deleteCellsMenuItem
protected RadMenuSeparatorItem deleteCellsMenuSeparatorItem1
protected RadMenuSeparatorItem deleteCellsMenuSeparatorItem2
protected RadMenuItem deleteSheetColumnsMenuItem
protected RadMenuItem deleteSheetMenuItem
protected RadMenuItem deleteSheetRowsMenuItem
protected RadDropDownListElement dropDownListFont
protected RadDropDownListElement dropDownListFontSize
protected RadRibbonBarButtonGroup editingFillClearButtonGroup
protected RadMenuItem engineeringFunctionsMenuItem
protected RadMenuItem englishUKFormatMenuItem
protected RadMenuItem englishUSFormatMenuItem
protected RadMenuItem euroFormatMenuItem
protected RadMenuItem fillDownMenuItem
protected RadDropDownButtonElement fillDropDownButton
protected RadMenuItem fillLeftMenuItem
protected RadMenuItem fillRightMenuItem
protected RadMenuItem fillSeriesMenuItem
protected RadMenuItem fillUpMenuItem
protected RadRibbonBarButtonGroup filterButtonGroup
protected RadToggleButtonElement filterToggleButton
protected RadDropDownButtonElement financialDropDownButton
protected RadButtonElement findButton
protected RadMenuItem flipHorizontalMenuItem
protected RadMenuItem flipVerticalMenuItem
protected ThemeFontDropDownButtonElement fontsDropDownButton
protected RadDropDownButtonElement formatCellsDropDownButton
protected RadMenuSeparatorItem formatCellsMenuSeparatorItem1
protected RadMenuSeparatorItem formatCellsMenuSeparatorItem2
protected RadMenuSeparatorItem formatCellsMenuSeparatorItem3
protected RibbonTab formulasTab
protected RadMenuItem freezeFirstColumnMenuItem
protected RadDropDownButtonElement freezePanesDropDownButton
protected RadMenuItem freezePanesMenuItem
protected RadMenuItem freezeTopRowMenuItem
protected RadMenuItem frenchFormatMenuItem
protected RibbonBarGroupSeparator functionLybraryGroupSeparator
protected RadRibbonBarButtonGroup functionsLibraryButtonGroup
protected RadRibbonBarButtonGroup gridLinesButtonGroup
protected RadLabelElement gridlinesLabel
protected RadRibbonBarGroup groupAlignment
protected RadRibbonBarGroup groupArrange
protected RadRibbonBarGroup groupCells
protected RadRibbonBarGroup groupChanges
protected RadRibbonBarGroup groupCharts
protected RadRibbonBarGroup groupClipboard
protected RadRibbonBarGroup groupDataTools
protected RadRibbonBarGroup groupDefinedNames
protected RadRibbonBarGroup groupEditing
protected RadRibbonBarGroup groupFont
protected RadRibbonBarGroup groupFunctionLibrary
protected RadRibbonBarGroup groupIllustrations
protected RadRibbonBarGroup groupLinks
protected RadRibbonBarGroup groupNumber
protected RadRibbonBarGroup groupPageSetup
protected RadRibbonBarGroup groupSheetOptions
protected RadRibbonBarGroup groupSize
protected RadRibbonBarGroup groupSortAndFilter
protected RadRibbonBarGroup groupStyles
protected RadRibbonBarGroup groupThemes
protected RadRibbonBarGroup groupWindow
protected RadRibbonBarButtonGroup headingsButtonGroup
protected RadLabelElement headingsLabel
protected RadMenuItem hideColumnsMenuItem
protected RadMenuItem hideRowsMenuItem
protected RadRibbonBarButtonGroup horizontalAlignmentButtonGroup
protected RadRibbonBarButtonGroup horizontalAlignmentIncreaseDecreaseIndentButtonGroup
protected RadRibbonBarButtonGroup horizontalVerticalAlignIndentButtonGroup
protected RadRibbonBarButtonGroup imageHeightButtonGroup
protected RadLabelElement imageHeightLabel
public RadSpinElement imageHeightSpinEditor
protected RadRibbonBarButtonGroup imageWidthButtonGroup
protected RadLabelElement imageWidthLabel
public RadSpinElement imageWidthSpinEditor
protected RadButtonElement increaseDecimalButton
protected RadRibbonBarButtonGroup increaseDecreaseDecimalButtonGroup
protected RadRibbonBarButtonGroup increaseDecreaseIndentButtonGroup
protected RadButtonElement increaseIndentButton
protected RadMenuItem informationFunctionsMenuItem
protected RadDropDownButtonElement insertCellsDropDownButton
protected RadMenuItem insertCellsMenuItem
protected RadMenuSeparatorItem insertCellsMenuSeparatorItem1
protected RadMenuSeparatorItem insertCellsMenuSeparatorItem2
protected RadButtonElement insertChartButton
protected RadButtonElement insertFunctionButton
protected RadMenuItem insertPageBreakMenuItem
protected RadButtonElement insertPictureButton
protected RadMenuItem insertSheetColumnsMenuItem
protected RadMenuItem insertSheetMenuItem
protected RadMenuItem insertSheetRowsMenuItem
protected RadToggleButtonElement leftAlignToggleButton
protected RadDropDownButtonElement logicalDropDownButton
protected RadDropDownButtonElement lookupAndReferenceDropDownButton
protected RadDropDownButtonElement mathAndTrigDropDownButton
protected RadMenuItem maxMenuItem
protected RadMenuItem mergeAcrossMenuItem
protected RadMenuItem mergeAndCenterMenuItem
protected RadSplitButtonElement mergeAndCenterSplitButton
protected RadMenuItem mergeCellsMenuItem
protected RadToggleButtonElement middleAlignToggleButton
protected RadMenuItem minMenuItem
protected RadMenuItem moreFormatsMenuItem
protected RadDropDownButtonElement moreFunctionsDropDownButton
protected RadMenuItem moreFunctionsMenuItem
protected RadDropDownListElement numberFormatDropDownList
protected RadRibbonBarButtonGroup numberFormatIncreaseDecreaseDecimalButtonGroup
protected RibbonTab openTabCache
protected RadMenuHeaderItem otherPasteOptionsMenuHeaderItem
protected RadDropDownButtonElement pageBreaksDropDownButton
protected RadMenuSeparatorItem pageBreaksMenuSeparatorItem
protected RibbonTab pageLayoutTab
protected RadSplitButtonElement pasteButton
protected RadMenuItem pasteColumnWidthsMenuItem
protected RadMenuItem pasteFormattingMenuItem
protected RadMenuItem pasteFormulasMenuItem
protected RadMenuItem pasteFormulasNumberFormattingMenuItem
protected RadMenuHeaderItem pasteMenuHeaderItem
protected RadMenuItem pasteMenuItem
protected RadMenuHeaderItem pasteValuesMenuHeaderItem
protected RadMenuItem pasteValuesMenuItem
protected RadMenuItem pasteValuesNumberFormattingMenuItem
protected RadButtonElement percentStyleButton
protected ContextualTabGroup pictureToolsContextualTabGroup
protected RadDropDownButtonElement printAreaDropDownButton
protected RadCheckBoxElement printGridlinesCheckBox
protected RadCheckBoxElement printRowColumnHeadingsCheckBox
protected RadButtonElement protectSheetButton
protected RadButtonElement protectWorkbookButton
protected RadOffice2007ScreenTipElement radOffice2007ScreenTipElement1
protected RadRibbonBarBackstageView radRibbonBarBackstageView1
protected RadButtonElement reapplyFiltersButton
protected RadMenuItem reapplyFiltersMenuItem
protected RadDropDownButtonElement recentlyUsedDropDownButton
protected RadMenuItem removeHyperlinkMenuItem
protected RadMenuItem removePageBreakMenuItem
protected RadMenuItem resetAllPageBreaksMenuItem
protected RadToggleButtonElement rightAlignToggleButton
protected RadDropDownButtonElement rotateDropDownButton
protected RadMenuItem rotateLeft90MenuItem
protected RadMenuItem rotateRight90MenuItem
protected RadMenuItem sendBackwardMenuItem
protected RadSplitButtonElement sendBackwardSplitButton
protected RadMenuItem sendToBackMenuItem
protected RadMenuItem setColumnsWidthMenuItem
protected RadMenuItem setDefaultColumnWidthMenuItem
protected RadMenuItem setDefaultRowHeightMenuItem
protected RadMenuItem setFilterMenuItem
protected RadMenuItem setPrintAreaMenuItem
protected RadMenuItem setRowsHeightMenuItem
protected RadRibbonBarButtonGroup sheetOptionsButtonGroup
protected RibbonBarGroupSeparator sheetOptionsGroupSeparator
protected RadMenuItem showCreateDefinedNameDialogMenuItem
protected RadMenuItem showDataValidationDialogMenuItem
protected RadMenuItem showFormatCellsDialogMenuItem
protected RadCheckBoxElement showGridlinesCheckBox
protected RadButtonElement showNameManagerButton
protected RadCheckBoxElement showRowColumnHeadingsCheckBox
protected RadRibbonBarButtonGroup sortAcsDescButtonGroup
protected RadRibbonBarButtonGroup sortAndFilterButtonGroup
protected RadDropDownButtonElement sortAndFilterDropDownButton
protected RibbonBarGroupSeparator sortAndFilterGroupSeparator
protected RadMenuSeparatorItem sortAndFilterMenuSeparatorItem
protected RadButtonElement sortAscendingButton
protected RadMenuItem sortAscendingMenuItem
protected RadButtonElement sortButton
protected RadRibbonBarButtonGroup sortButtonGroup
protected RadButtonElement sortDescendingButton
protected RadMenuItem sortDescendingMenuItem
protected RadMenuItem statisticalFunctionsMenuItem
protected SpreadsheetStylesGalleryElement stylesGallery
protected RadMenuItem sumMenuItem
protected RadDropDownButtonElement textDropDownButton
protected RadToggleButtonElement toggleButtonBoldStyle
protected RadToggleButtonElement toggleButtonItalicStyle
protected RadToggleButtonElement toggleButtonUnderlineStyle
protected RadToggleButtonElement topAlignToggleButton
protected RadMenuItem unfreezePanesMenuItem
protected RadMenuItem unhideColumnsMenuItem
protected RadMenuItem unhideRowsMenuItem
protected RadMenuItem unmergeCellsMenuItem
protected RadRibbonBarButtonGroup verticalAlignmentButtonGroup
protected RadRibbonBarButtonGroup verticalAlignmentTopLevelButtonGroup
protected RadRibbonBarButtonGroup wrapTextAndMergeButtonGroup
protected RadToggleButtonElement wrapTextToggleButton
Properties
Gets or sets the RadSpreadsheet control that this ribbon bar is associated with for command execution and data binding.
public RadSpreadsheet AssociatedSpreadsheet { get; set; }
Gets or sets a value indicating whether the toggle switch for enabling the Simplified ribbon style is visible.
[Browsable(true)]
public override bool ShowLayoutModeButton { get; set; }
Overrides:
Gets the theme class name used for theming this control.
public override string ThemeClassName { get; }
Overrides:
Methods
protected virtual void bottomAlignToggleButton_ToggleStateChanged(object sender, StateChangedEventArgs args)
protected virtual void BringForward_PropertyChanged(object sender, PropertyChangedEventArgs e)
protected virtual void CallShowInsertFunctionDialogCommand(object parameter)
protected virtual void centerAlignToggleButton_ToggleStateChanged(object sender, StateChangedEventArgs args)
Creates a spin element with standard configuration for numeric input in the ribbon.
protected virtual RadSpinElement CreateSpinElement(string name)
The name to assign to the spin element.
Returns:A configured RadSpinElement instance.
Clean up any resources being used.
protected override void Dispose(bool disposing)
true if managed resources should be disposed; otherwise, false.
Overrides:
protected virtual void dropDownListFont_SelectedIndexChanged(object sender, PositionChangedEventArgs e)
protected virtual void dropDownListFontSize_SelectedIndexChanged(object sender, PositionChangedEventArgs e)
protected virtual void filterToggleButton_ToggleStateChanged(object sender, StateChangedEventArgs args)
Gets the list of available font family names for use in the font dropdown.
protected virtual IList<string> GetFontFamilyItems()
IList<string>
A list of font family names.
Gets the list of standard font sizes for use in the font size dropdown.
protected virtual void leftAlignToggleButton_ToggleStateChanged(object sender, StateChangedEventArgs args)
protected virtual void middleAlignToggleButton_ToggleStateChanged(object sender, StateChangedEventArgs args)
protected virtual void numberFormatDropDownList_SelectedIndexChanged(object sender, PositionChangedEventArgs e)
Called when the binding context changes, allowing for reinitialization of ribbon element values.
protected override void OnBindingContextChanged(EventArgs e)
The event arguments.
Overrides:
Called when the control's theme changes, updating icon sets based on whether the theme is dark or light.
protected override void OnThemeChanged()
Overrides:
protected virtual void PictureToolsTab_PropertyChanged(object sender, PropertyChangedEventArgs e)
protected virtual void printGridlinesCheckBox_ToggleStateChanged(object sender, StateChangedEventArgs args)
protected virtual void rightAlignToggleButton_ToggleStateChanged(object sender, StateChangedEventArgs args)
protected virtual void SendBackward_PropertyChanged(object sender, PropertyChangedEventArgs e)
Applies dark-themed icons to all ribbon elements for use with dark themes.
public virtual void SetDarkIcons()
public virtual void SetDarkSvgIcons()
protected virtual void SetFontFamily_PropertyChanged(object sender, PropertyChangedEventArgs e)
protected virtual void SetFontSize_PropertyChanged(object sender, PropertyChangedEventArgs e)
protected virtual void SetFormat_PropertyChanged(object sender, PropertyChangedEventArgs e)
protected virtual void SetHorizontalAlignment_PropertyChanged(object sender, PropertyChangedEventArgs e)
protected virtual void SetIsBold_PropertyChanged(object sender, PropertyChangedEventArgs e)
protected virtual void SetIsItalic_PropertyChanged(object sender, PropertyChangedEventArgs e)
protected virtual void SetShapeHeight_PropertyChanged(object sender, PropertyChangedEventArgs e)
protected virtual void SetShapeWidth_PropertyChanged(object sender, PropertyChangedEventArgs e)
Applies standard light-themed icons to all ribbon elements.
public virtual void SetStandardIcons()
Applies standard light-themed SVG icons to all ribbon elements.
public virtual void SetStandardSvgIcons()
protected virtual void SetUnderline_PropertyChanged(object sender, PropertyChangedEventArgs e)
protected virtual void SetVerticalAlignment_PropertyChanged(object sender, PropertyChangedEventArgs e)
protected virtual void showGridlinesCheckBox_ToggleStateChanged(object sender, StateChangedEventArgs args)
protected virtual void toggleButtonBoldStyle_ToggleStateChanged(object sender, StateChangedEventArgs args)
protected virtual void toggleButtonItalicStyle_ToggleStateChanged(object sender, StateChangedEventArgs args)
protected virtual void toggleButtonUnderlineStyle_ToggleStateChanged(object sender, StateChangedEventArgs args)
protected virtual void topAlignToggleButton_ToggleStateChanged(object sender, StateChangedEventArgs args)
protected virtual void wrapTextToggleButton_ToggleStateChanged(object sender, StateChangedEventArgs args)