This example demonstrates how to bind a cell range on a worksheet to the sample Northwind database to load data from the Suppliers data table.
Implementation Details
To accomplish this task, call the WorksheetDataBindingCollection.BindToDataSource method.
This application also enables users to add, modify or remove data in a data table. They can use the corresponding buttons on the File tab, in the Database group to edit the data and save their changes back to the database.
To insert new rows, a data entry form is used. The user should fill out given data entry fields and click the Save cell to add a new record to the Suppliers data table. Clicking the Apply Changes button posts the updated data back to the database. To remove a record, the user should select the required Suppliers row on the worksheet and click the Remove Record button. The Delete dialog will be invoked asking the user to confirm the delete operation.
To send the modified data to the connected database, the Update method of the SuppliersTableAdapter is used.
Files to Review
Documentation
Does this example address your development requirements/objectives?
(you will be redirected to DevExpress.com to submit your response)
Example Code
XAML<dxr:DXRibbonWindow
xmlns:dxr="http://schemas.devexpress.com/winfx/2008/xaml/ribbon"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:local="clr-namespace:WpfSpreadsheet_BindToDataSource"
xmlns:dxb="http://schemas.devexpress.com/winfx/2008/xaml/bars"
xmlns:dxsps="http://schemas.devexpress.com/winfx/2008/xaml/spreadsheet"
xmlns:Custom="http://schemas.devexpress.com/winfx/2008/xaml/richedit"
xmlns:dxe="http://schemas.devexpress.com/winfx/2008/xaml/editors" xmlns:dx="http://schemas.devexpress.com/winfx/2008/xaml/core" x:Class="WpfSpreadsheet_BindToDataSource.MainWindow" mc:Ignorable="d" Title="Northwind Suppliers Example" Height="527" Width="918"
>
<Grid>
<dxb:BarManager x:Name="barManager1" ToolbarGlyphSize="Small">
<dxb:BarManager.Resources>
<dxsps:SpreadsheetUICommand x:Key="commands" />
<dxsps:SpreadsheetStringIdConverter x:Key="stringIdConverter" />
<dxsps:SpreadsheetDefaultBarItemDataTemplates x:Key="defaultBarItemTemplates" />
</dxb:BarManager.Resources>
<dxb:BarManager.Items>
<dxb:BarButtonItem x:Name="biFileNew" Command="{Binding FileNew, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFileOpen" Command="{Binding FileOpen, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFileSave" Command="{Binding FileSave, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFileSaveAs" Command="{Binding FileSaveAs, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFileQuickPrint" Command="{Binding FileQuickPrint, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFilePrint" Command="{Binding FilePrint, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFilePrintPreview" Command="{Binding FilePrintPreview, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFileUndo" Command="{Binding FileUndo, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFileRedo" Command="{Binding FileRedo, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFileEncrypt" Command="{Binding FileEncrypt, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFileShowDocumentProperties" Command="{Binding FileShowDocumentProperties, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biEditPaste" Command="{Binding EditPaste, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biEditCut" Command="{Binding EditCut, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithText" />
<dxb:BarButtonItem x:Name="biEditCopy" Command="{Binding EditCopy, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithText" />
<dxb:BarButtonItem x:Name="biEditPasteSpecial" Command="{Binding EditPasteSpecial, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithText" />
<dxr:BarButtonGroup x:Name="biFont">
<dxr:BarButtonGroup.ItemLinks>
<dxb:BarEditItemLink BarItemName="biFormatFontName" />
<dxb:BarEditItemLink BarItemName="biFormatFontSize" />
<dxb:BarButtonItemLink BarItemName="biFormatIncreaseFontSize" />
<dxb:BarButtonItemLink BarItemName="biFormatDecreaseFontSize" />
</dxr:BarButtonGroup.ItemLinks>
</dxr:BarButtonGroup>
<dxb:BarEditItem x:Name="biFormatFontName" Content="" Command="{Binding FormatFontName, Mode=OneTime, Source={StaticResource commands}}" EditWidth="150">
<dxb:BarEditItem.EditSettings>
<Custom:FontComboBoxEditSettings />
</dxb:BarEditItem.EditSettings>
</dxb:BarEditItem>
<dxb:BarEditItem x:Name="biFormatFontSize" Content="" Command="{Binding FormatFontSize, Mode=OneTime, Source={StaticResource commands}}" EditWidth="50">
<dxb:BarEditItem.EditSettings>
<Custom:FontSizeComboBoxEditSettings OfficeFontSizeProvider="{Binding ElementName=spreadsheetControl}" />
</dxb:BarEditItem.EditSettings>
</dxb:BarEditItem>
<dxb:BarButtonItem x:Name="biFormatIncreaseFontSize" Command="{Binding FormatIncreaseFontSize, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatDecreaseFontSize" Command="{Binding FormatDecreaseFontSize, Mode=OneTime, Source={StaticResource commands}}" />
<dxr:BarButtonGroup x:Name="biFontShape">
<dxr:BarButtonGroup.ItemLinks>
<dxb:BarCheckItemLink BarItemName="biFormatFontBold" />
<dxb:BarCheckItemLink BarItemName="biFormatFontItalic" />
<dxb:BarCheckItemLink BarItemName="biFormatFontUnderline" />
<dxb:BarCheckItemLink BarItemName="biFormatFontStrikeout" />
</dxr:BarButtonGroup.ItemLinks>
</dxr:BarButtonGroup>
<dxb:BarCheckItem x:Name="biFormatFontBold" Command="{Binding FormatFontBold, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarCheckItem x:Name="biFormatFontItalic" Command="{Binding FormatFontItalic, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarCheckItem x:Name="biFormatFontUnderline" Command="{Binding FormatFontUnderline, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarCheckItem x:Name="biFormatFontStrikeout" Command="{Binding FormatFontStrikeout, Mode=OneTime, Source={StaticResource commands}}" />
<dxr:BarButtonGroup x:Name="biFontColor">
<dxr:BarButtonGroup.ItemLinks>
<Custom:BarSplitButtonColorEditItemLink BarItemName="biFormatFontColor" />
<Custom:BarSplitButtonColorEditItemLink BarItemName="biFormatFillColor" />
</dxr:BarButtonGroup.ItemLinks>
</dxr:BarButtonGroup>
<Custom:BarSplitButtonColorEditItem x:Name="biFormatFontColor" Command="{Binding FormatFontColor, Mode=OneTime, Source={StaticResource commands}}">
<dxb:PopupControlContainerInfo>
<dxe:ColorEdit EditValue="{Binding EditValue, ElementName=biFormatFontColor, Mode=TwoWay}" ShowBorder="False" />
</dxb:PopupControlContainerInfo>
</Custom:BarSplitButtonColorEditItem>
<Custom:BarSplitButtonColorEditItem x:Name="biFormatFillColor" Command="{Binding FormatFillColor, Mode=OneTime, Source={StaticResource commands}}">
<dxb:PopupControlContainerInfo>
<dxe:ColorEdit EditValue="{Binding EditValue, ElementName=biFormatFillColor, Mode=TwoWay}" ShowBorder="False" />
</dxb:PopupControlContainerInfo>
</Custom:BarSplitButtonColorEditItem>
<dxr:BarButtonGroup x:Name="bi">
<dxr:BarButtonGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biFormatBordersCommandGroup" />
</dxr:BarButtonGroup.ItemLinks>
</dxr:BarButtonGroup>
<dxb:BarSubItem x:Name="biFormatBordersCommandGroup" Command="{Binding FormatBordersCommandGroup, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithoutText">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biFormatBottomBorder" />
<dxb:BarButtonItemLink BarItemName="biFormatTopBorder" />
<dxb:BarButtonItemLink BarItemName="biFormatLeftBorder" />
<dxb:BarButtonItemLink BarItemName="biFormatRightBorder" />
<dxb:BarButtonItemLink BarItemName="biFormatNoBorders" />
<dxb:BarButtonItemLink BarItemName="biFormatAllBorders" />
<dxb:BarButtonItemLink BarItemName="biFormatOutsideBorders" />
<dxb:BarButtonItemLink BarItemName="biFormatThickBorder" />
<dxb:BarButtonItemLink BarItemName="biFormatBottomDoubleBorder" />
<dxb:BarButtonItemLink BarItemName="biFormatBottomThickBorder" />
<dxb:BarButtonItemLink BarItemName="biFormatTopAndBottomBorder" />
<dxb:BarButtonItemLink BarItemName="biFormatTopAndThickBottomBorder" />
<dxb:BarButtonItemLink BarItemName="biFormatTopAndDoubleBottomBorder" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biFormatBottomBorder" Command="{Binding FormatBottomBorder, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatTopBorder" Command="{Binding FormatTopBorder, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatLeftBorder" Command="{Binding FormatLeftBorder, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatRightBorder" Command="{Binding FormatRightBorder, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatNoBorders" Command="{Binding FormatNoBorders, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatAllBorders" Command="{Binding FormatAllBorders, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatOutsideBorders" Command="{Binding FormatOutsideBorders, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatThickBorder" Command="{Binding FormatThickBorder, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatBottomDoubleBorder" Command="{Binding FormatBottomDoubleBorder, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatBottomThickBorder" Command="{Binding FormatBottomThickBorder, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatTopAndBottomBorder" Command="{Binding FormatTopAndBottomBorder, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatTopAndThickBottomBorder" Command="{Binding FormatTopAndThickBottomBorder, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatTopAndDoubleBottomBorder" Command="{Binding FormatTopAndDoubleBottomBorder, Mode=OneTime, Source={StaticResource commands}}" />
<dxr:BarButtonGroup x:Name="biVerticalAlignment">
<dxr:BarButtonGroup.ItemLinks>
<dxb:BarCheckItemLink BarItemName="biFormatAlignmentTop" />
<dxb:BarCheckItemLink BarItemName="biFormatAlignmentMiddle" />
<dxb:BarCheckItemLink BarItemName="biFormatAlignmentBottom" />
</dxr:BarButtonGroup.ItemLinks>
</dxr:BarButtonGroup>
<dxb:BarCheckItem x:Name="biFormatAlignmentTop" Command="{Binding FormatAlignmentTop, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarCheckItem x:Name="biFormatAlignmentMiddle" Command="{Binding FormatAlignmentMiddle, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarCheckItem x:Name="biFormatAlignmentBottom" Command="{Binding FormatAlignmentBottom, Mode=OneTime, Source={StaticResource commands}}" />
<dxr:BarButtonGroup x:Name="biHorizontalAlignment">
<dxr:BarButtonGroup.ItemLinks>
<dxb:BarCheckItemLink BarItemName="biFormatAlignmentLeft" />
<dxb:BarCheckItemLink BarItemName="biFormatAlignmentCenter" />
<dxb:BarCheckItemLink BarItemName="biFormatAlignmentRight" />
</dxr:BarButtonGroup.ItemLinks>
</dxr:BarButtonGroup>
<dxb:BarCheckItem x:Name="biFormatAlignmentLeft" Command="{Binding FormatAlignmentLeft, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarCheckItem x:Name="biFormatAlignmentCenter" Command="{Binding FormatAlignmentCenter, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarCheckItem x:Name="biFormatAlignmentRight" Command="{Binding FormatAlignmentRight, Mode=OneTime, Source={StaticResource commands}}" />
<dxr:BarButtonGroup x:Name="biIndent">
<dxr:BarButtonGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biFormatDecreaseIndent" />
<dxb:BarButtonItemLink BarItemName="biFormatIncreaseIndent" />
</dxr:BarButtonGroup.ItemLinks>
</dxr:BarButtonGroup>
<dxb:BarButtonItem x:Name="biFormatDecreaseIndent" Command="{Binding FormatDecreaseIndent, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatIncreaseIndent" Command="{Binding FormatIncreaseIndent, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarCheckItem x:Name="biFormatWrapText" Command="{Binding FormatWrapText, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithText" />
<dxb:BarSubItem x:Name="biEditingMergeCellsCommandGroup" Command="{Binding EditingMergeCellsCommandGroup, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithText">
<dxb:BarSubItem.ItemLinks>
<dxb:BarCheckItemLink BarItemName="biEditingMergeAndCenterCells" />
<dxb:BarButtonItemLink BarItemName="biEditingMergeCellsAcross" />
<dxb:BarButtonItemLink BarItemName="biEditingMergeCells" />
<dxb:BarButtonItemLink BarItemName="biEditingUnmergeCells" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarCheckItem x:Name="biEditingMergeAndCenterCells" Command="{Binding EditingMergeAndCenterCells, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biEditingMergeCellsAcross" Command="{Binding EditingMergeCellsAcross, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biEditingMergeCells" Command="{Binding EditingMergeCells, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biEditingUnmergeCells" Command="{Binding EditingUnmergeCells, Mode=OneTime, Source={StaticResource commands}}" />
<dxr:BarButtonGroup x:Name="biFormatNumbers">
<dxr:BarButtonGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biFormatNumberAccountingCommandGroup" />
<dxb:BarButtonItemLink BarItemName="biFormatNumberPercent" />
<dxb:BarButtonItemLink BarItemName="biFormatNumberAccounting" />
</dxr:BarButtonGroup.ItemLinks>
</dxr:BarButtonGroup>
<dxb:BarSubItem x:Name="biFormatNumberAccountingCommandGroup" Command="{Binding FormatNumberAccountingCommandGroup, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithoutText">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biFormatNumberAccountingUS" />
<dxb:BarButtonItemLink BarItemName="biFormatNumberAccountingUK" />
<dxb:BarButtonItemLink BarItemName="biFormatNumberAccountingEuro" />
<dxb:BarButtonItemLink BarItemName="biFormatNumberAccountingPRC" />
<dxb:BarButtonItemLink BarItemName="biFormatNumberAccountingSwiss" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biFormatNumberAccountingUS" Command="{Binding FormatNumberAccountingUS, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatNumberAccountingUK" Command="{Binding FormatNumberAccountingUK, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatNumberAccountingEuro" Command="{Binding FormatNumberAccountingEuro, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatNumberAccountingPRC" Command="{Binding FormatNumberAccountingPRC, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatNumberAccountingSwiss" Command="{Binding FormatNumberAccountingSwiss, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatNumberPercent" Command="{Binding FormatNumberPercent, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatNumberAccounting" Command="{Binding FormatNumberAccounting, Mode=OneTime, Source={StaticResource commands}}" />
<dxr:BarButtonGroup x:Name="biFormatNumberDecimals">
<dxr:BarButtonGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biFormatNumberIncreaseDecimal" />
<dxb:BarButtonItemLink BarItemName="biFormatNumberDecreaseDecimal" />
</dxr:BarButtonGroup.ItemLinks>
</dxr:BarButtonGroup>
<dxb:BarButtonItem x:Name="biFormatNumberIncreaseDecimal" Command="{Binding FormatNumberIncreaseDecimal, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatNumberDecreaseDecimal" Command="{Binding FormatNumberDecreaseDecimal, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biConditionalFormattingCommandGroup" Command="{Binding ConditionalFormattingCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarSubItemLink BarItemName="biConditionalFormattingHighlightCellsCommandGroup" />
<dxb:BarSubItemLink BarItemName="biConditionalFormattingTopBottomCommandGroup" />
<dxb:BarSubItemLink BarItemName="biConditionalFormattingDataBarsCommandGroup" />
<dxb:BarSubItemLink BarItemName="biConditionalFormattingColorScalesCommandGroup" />
<dxb:BarSubItemLink BarItemName="biConditionalFormattingIconSetsCommandGroup" />
<dxb:BarButtonItemLink BarItemName="biNewConditionalFormattingRule" />
<dxb:BarSubItemLink BarItemName="biConditionalFormattingRemoveCommandGroup" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarSubItem x:Name="biConditionalFormattingHighlightCellsCommandGroup" Command="{Binding ConditionalFormattingHighlightCellsCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingGreaterThan" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingLessThan" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingBetween" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingEqual" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingTextContains" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingDateOccurring" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingDuplicateValues" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biConditionalFormattingGreaterThan" Command="{Binding ConditionalFormattingGreaterThan, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingLessThan" Command="{Binding ConditionalFormattingLessThan, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingBetween" Command="{Binding ConditionalFormattingBetween, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingEqual" Command="{Binding ConditionalFormattingEqual, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingTextContains" Command="{Binding ConditionalFormattingTextContains, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingDateOccurring" Command="{Binding ConditionalFormattingDateOccurring, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingDuplicateValues" Command="{Binding ConditionalFormattingDuplicateValues, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biConditionalFormattingTopBottomCommandGroup" Command="{Binding ConditionalFormattingTopBottomCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingTop10Items" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingTop10Percent" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingBottom10Items" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingBottom10Percent" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingAboveAverage" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingBelowAverage" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biConditionalFormattingTop10Items" Command="{Binding ConditionalFormattingTop10Items, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingTop10Percent" Command="{Binding ConditionalFormattingTop10Percent, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingBottom10Items" Command="{Binding ConditionalFormattingBottom10Items, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingBottom10Percent" Command="{Binding ConditionalFormattingBottom10Percent, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingAboveAverage" Command="{Binding ConditionalFormattingAboveAverage, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingBelowAverage" Command="{Binding ConditionalFormattingBelowAverage, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biConditionalFormattingDataBarsCommandGroup" Command="{Binding ConditionalFormattingDataBarsCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarSubItemLink BarItemName="biConditionalFormattingDataBarsGradientFillCommandGroup" />
<dxb:BarSubItemLink BarItemName="biConditionalFormattingDataBarsSolidFillCommandGroup" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarSubItem x:Name="biConditionalFormattingDataBarsGradientFillCommandGroup" Command="{Binding ConditionalFormattingDataBarsGradientFillCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingDataBarGradientBlue" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingDataBarGradientGreen" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingDataBarGradientRed" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingDataBarGradientOrange" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingDataBarGradientLightBlue" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingDataBarGradientPurple" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biConditionalFormattingDataBarGradientBlue" Command="{Binding ConditionalFormattingDataBarGradientBlue, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingDataBarGradientGreen" Command="{Binding ConditionalFormattingDataBarGradientGreen, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingDataBarGradientRed" Command="{Binding ConditionalFormattingDataBarGradientRed, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingDataBarGradientOrange" Command="{Binding ConditionalFormattingDataBarGradientOrange, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingDataBarGradientLightBlue" Command="{Binding ConditionalFormattingDataBarGradientLightBlue, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingDataBarGradientPurple" Command="{Binding ConditionalFormattingDataBarGradientPurple, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biConditionalFormattingDataBarsSolidFillCommandGroup" Command="{Binding ConditionalFormattingDataBarsSolidFillCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingDataBarSolidBlue" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingDataBarSolidGreen" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingDataBarSolidRed" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingDataBarSolidOrange" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingDataBarSolidLightBlue" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingDataBarSolidPurple" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biConditionalFormattingDataBarSolidBlue" Command="{Binding ConditionalFormattingDataBarSolidBlue, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingDataBarSolidGreen" Command="{Binding ConditionalFormattingDataBarSolidGreen, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingDataBarSolidRed" Command="{Binding ConditionalFormattingDataBarSolidRed, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingDataBarSolidOrange" Command="{Binding ConditionalFormattingDataBarSolidOrange, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingDataBarSolidLightBlue" Command="{Binding ConditionalFormattingDataBarSolidLightBlue, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingDataBarSolidPurple" Command="{Binding ConditionalFormattingDataBarSolidPurple, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biConditionalFormattingColorScalesCommandGroup" Command="{Binding ConditionalFormattingColorScalesCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingColorScaleGreenYellowRed" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingColorScaleRedYellowGreen" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingColorScaleGreenWhiteRed" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingColorScaleRedWhiteGreen" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingColorScaleBlueWhiteRed" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingColorScaleRedWhiteBlue" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingColorScaleWhiteRed" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingColorScaleRedWhite" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingColorScaleGreenWhite" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingColorScaleWhiteGreen" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingColorScaleGreenYellow" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingColorScaleYellowGreen" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biConditionalFormattingColorScaleGreenYellowRed" Command="{Binding ConditionalFormattingColorScaleGreenYellowRed, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingColorScaleRedYellowGreen" Command="{Binding ConditionalFormattingColorScaleRedYellowGreen, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingColorScaleGreenWhiteRed" Command="{Binding ConditionalFormattingColorScaleGreenWhiteRed, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingColorScaleRedWhiteGreen" Command="{Binding ConditionalFormattingColorScaleRedWhiteGreen, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingColorScaleBlueWhiteRed" Command="{Binding ConditionalFormattingColorScaleBlueWhiteRed, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingColorScaleRedWhiteBlue" Command="{Binding ConditionalFormattingColorScaleRedWhiteBlue, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingColorScaleWhiteRed" Command="{Binding ConditionalFormattingColorScaleWhiteRed, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingColorScaleRedWhite" Command="{Binding ConditionalFormattingColorScaleRedWhite, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingColorScaleGreenWhite" Command="{Binding ConditionalFormattingColorScaleGreenWhite, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingColorScaleWhiteGreen" Command="{Binding ConditionalFormattingColorScaleWhiteGreen, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingColorScaleGreenYellow" Command="{Binding ConditionalFormattingColorScaleGreenYellow, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingColorScaleYellowGreen" Command="{Binding ConditionalFormattingColorScaleYellowGreen, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biConditionalFormattingIconSetsCommandGroup" Command="{Binding ConditionalFormattingIconSetsCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarSubItemLink BarItemName="biConditionalFormattingIconSetsDirectionalCommandGroup" />
<dxb:BarSubItemLink BarItemName="biConditionalFormattingIconSetsShapesCommandGroup" />
<dxb:BarSubItemLink BarItemName="biConditionalFormattingIconSetsIndicatorsCommandGroup" />
<dxb:BarSubItemLink BarItemName="biConditionalFormattingIconSetsRatingsCommandGroup" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarSubItem x:Name="biConditionalFormattingIconSetsDirectionalCommandGroup" Command="{Binding ConditionalFormattingIconSetsDirectionalCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetArrows3Colored" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetArrows3Grayed" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetArrows4Colored" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetArrows4Grayed" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetArrows5Colored" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetArrows5Grayed" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetTriangles3" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetArrows3Colored" Command="{Binding ConditionalFormattingIconSetArrows3Colored, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetArrows3Grayed" Command="{Binding ConditionalFormattingIconSetArrows3Grayed, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetArrows4Colored" Command="{Binding ConditionalFormattingIconSetArrows4Colored, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetArrows4Grayed" Command="{Binding ConditionalFormattingIconSetArrows4Grayed, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetArrows5Colored" Command="{Binding ConditionalFormattingIconSetArrows5Colored, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetArrows5Grayed" Command="{Binding ConditionalFormattingIconSetArrows5Grayed, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetTriangles3" Command="{Binding ConditionalFormattingIconSetTriangles3, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biConditionalFormattingIconSetsShapesCommandGroup" Command="{Binding ConditionalFormattingIconSetsShapesCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetTrafficLights3" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetTrafficLights3Rimmed" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetTrafficLights4" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetSigns3" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetRedToBlack" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetTrafficLights3" Command="{Binding ConditionalFormattingIconSetTrafficLights3, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetTrafficLights3Rimmed" Command="{Binding ConditionalFormattingIconSetTrafficLights3Rimmed, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetTrafficLights4" Command="{Binding ConditionalFormattingIconSetTrafficLights4, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetSigns3" Command="{Binding ConditionalFormattingIconSetSigns3, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetRedToBlack" Command="{Binding ConditionalFormattingIconSetRedToBlack, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biConditionalFormattingIconSetsIndicatorsCommandGroup" Command="{Binding ConditionalFormattingIconSetsIndicatorsCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetSymbols3Circled" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetSymbols3" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetFlags3" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetSymbols3Circled" Command="{Binding ConditionalFormattingIconSetSymbols3Circled, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetSymbols3" Command="{Binding ConditionalFormattingIconSetSymbols3, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetFlags3" Command="{Binding ConditionalFormattingIconSetFlags3, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biConditionalFormattingIconSetsRatingsCommandGroup" Command="{Binding ConditionalFormattingIconSetsRatingsCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetStars3" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetRatings4" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetRatings5" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetQuarters5" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingIconSetBoxes5" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetStars3" Command="{Binding ConditionalFormattingIconSetStars3, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetRatings4" Command="{Binding ConditionalFormattingIconSetRatings4, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetRatings5" Command="{Binding ConditionalFormattingIconSetRatings5, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetQuarters5" Command="{Binding ConditionalFormattingIconSetQuarters5, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingIconSetBoxes5" Command="{Binding ConditionalFormattingIconSetBoxes5, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biNewConditionalFormattingRule" Command="{Binding NewConditionalFormattingRule, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biConditionalFormattingRemoveCommandGroup" Command="{Binding ConditionalFormattingRemoveCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingRemoveFromSheet" />
<dxb:BarButtonItemLink BarItemName="biConditionalFormattingRemove" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biConditionalFormattingRemoveFromSheet" Command="{Binding ConditionalFormattingRemoveFromSheet, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biConditionalFormattingRemove" Command="{Binding ConditionalFormattingRemove, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biInsertCellsCommandGroup" Command="{Binding InsertCellsCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biInsertSheetRows" />
<dxb:BarButtonItemLink BarItemName="biInsertSheetColumns" />
<dxb:BarButtonItemLink BarItemName="biInsertSheet" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biInsertSheetRows" Command="{Binding InsertSheetRows, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biInsertSheetColumns" Command="{Binding InsertSheetColumns, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biInsertSheet" Command="{Binding InsertSheet, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biRemoveCellsCommandGroup" Command="{Binding RemoveCellsCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biRemoveSheetRows" />
<dxb:BarButtonItemLink BarItemName="biRemoveSheetColumns" />
<dxb:BarButtonItemLink BarItemName="biRemoveSheet" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biRemoveSheetRows" Command="{Binding RemoveSheetRows, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biRemoveSheetColumns" Command="{Binding RemoveSheetColumns, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biRemoveSheet" Command="{Binding RemoveSheet, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biFormatCommandGroup" Command="{Binding FormatCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biFormatRowHeight" />
<dxb:BarButtonItemLink BarItemName="biFormatAutoFitRowHeight" />
<dxb:BarButtonItemLink BarItemName="biFormatColumnWidth" />
<dxb:BarButtonItemLink BarItemName="biFormatAutoFitColumnWidth" />
<dxb:BarButtonItemLink BarItemName="biFormatDefaultColumnWidth" />
<dxb:BarSubItemLink BarItemName="biFormatHideAndUnhideCommandGroup" />
<dxb:BarButtonItemLink BarItemName="biRenameSheet" />
<dxb:BarButtonItemLink BarItemName="biMoveOrCopySheet" />
<Custom:BarButtonColorEditItemLink BarItemName="biFormatTabColor" />
<dxb:BarButtonItemLink BarItemName="biReviewProtectSheet" />
<dxb:BarCheckItemLink BarItemName="biFormatCellLocked" />
<dxb:BarButtonItemLink BarItemName="biFormatCells" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biFormatRowHeight" Command="{Binding FormatRowHeight, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatAutoFitRowHeight" Command="{Binding FormatAutoFitRowHeight, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatColumnWidth" Command="{Binding FormatColumnWidth, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatAutoFitColumnWidth" Command="{Binding FormatAutoFitColumnWidth, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatDefaultColumnWidth" Command="{Binding FormatDefaultColumnWidth, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biFormatHideAndUnhideCommandGroup" Command="{Binding FormatHideAndUnhideCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biFormatHideRows" />
<dxb:BarButtonItemLink BarItemName="biFormatHideColumns" />
<dxb:BarButtonItemLink BarItemName="biFormatHideSheet" />
<dxb:BarButtonItemLink BarItemName="biFormatUnhideRows" />
<dxb:BarButtonItemLink BarItemName="biFormatUnhideColumns" />
<dxb:BarButtonItemLink BarItemName="biFormatUnhideSheet" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biFormatHideRows" Command="{Binding FormatHideRows, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatHideColumns" Command="{Binding FormatHideColumns, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatHideSheet" Command="{Binding FormatHideSheet, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatUnhideRows" Command="{Binding FormatUnhideRows, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatUnhideColumns" Command="{Binding FormatUnhideColumns, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatUnhideSheet" Command="{Binding FormatUnhideSheet, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biRenameSheet" Command="{Binding RenameSheet, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biMoveOrCopySheet" Command="{Binding MoveOrCopySheet, Mode=OneTime, Source={StaticResource commands}}" />
<Custom:BarButtonColorEditItem x:Name="biFormatTabColor" Command="{Binding FormatTabColor, Mode=OneTime, Source={StaticResource commands}}">
<dxb:PopupControlContainerInfo>
<dxe:ColorEdit EditValue="{Binding EditValue, ElementName=biFormatTabColor, Mode=TwoWay}" ShowDefaultColorButton="False" ShowNoColorButton="True" ShowBorder="False" />
</dxb:PopupControlContainerInfo>
</Custom:BarButtonColorEditItem>
<dxb:BarButtonItem x:Name="biReviewProtectSheet" Command="{Binding ReviewProtectSheet, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarCheckItem x:Name="biFormatCellLocked" Command="{Binding FormatCellLocked, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatCells" Command="{Binding FormatCells, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biEditingAutoSumCommandGroup" Command="{Binding EditingAutoSumCommandGroup, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithText">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biFunctionsInsertSum" />
<dxb:BarButtonItemLink BarItemName="biFunctionsInsertAverage" />
<dxb:BarButtonItemLink BarItemName="biFunctionsInsertCountNumbers" />
<dxb:BarButtonItemLink BarItemName="biFunctionsInsertMax" />
<dxb:BarButtonItemLink BarItemName="biFunctionsInsertMin" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biFunctionsInsertSum" Command="{Binding FunctionsInsertSum, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFunctionsInsertAverage" Command="{Binding FunctionsInsertAverage, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFunctionsInsertCountNumbers" Command="{Binding FunctionsInsertCountNumbers, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFunctionsInsertMax" Command="{Binding FunctionsInsertMax, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFunctionsInsertMin" Command="{Binding FunctionsInsertMin, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biEditingFillCommandGroup" Command="{Binding EditingFillCommandGroup, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithText">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biEditingFillDown" />
<dxb:BarButtonItemLink BarItemName="biEditingFillRight" />
<dxb:BarButtonItemLink BarItemName="biEditingFillUp" />
<dxb:BarButtonItemLink BarItemName="biEditingFillLeft" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biEditingFillDown" Command="{Binding EditingFillDown, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biEditingFillRight" Command="{Binding EditingFillRight, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biEditingFillUp" Command="{Binding EditingFillUp, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biEditingFillLeft" Command="{Binding EditingFillLeft, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biFormatClearCommandGroup" Command="{Binding FormatClearCommandGroup, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithText">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biFormatClearAll" />
<dxb:BarButtonItemLink BarItemName="biFormatClearFormats" />
<dxb:BarButtonItemLink BarItemName="biFormatClearContents" />
<dxb:BarButtonItemLink BarItemName="biFormatClearComments" />
<dxb:BarButtonItemLink BarItemName="biFormatClearHyperlinks" />
<dxb:BarButtonItemLink BarItemName="biFormatRemoveHyperlinks" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biFormatClearAll" Command="{Binding FormatClearAll, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatClearFormats" Command="{Binding FormatClearFormats, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatClearContents" Command="{Binding FormatClearContents, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatClearComments" Command="{Binding FormatClearComments, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatClearHyperlinks" Command="{Binding FormatClearHyperlinks, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormatRemoveHyperlinks" Command="{Binding FormatRemoveHyperlinks, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biEditingSortAndFilterCommandGroup" Command="{Binding EditingSortAndFilterCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biEditingDataSortAscending" />
<dxb:BarButtonItemLink BarItemName="biEditingDataSortDescending" />
<dxb:BarCheckItemLink BarItemName="biDataFilterToggle" />
<dxb:BarButtonItemLink BarItemName="biDataFilterClear" />
<dxb:BarButtonItemLink BarItemName="biDataFilterReApply" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biEditingDataSortAscending" Command="{Binding DataSortAscending, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biEditingDataSortDescending" Command="{Binding DataSortDescending, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarCheckItem x:Name="biDataFilterToggle" Command="{Binding DataFilterToggle, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biDataFilterClear" Command="{Binding DataFilterClear, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biDataFilterReApply" Command="{Binding DataFilterReApply, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biEditingFindAndSelectCommandGroup" Command="{Binding EditingFindAndSelectCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biEditingFind" />
<dxb:BarButtonItemLink BarItemName="biEditingReplace" />
<dxb:BarButtonItemLink BarItemName="biEditingSelectFormulas" />
<dxb:BarButtonItemLink BarItemName="biEditingSelectComments" />
<dxb:BarButtonItemLink BarItemName="biEditingSelectConditionalFormatting" />
<dxb:BarButtonItemLink BarItemName="biEditingSelectConstants" />
<dxb:BarButtonItemLink BarItemName="biEditingSelectDataValidation" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biEditingFind" Command="{Binding EditingFind, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biEditingReplace" Command="{Binding EditingReplace, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biEditingSelectFormulas" Command="{Binding EditingSelectFormulas, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biEditingSelectComments" Command="{Binding EditingSelectComments, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biEditingSelectConditionalFormatting" Command="{Binding EditingSelectConditionalFormatting, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biEditingSelectConstants" Command="{Binding EditingSelectConstants, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biEditingSelectDataValidation" Command="{Binding EditingSelectDataValidation, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biInsertPivotTable" Command="{Binding InsertPivotTable, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biInsertTable" Command="{Binding InsertTable, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biInsertPicture" Command="{Binding InsertPicture, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSplitButtonItem x:Name="biInsertChartColumnCommandGroup" ActAsDropDown="True" Command="{Binding InsertChartColumnCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="4" ItemDescriptionHorizontalAlignment="Left" IsItemCaptionVisible="False" IsItemDescriptionVisible="False" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpInsertChartColumn2DCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartColumn2DCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartColumnClustered2D" Command="{Binding InsertChartColumnClustered2D, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartColumnStacked2D" Command="{Binding InsertChartColumnStacked2D, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartColumnPercentStacked2D" Command="{Binding InsertChartColumnPercentStacked2D, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
<dxb:GalleryItemGroup x:Name="grpInsertChartColumn3DCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartColumn3DCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartColumnClustered3D" Command="{Binding InsertChartColumnClustered3D, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartColumnStacked3D" Command="{Binding InsertChartColumnStacked3D, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartColumnPercentStacked3D" Command="{Binding InsertChartColumnPercentStacked3D, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartColumn3D" Command="{Binding InsertChartColumn3D, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
<dxb:GalleryItemGroup x:Name="grpInsertChartCylinderCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartCylinderCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartCylinderClustered" Command="{Binding InsertChartCylinderClustered, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartCylinderStacked" Command="{Binding InsertChartCylinderStacked, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartCylinderPercentStacked" Command="{Binding InsertChartCylinderPercentStacked, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartCylinder" Command="{Binding InsertChartCylinder, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
<dxb:GalleryItemGroup x:Name="grpInsertChartConeCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartConeCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartConeClustered" Command="{Binding InsertChartConeClustered, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartConeStacked" Command="{Binding InsertChartConeStacked, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartConePercentStacked" Command="{Binding InsertChartConePercentStacked, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartCone" Command="{Binding InsertChartCone, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
<dxb:GalleryItemGroup x:Name="grpInsertChartPyramidCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartPyramidCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartPyramidClustered" Command="{Binding InsertChartPyramidClustered, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartPyramidStacked" Command="{Binding InsertChartPyramidStacked, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartPyramidPercentStacked" Command="{Binding InsertChartPyramidPercentStacked, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartPyramid" Command="{Binding InsertChartPyramid, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSplitButtonItem x:Name="biInsertChartLineCommandGroup" ActAsDropDown="True" Command="{Binding InsertChartLineCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="3" ItemDescriptionHorizontalAlignment="Left" IsItemCaptionVisible="False" IsItemDescriptionVisible="False" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpInsertChartLine2DCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartLine2DCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartLine" Command="{Binding InsertChartLine, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartStackedLine" Command="{Binding InsertChartStackedLine, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartPercentStackedLine" Command="{Binding InsertChartPercentStackedLine, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartLineWithMarkers" Command="{Binding InsertChartLineWithMarkers, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartStackedLineWithMarkers" Command="{Binding InsertChartStackedLineWithMarkers, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartPercentStackedLineWithMarkers" Command="{Binding InsertChartPercentStackedLineWithMarkers, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
<dxb:GalleryItemGroup x:Name="grpInsertChartLine3DCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartLine3DCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartLine3D" Command="{Binding InsertChartLine3D, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSplitButtonItem x:Name="biInsertChartPieCommandGroup" ActAsDropDown="True" Command="{Binding InsertChartPieCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="2" ItemDescriptionHorizontalAlignment="Left" IsItemCaptionVisible="False" IsItemDescriptionVisible="False" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpInsertChartPie2DCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartPie2DCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartPie2D" Command="{Binding InsertChartPie2D, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartPieExploded2D" Command="{Binding InsertChartPieExploded2D, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
<dxb:GalleryItemGroup x:Name="grpInsertChartPie3DCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartPie3DCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartPie3D" Command="{Binding InsertChartPie3D, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartPieExploded3D" Command="{Binding InsertChartPieExploded3D, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
<dxb:GalleryItemGroup x:Name="grpInsertChartDoughnut2DCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartDoughnut2DCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartDoughnut2D" Command="{Binding InsertChartDoughnut2D, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartDoughnutExploded2D" Command="{Binding InsertChartDoughnutExploded2D, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSplitButtonItem x:Name="biInsertChartBarCommandGroup" ActAsDropDown="True" Command="{Binding InsertChartBarCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="3" ItemDescriptionHorizontalAlignment="Left" IsItemCaptionVisible="False" IsItemDescriptionVisible="False" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpInsertChartBar2DCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartBar2DCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartBarClustered2D" Command="{Binding InsertChartBarClustered2D, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartBarStacked2D" Command="{Binding InsertChartBarStacked2D, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartBarPercentStacked2D" Command="{Binding InsertChartBarPercentStacked2D, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
<dxb:GalleryItemGroup x:Name="grpInsertChartBar3DCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartBar3DCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartBarClustered3D" Command="{Binding InsertChartBarClustered3D, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartBarStacked3D" Command="{Binding InsertChartBarStacked3D, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartBarPercentStacked3D" Command="{Binding InsertChartBarPercentStacked3D, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
<dxb:GalleryItemGroup x:Name="grpInsertChartHorizontalCylinderCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartHorizontalCylinderCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartHorizontalCylinderClustered" Command="{Binding InsertChartHorizontalCylinderClustered, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartHorizontalCylinderStacked" Command="{Binding InsertChartHorizontalCylinderStacked, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartHorizontalCylinderPercentStacked" Command="{Binding InsertChartHorizontalCylinderPercentStacked, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
<dxb:GalleryItemGroup x:Name="grpInsertChartHorizontalConeCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartHorizontalConeCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartHorizontalConeClustered" Command="{Binding InsertChartHorizontalConeClustered, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartHorizontalConeStacked" Command="{Binding InsertChartHorizontalConeStacked, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartHorizontalConePercentStacked" Command="{Binding InsertChartHorizontalConePercentStacked, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
<dxb:GalleryItemGroup x:Name="grpInsertChartHorizontalPyramidCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartHorizontalPyramidCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartHorizontalPyramidClustered" Command="{Binding InsertChartHorizontalPyramidClustered, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartHorizontalPyramidStacked" Command="{Binding InsertChartHorizontalPyramidStacked, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartHorizontalPyramidPercentStacked" Command="{Binding InsertChartHorizontalPyramidPercentStacked, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSplitButtonItem x:Name="biInsertChartAreaCommandGroup" ActAsDropDown="True" Command="{Binding InsertChartAreaCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="3" ItemDescriptionHorizontalAlignment="Left" IsItemCaptionVisible="False" IsItemDescriptionVisible="False" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpInsertChartArea2DCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartArea2DCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartArea" Command="{Binding InsertChartArea, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartStackedArea" Command="{Binding InsertChartStackedArea, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartPercentStackedArea" Command="{Binding InsertChartPercentStackedArea, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
<dxb:GalleryItemGroup x:Name="grpInsertChartArea3DCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartArea3DCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartArea3D" Command="{Binding InsertChartArea3D, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartStackedArea3D" Command="{Binding InsertChartStackedArea3D, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartPercentStackedArea3D" Command="{Binding InsertChartPercentStackedArea3D, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSplitButtonItem x:Name="biInsertChartScatterCommandGroup" ActAsDropDown="True" Command="{Binding InsertChartScatterCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="3" ItemDescriptionHorizontalAlignment="Left" IsItemCaptionVisible="False" IsItemDescriptionVisible="False" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpInsertChartScatterCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartScatterCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartScatterMarkers" Command="{Binding InsertChartScatterMarkers, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartScatterSmoothLinesAndMarkers" Command="{Binding InsertChartScatterSmoothLinesAndMarkers, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartScatterSmoothLines" Command="{Binding InsertChartScatterSmoothLines, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartScatterLinesAndMarkers" Command="{Binding InsertChartScatterLinesAndMarkers, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartScatterLines" Command="{Binding InsertChartScatterLines, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
<dxb:GalleryItemGroup x:Name="grpInsertChartBubbleCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartBubbleCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartBubble" Command="{Binding InsertChartBubble, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartBubble3D" Command="{Binding InsertChartBubble3D, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSplitButtonItem x:Name="biInsertChartOtherCommandGroup" ActAsDropDown="True" Command="{Binding InsertChartOtherCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="4" ItemDescriptionHorizontalAlignment="Left" IsItemCaptionVisible="False" IsItemDescriptionVisible="False" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpInsertChartStockCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartStockCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartStockHighLowClose" Command="{Binding InsertChartStockHighLowClose, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartStockOpenHighLowClose" Command="{Binding InsertChartStockOpenHighLowClose, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartStockVolumeHighLowClose" Command="{Binding InsertChartStockVolumeHighLowClose, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartStockVolumeOpenHighLowClose" Command="{Binding InsertChartStockVolumeOpenHighLowClose, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
<dxb:GalleryItemGroup x:Name="grpInsertChartRadarCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_InsertChartRadarCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="True">
<dxb:GalleryItem x:Name="biInsertChartRadar" Command="{Binding InsertChartRadar, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartRadarWithMarkers" Command="{Binding InsertChartRadarWithMarkers, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biInsertChartRadarFilled" Command="{Binding InsertChartRadarFilled, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarButtonItem x:Name="biInsertHyperlink" Command="{Binding InsertHyperlink, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biInsertSymbol" Command="{Binding InsertSymbol, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biPageSetupMarginsCommandGroup" Command="{Binding PageSetupMarginsCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarCheckItemLink BarItemName="biPageSetupMarginsNormal" />
<dxb:BarCheckItemLink BarItemName="biPageSetupMarginsWide" />
<dxb:BarCheckItemLink BarItemName="biPageSetupMarginsNarrow" />
<dxb:BarButtonItemLink BarItemName="biPageSetupCustomMargins" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarCheckItem x:Name="biPageSetupMarginsNormal" ContentTemplate="{Binding MarginBarItemContentTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" Command="{Binding PageSetupMarginsNormal, Mode=OneTime, Source={StaticResource commands}}" GlyphSize="Large" />
<dxb:BarCheckItem x:Name="biPageSetupMarginsWide" ContentTemplate="{Binding MarginBarItemContentTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" Command="{Binding PageSetupMarginsWide, Mode=OneTime, Source={StaticResource commands}}" GlyphSize="Large" />
<dxb:BarCheckItem x:Name="biPageSetupMarginsNarrow" ContentTemplate="{Binding MarginBarItemContentTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" Command="{Binding PageSetupMarginsNarrow, Mode=OneTime, Source={StaticResource commands}}" GlyphSize="Large" />
<dxb:BarButtonItem x:Name="biPageSetupCustomMargins" Command="{Binding PageSetupCustomMargins, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biPageSetupOrientationCommandGroup" Command="{Binding PageSetupOrientationCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarCheckItemLink BarItemName="biPageSetupOrientationPortrait" />
<dxb:BarCheckItemLink BarItemName="biPageSetupOrientationLandscape" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarCheckItem x:Name="biPageSetupOrientationPortrait" Command="{Binding PageSetupOrientationPortrait, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarCheckItem x:Name="biPageSetupOrientationLandscape" Command="{Binding PageSetupOrientationLandscape, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biPageSetupPaperKindCommandGroup" Command="{Binding PageSetupPaperKindCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<Custom:PaperKindBarListItemLink BarItemName="biPageLayoutSizeList" />
<dxb:BarButtonItemLink BarItemName="biPageSetupMorePaperSizes" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxsps:PaperKindBarListItem x:Name="biPageLayoutSizeList" SpreadsheetControl="{Binding ElementName=spreadsheetControl}" />
<dxb:BarButtonItem x:Name="biPageSetupMorePaperSizes" Command="{Binding PageSetupMorePaperSizes, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biPageSetupPrintAreaCommandGroup" Command="{Binding PageSetupPrintAreaCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biPageSetupSetPrintArea" />
<dxb:BarButtonItemLink BarItemName="biPageSetupClearPrintArea" />
<dxb:BarButtonItemLink BarItemName="biPageSetupAddPrintArea" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biPageSetupSetPrintArea" Command="{Binding PageSetupSetPrintArea, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biPageSetupClearPrintArea" Command="{Binding PageSetupClearPrintArea, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biPageSetupAddPrintArea" Command="{Binding PageSetupAddPrintArea, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biPageSetupPrintTitles" Command="{Binding PageSetupPrintTitles, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarStaticItem x:Name="biViewShowGridlines" ContentTemplate="{Binding CheckEditTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" Command="{Binding ViewShowGridlines, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarStaticItem x:Name="biViewShowHeadings" ContentTemplate="{Binding CheckEditTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" Command="{Binding ViewShowHeadings, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarStaticItem x:Name="biPageSetupPrintGridlines" ContentTemplate="{Binding CheckEditTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" Command="{Binding PageSetupPrintGridlines, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarStaticItem x:Name="biPageSetupPrintHeadings" ContentTemplate="{Binding CheckEditTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" Command="{Binding PageSetupPrintHeadings, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biPageLayoutArrangeBringForwardCommandGroup" Command="{Binding ArrangeBringForwardCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biArrangeBringForward" />
<dxb:BarButtonItemLink BarItemName="biArrangeBringToFront" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biArrangeBringForward" Command="{Binding ArrangeBringForward, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biArrangeBringToFront" Command="{Binding ArrangeBringToFront, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biPageLayoutArrangeSendBackwardCommandGroup" Command="{Binding ArrangeSendBackwardCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biArrangeSendBackward" />
<dxb:BarButtonItemLink BarItemName="biArrangeSendToBack" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biArrangeSendBackward" Command="{Binding ArrangeSendBackward, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biArrangeSendToBack" Command="{Binding ArrangeSendToBack, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biFunctionsAutoSumCommandGroup" Command="{Binding FunctionsAutoSumCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biFunctionsInsertSum" />
<dxb:BarButtonItemLink BarItemName="biFunctionsInsertAverage" />
<dxb:BarButtonItemLink BarItemName="biFunctionsInsertCountNumbers" />
<dxb:BarButtonItemLink BarItemName="biFunctionsInsertMax" />
<dxb:BarButtonItemLink BarItemName="biFunctionsInsertMin" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxsps:InsertFinancialFunctionsBarSubItem x:Name="biFunctionsFinancialCommandGroup" Command="{Binding FunctionsFinancialCommandGroup, Mode=OneTime, Source={StaticResource commands}}" SpreadsheetControl="{Binding ElementName=spreadsheetControl}" />
<dxsps:InsertLogicalFunctionsBarSubItem x:Name="biFunctionsLogicalCommandGroup" Command="{Binding FunctionsLogicalCommandGroup, Mode=OneTime, Source={StaticResource commands}}" SpreadsheetControl="{Binding ElementName=spreadsheetControl}" />
<dxsps:InsertTextFunctionsBarSubItem x:Name="biFunctionsTextCommandGroup" Command="{Binding FunctionsTextCommandGroup, Mode=OneTime, Source={StaticResource commands}}" SpreadsheetControl="{Binding ElementName=spreadsheetControl}" />
<dxsps:InsertDateAndTimeFunctionsBarSubItem x:Name="biFunctionsDateAndTimeCommandGroup" Command="{Binding FunctionsDateAndTimeCommandGroup, Mode=OneTime, Source={StaticResource commands}}" SpreadsheetControl="{Binding ElementName=spreadsheetControl}" />
<dxsps:InsertLookupAndReferenceFunctionsBarSubItem x:Name="biFunctionsLookupAndReferenceCommandGroup" Command="{Binding FunctionsLookupAndReferenceCommandGroup, Mode=OneTime, Source={StaticResource commands}}" SpreadsheetControl="{Binding ElementName=spreadsheetControl}" />
<dxsps:InsertMathAndTrigonometryFunctionsBarSubItem x:Name="biFunctionsMathAndTrigonometryCommandGroup" Command="{Binding FunctionsMathAndTrigonometryCommandGroup, Mode=OneTime, Source={StaticResource commands}}" SpreadsheetControl="{Binding ElementName=spreadsheetControl}" />
<dxsps:InsertStatisticalFunctionsBarSubItem x:Name="biFunctionsStatisticalCommandGroup" Command="{Binding FunctionsStatisticalCommandGroup, Mode=OneTime, Source={StaticResource commands}}" SpreadsheetControl="{Binding ElementName=spreadsheetControl}" />
<dxsps:InsertEngineeringFunctionsBarSubItem x:Name="biFunctionsEngineeringCommandGroup" Command="{Binding FunctionsEngineeringCommandGroup, Mode=OneTime, Source={StaticResource commands}}" SpreadsheetControl="{Binding ElementName=spreadsheetControl}" />
<dxsps:InsertInformationFunctionsBarSubItem x:Name="biFunctionsInformationCommandGroup" Command="{Binding FunctionsInformationCommandGroup, Mode=OneTime, Source={StaticResource commands}}" SpreadsheetControl="{Binding ElementName=spreadsheetControl}" />
<dxsps:InsertCompatibilityFunctionsBarSubItem x:Name="biFunctionsCompatibilityCommandGroup" Command="{Binding FunctionsCompatibilityCommandGroup, Mode=OneTime, Source={StaticResource commands}}" SpreadsheetControl="{Binding ElementName=spreadsheetControl}" />
<dxsps:InsertWebFunctionsBarSubItem x:Name="biFunctionsWebCommandGroup" Command="{Binding FunctionsWebCommandGroup, Mode=OneTime, Source={StaticResource commands}}" SpreadsheetControl="{Binding ElementName=spreadsheetControl}" />
<dxb:BarButtonItem x:Name="biFormulasShowNameManager" Command="{Binding FormulasShowNameManager, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormulasDefineNameCommand" Command="{Binding FormulasDefineNameCommand, Mode=OneTime, Source={StaticResource commands}}" />
<dxsps:InsertDefinedNamesBarSubItem x:Name="biFormulasInsertDefinedNameCommandGroup" Command="{Binding FormulasInsertDefinedNameCommandGroup, Mode=OneTime, Source={StaticResource commands}}" GlyphSize="Large" SpreadsheetControl="{Binding ElementName=spreadsheetControl}" />
<dxb:BarButtonItem x:Name="biFormulasCreateDefinedNamesFromSelection" Command="{Binding FormulasCreateDefinedNamesFromSelection, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarCheckItem x:Name="biViewShowFormulas" Command="{Binding ViewShowFormulas, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biFormulasCalculationOptionsCommandGroup" Command="{Binding FormulasCalculationOptionsCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarCheckItemLink BarItemName="biFormulasCalculationModeAutomatic" />
<dxb:BarCheckItemLink BarItemName="biFormulasCalculationModeManual" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarCheckItem x:Name="biFormulasCalculationModeAutomatic" Command="{Binding FormulasCalculationModeAutomatic, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarCheckItem x:Name="biFormulasCalculationModeManual" Command="{Binding FormulasCalculationModeManual, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biFormulasCalculateNow" Command="{Binding FormulasCalculateNow, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithText" />
<dxb:BarButtonItem x:Name="biFormulasCalculateSheet" Command="{Binding FormulasCalculateSheet, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithText" />
<dxb:BarButtonItem x:Name="biDataSortAscending" Command="{Binding DataSortAscending, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biDataSortDescending" Command="{Binding DataSortDescending, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biDataValidationCommandGroup" Command="{Binding DataValidationCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biDataValidation" />
<dxb:BarButtonItemLink BarItemName="biDataCircleValidationInvalidData" />
<dxb:BarButtonItemLink BarItemName="biDataClearValidationCircles" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biDataValidation" Command="{Binding DataValidation, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biDataCircleValidationInvalidData" Command="{Binding DataCircleValidationInvalidData, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biDataClearValidationCircles" Command="{Binding DataClearValidationCircles, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biDataOutlineGroupCommandGroup" Command="{Binding DataOutlineGroupCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biDataGroupOutline" />
<dxb:BarButtonItemLink BarItemName="biDataAutoOutline" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biDataGroupOutline" Command="{Binding DataGroupOutline, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biDataAutoOutline" Command="{Binding DataAutoOutline, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biDataOutlineUngroupCommandGroup" Command="{Binding DataOutlineUngroupCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biDataUngroupOutline" />
<dxb:BarButtonItemLink BarItemName="biDataClearOutline" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biDataUngroupOutline" Command="{Binding DataUngroupOutline, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biDataClearOutline" Command="{Binding DataClearOutline, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biDataSubtotal" Command="{Binding DataSubtotal, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biDataShowDetail" Command="{Binding DataShowDetail, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biDataHideDetail" Command="{Binding DataHideDetail, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biReviewInsertComment" Command="{Binding ReviewInsertComment, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biReviewEditComment" Command="{Binding ReviewEditComment, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biReviewDeleteComment" Command="{Binding ReviewDeleteComment, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biReviewShowHideComment" Command="{Binding ReviewShowHideComment, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithText" />
<dxb:BarButtonItem x:Name="biReviewUnprotectSheet" Command="{Binding ReviewUnprotectSheet, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biReviewProtectWorkbook" Command="{Binding ReviewProtectWorkbook, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biReviewUnprotectWorkbook" Command="{Binding ReviewUnprotectWorkbook, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biReviewShowProtectedRangeManager" Command="{Binding ReviewShowProtectedRangeManager, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biViewZoom" Command="{Binding ViewZoom, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biViewZoomOut" Command="{Binding ViewZoomOut, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biViewZoomIn" Command="{Binding ViewZoomIn, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biViewZoom100Percent" Command="{Binding ViewZoom100Percent, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biViewFreezePanesCommandGroup" Command="{Binding ViewFreezePanesCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biViewFreezePanes" />
<dxb:BarButtonItemLink BarItemName="biViewUnfreezePanes" />
<dxb:BarButtonItemLink BarItemName="biViewFreezeTopRow" />
<dxb:BarButtonItemLink BarItemName="biViewFreezeFirstColumn" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biViewFreezePanes" Command="{Binding ViewFreezePanes, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biViewUnfreezePanes" Command="{Binding ViewUnfreezePanes, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biViewFreezeTopRow" Command="{Binding ViewFreezeTopRow, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biViewFreezeFirstColumn" Command="{Binding ViewFreezeFirstColumn, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biChartSwitchRowColumn" Command="{Binding ChartSwitchRowColumn, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biChartSelectData" Command="{Binding ChartSelectData, Mode=OneTime, Source={StaticResource commands}}" />
<dxr:RibbonGalleryBarItem x:Name="biGalleryChartLayout">
<dxr:RibbonGalleryBarItem.Gallery>
<dxb:Gallery ColCount="6" GroupTemplate="{Binding ChartLayoutGalleryGroupTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" GroupsSource="{Binding ChartLayoutGalleryGroups, ElementName=spreadsheetControl}" IsItemGlyphVisible="True" IsGroupCaptionVisible="False" IsItemDescriptionVisible="False" MinColCount="3" />
</dxr:RibbonGalleryBarItem.Gallery>
</dxr:RibbonGalleryBarItem>
<dxb:BarSplitButtonItem x:Name="biChartTitleCommandGroup" ActAsDropDown="True" Command="{Binding ChartTitleCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="1" ItemDescriptionHorizontalAlignment="Left" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpChartTitleCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_ChartTitleCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="False">
<dxb:GalleryItem x:Name="biChartTitleNone" Command="{Binding ChartTitleNone, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartTitleCenteredOverlay" Command="{Binding ChartTitleCenteredOverlay, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartTitleAbove" Command="{Binding ChartTitleAbove, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSubItem x:Name="biChartAxisTitlesCommandGroup" Command="{Binding ChartAxisTitlesCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarSplitButtonItemLink BarItemName="biChartPrimaryHorizontalAxisTitleCommandGroup" />
<dxb:BarSplitButtonItemLink BarItemName="biChartPrimaryVerticalAxisTitleCommandGroup" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarSplitButtonItem x:Name="biChartPrimaryHorizontalAxisTitleCommandGroup" ActAsDropDown="True" Command="{Binding ChartPrimaryHorizontalAxisTitleCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="1" ItemDescriptionHorizontalAlignment="Left" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpChartPrimaryHorizontalAxisTitleCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_ChartPrimaryHorizontalAxisTitleCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="False">
<dxb:GalleryItem x:Name="biChartPrimaryHorizontalAxisTitleNone" Command="{Binding ChartPrimaryHorizontalAxisTitleNone, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryHorizontalAxisTitleBelow" Command="{Binding ChartPrimaryHorizontalAxisTitleBelow, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSplitButtonItem x:Name="biChartPrimaryVerticalAxisTitleCommandGroup" ActAsDropDown="True" Command="{Binding ChartPrimaryVerticalAxisTitleCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="1" ItemDescriptionHorizontalAlignment="Left" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpChartPrimaryVerticalAxisTitleCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_ChartPrimaryVerticalAxisTitleCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="False">
<dxb:GalleryItem x:Name="biChartPrimaryVerticalAxisTitleNone" Command="{Binding ChartPrimaryVerticalAxisTitleNone, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryVerticalAxisTitleRotated" Command="{Binding ChartPrimaryVerticalAxisTitleRotated, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryVerticalAxisTitleVertical" Command="{Binding ChartPrimaryVerticalAxisTitleVertical, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryVerticalAxisTitleHorizontal" Command="{Binding ChartPrimaryVerticalAxisTitleHorizontal, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSplitButtonItem x:Name="biChartLegendCommandGroup" ActAsDropDown="True" Command="{Binding ChartLegendCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="1" ItemDescriptionHorizontalAlignment="Left" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpChartLegendCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_ChartLegendCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="False">
<dxb:GalleryItem x:Name="biChartLegendNone" Command="{Binding ChartLegendNone, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartLegendAtRight" Command="{Binding ChartLegendAtRight, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartLegendAtTop" Command="{Binding ChartLegendAtTop, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartLegendAtLeft" Command="{Binding ChartLegendAtLeft, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartLegendAtBottom" Command="{Binding ChartLegendAtBottom, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartLegendOverlayAtRight" Command="{Binding ChartLegendOverlayAtRight, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartLegendOverlayAtLeft" Command="{Binding ChartLegendOverlayAtLeft, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSplitButtonItem x:Name="biChartDataLabelsCommandGroup" ActAsDropDown="True" Command="{Binding ChartDataLabelsCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="1" ItemDescriptionHorizontalAlignment="Left" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpChartDataLabelsCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_ChartDataLabelsCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="False">
<dxb:GalleryItem x:Name="biChartDataLabelsNone" Command="{Binding ChartDataLabelsNone, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartDataLabelsDefault" Command="{Binding ChartDataLabelsDefault, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartDataLabelsCenter" Command="{Binding ChartDataLabelsCenter, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartDataLabelsInsideEnd" Command="{Binding ChartDataLabelsInsideEnd, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartDataLabelsInsideBase" Command="{Binding ChartDataLabelsInsideBase, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartDataLabelsOutsideEnd" Command="{Binding ChartDataLabelsOutsideEnd, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartDataLabelsBestFit" Command="{Binding ChartDataLabelsBestFit, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartDataLabelsLeft" Command="{Binding ChartDataLabelsLeft, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartDataLabelsRight" Command="{Binding ChartDataLabelsRight, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartDataLabelsAbove" Command="{Binding ChartDataLabelsAbove, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartDataLabelsBelow" Command="{Binding ChartDataLabelsBelow, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSubItem x:Name="biChartAxesCommandGroup" Command="{Binding ChartAxesCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarSplitButtonItemLink BarItemName="biChartPrimaryHorizontalAxisCommandGroup" />
<dxb:BarSplitButtonItemLink BarItemName="biChartPrimaryVerticalAxisCommandGroup" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarSplitButtonItem x:Name="biChartPrimaryHorizontalAxisCommandGroup" ActAsDropDown="True" Command="{Binding ChartPrimaryHorizontalAxisCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="1" ItemDescriptionHorizontalAlignment="Left" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpChartPrimaryHorizontalAxisCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_ChartPrimaryHorizontalAxisCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="False">
<dxb:GalleryItem x:Name="biChartHidePrimaryHorizontalAxis" Command="{Binding ChartHidePrimaryHorizontalAxis, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryHorizontalAxisLeftToRight" Command="{Binding ChartPrimaryHorizontalAxisLeftToRight, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryHorizontalAxisRightToLeft" Command="{Binding ChartPrimaryHorizontalAxisRightToLeft, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryHorizontalAxisHideLabels" Command="{Binding ChartPrimaryHorizontalAxisHideLabels, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryHorizontalAxisDefault" Command="{Binding ChartPrimaryHorizontalAxisDefault, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryHorizontalAxisScaleLogarithm" Command="{Binding ChartPrimaryHorizontalAxisScaleLogarithm, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryHorizontalAxisScaleThousands" Command="{Binding ChartPrimaryHorizontalAxisScaleThousands, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryHorizontalAxisScaleMillions" Command="{Binding ChartPrimaryHorizontalAxisScaleMillions, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryHorizontalAxisScaleBillions" Command="{Binding ChartPrimaryHorizontalAxisScaleBillions, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSplitButtonItem x:Name="biChartPrimaryVerticalAxisCommandGroup" ActAsDropDown="True" Command="{Binding ChartPrimaryVerticalAxisCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="1" ItemDescriptionHorizontalAlignment="Left" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpChartPrimaryVerticalAxisCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_ChartPrimaryVerticalAxisCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="False">
<dxb:GalleryItem x:Name="biChartHidePrimaryVerticalAxis" Command="{Binding ChartHidePrimaryVerticalAxis, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryVerticalAxisLeftToRight" Command="{Binding ChartPrimaryVerticalAxisLeftToRight, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryVerticalAxisRightToLeft" Command="{Binding ChartPrimaryVerticalAxisRightToLeft, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryVerticalAxisHideLabels" Command="{Binding ChartPrimaryVerticalAxisHideLabels, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryVerticalAxisDefault" Command="{Binding ChartPrimaryVerticalAxisDefault, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryVerticalAxisScaleLogarithm" Command="{Binding ChartPrimaryVerticalAxisScaleLogarithm, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryVerticalAxisScaleThousands" Command="{Binding ChartPrimaryVerticalAxisScaleThousands, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryVerticalAxisScaleMillions" Command="{Binding ChartPrimaryVerticalAxisScaleMillions, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryVerticalAxisScaleBillions" Command="{Binding ChartPrimaryVerticalAxisScaleBillions, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSubItem x:Name="biChartGridlinesCommandGroup" Command="{Binding ChartGridlinesCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarSplitButtonItemLink BarItemName="biChartPrimaryHorizontalGridlinesCommandGroup" />
<dxb:BarSplitButtonItemLink BarItemName="biChartPrimaryVerticalGridlinesCommandGroup" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarSplitButtonItem x:Name="biChartPrimaryHorizontalGridlinesCommandGroup" ActAsDropDown="True" Command="{Binding ChartPrimaryHorizontalGridlinesCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="1" ItemDescriptionHorizontalAlignment="Left" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpChartPrimaryHorizontalGridlinesCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_ChartPrimaryHorizontalGridlinesCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="False">
<dxb:GalleryItem x:Name="biChartPrimaryHorizontalGridlinesNone" Command="{Binding ChartPrimaryHorizontalGridlinesNone, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryHorizontalGridlinesMajor" Command="{Binding ChartPrimaryHorizontalGridlinesMajor, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryHorizontalGridlinesMinor" Command="{Binding ChartPrimaryHorizontalGridlinesMinor, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryHorizontalGridlinesMajorAndMinor" Command="{Binding ChartPrimaryHorizontalGridlinesMajorAndMinor, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSplitButtonItem x:Name="biChartPrimaryVerticalGridlinesCommandGroup" ActAsDropDown="True" Command="{Binding ChartPrimaryVerticalGridlinesCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="1" ItemDescriptionHorizontalAlignment="Left" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpChartPrimaryVerticalGridlinesCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_ChartPrimaryVerticalGridlinesCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="False">
<dxb:GalleryItem x:Name="biChartPrimaryVerticalGridlinesNone" Command="{Binding ChartPrimaryVerticalGridlinesNone, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryVerticalGridlinesMajor" Command="{Binding ChartPrimaryVerticalGridlinesMajor, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryVerticalGridlinesMinor" Command="{Binding ChartPrimaryVerticalGridlinesMinor, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartPrimaryVerticalGridlinesMajorAndMinor" Command="{Binding ChartPrimaryVerticalGridlinesMajorAndMinor, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSplitButtonItem x:Name="biChartLinesCommandGroup" ActAsDropDown="True" Command="{Binding ChartLinesCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="1" ItemDescriptionHorizontalAlignment="Left" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpChartLinesCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_ChartLinesCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="False">
<dxb:GalleryItem x:Name="biChartLinesNone" Command="{Binding ChartLinesNone, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartShowDropLines" Command="{Binding ChartShowDropLines, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartShowHighLowLines" Command="{Binding ChartShowHighLowLines, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartShowDropLinesAndHighLowLines" Command="{Binding ChartShowDropLinesAndHighLowLines, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartShowSeriesLines" Command="{Binding ChartShowSeriesLines, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSplitButtonItem x:Name="biChartUpDownBarsCommandGroup" ActAsDropDown="True" Command="{Binding ChartUpDownBarsCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="1" ItemDescriptionHorizontalAlignment="Left" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpChartUpDownBarsCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_ChartUpDownBarsCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="False">
<dxb:GalleryItem x:Name="biChartHideUpDownBars" Command="{Binding ChartHideUpDownBars, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartShowUpDownBars" Command="{Binding ChartShowUpDownBars, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSplitButtonItem x:Name="biChartErrorBarsCommandGroup" ActAsDropDown="True" Command="{Binding ChartErrorBarsCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:GalleryDropDownPopupMenu>
<dxr:GalleryDropDownPopupMenu.Gallery>
<dxb:Gallery AllowFilter="False" ColCount="1" ItemDescriptionHorizontalAlignment="Left" SizeMode="None">
<dxb:GalleryItemGroup x:Name="grpChartErrorBarsCommandGroup" Caption="{Binding ConverterParameter=MenuCmd_ChartErrorBarsCommandGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" IsCaptionVisible="False">
<dxb:GalleryItem x:Name="biChartErrorBarsNone" Command="{Binding ChartErrorBarsNone, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartErrorBarsPercentage" Command="{Binding ChartErrorBarsPercentage, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartErrorBarsStandardError" Command="{Binding ChartErrorBarsStandardError, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:GalleryItem x:Name="biChartErrorBarsStandardDeviation" Command="{Binding ChartErrorBarsStandardDeviation, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:GalleryItemGroup>
</dxb:Gallery>
</dxr:GalleryDropDownPopupMenu.Gallery>
</dxr:GalleryDropDownPopupMenu>
</dxb:BarSplitButtonItem>
<dxb:BarSubItem x:Name="biChartToolsFormatArrangeBringForwardCommandGroup" Command="{Binding ArrangeBringForwardCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biArrangeBringForward" />
<dxb:BarButtonItemLink BarItemName="biArrangeBringToFront" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarSubItem x:Name="biChartToolsFormatArrangeSendBackwardCommandGroup" Command="{Binding ArrangeSendBackwardCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biArrangeSendBackward" />
<dxb:BarButtonItemLink BarItemName="biArrangeSendToBack" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarSubItem x:Name="biPictureToolsFormatArrangeBringForwardCommandGroup" Command="{Binding ArrangeBringForwardCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biArrangeBringForward" />
<dxb:BarButtonItemLink BarItemName="biArrangeBringToFront" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarSubItem x:Name="biPictureToolsFormatArrangeSendBackwardCommandGroup" Command="{Binding ArrangeSendBackwardCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biArrangeSendBackward" />
<dxb:BarButtonItemLink BarItemName="biArrangeSendToBack" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarSubItem x:Name="biDrawingToolsFormatArrangeBringForwardCommandGroup" Command="{Binding ArrangeBringForwardCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biArrangeBringForward" />
<dxb:BarButtonItemLink BarItemName="biArrangeBringToFront" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarSubItem x:Name="biDrawingToolsFormatArrangeSendBackwardCommandGroup" Command="{Binding ArrangeSendBackwardCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biArrangeSendBackward" />
<dxb:BarButtonItemLink BarItemName="biArrangeSendToBack" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biTableConvertToRange" Command="{Binding TableConvertToRange, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarStaticItem x:Name="biTableToggleHeaderRow" ContentTemplate="{Binding CheckEditTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" Command="{Binding TableToggleHeaderRow, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarStaticItem x:Name="biTableToggleTotalRow" ContentTemplate="{Binding CheckEditTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" Command="{Binding TableToggleTotalRow, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarStaticItem x:Name="biTableToggleBandedColumns" ContentTemplate="{Binding CheckEditTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" Command="{Binding TableToggleBandedColumns, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarStaticItem x:Name="biTableToggleFirstColumn" ContentTemplate="{Binding CheckEditTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" Command="{Binding TableToggleFirstColumn, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarStaticItem x:Name="biTableToggleLastColumn" ContentTemplate="{Binding CheckEditTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" Command="{Binding TableToggleLastColumn, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarStaticItem x:Name="biTableToggleBandedRows" ContentTemplate="{Binding CheckEditTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" Command="{Binding TableToggleBandedRows, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biOptionsPivotTable" Command="{Binding OptionsPivotTable, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biSelectFieldTypePivotTable" Command="{Binding SelectFieldTypePivotTable, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biPivotTableExpandField" Command="{Binding PivotTableExpandField, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithText" />
<dxb:BarButtonItem x:Name="biPivotTableCollapseField" Command="{Binding PivotTableCollapseField, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithText" />
<dxb:BarButtonItem x:Name="biPivotTableGroupSelection" Command="{Binding PivotTableGroupSelection, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithText" />
<dxb:BarButtonItem x:Name="biPivotTableUngroup" Command="{Binding PivotTableUngroup, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithText" />
<dxb:BarButtonItem x:Name="biPivotTableGroupField" Command="{Binding PivotTableGroupField, Mode=OneTime, Source={StaticResource commands}}" RibbonStyle="SmallWithText" />
<dxb:BarSubItem x:Name="biPivotTableDataRefreshGroup" Command="{Binding PivotTableDataRefreshGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biRefreshPivotTable" />
<dxb:BarButtonItemLink BarItemName="biRefreshAllPivotTable" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biRefreshPivotTable" Command="{Binding RefreshPivotTable, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biRefreshAllPivotTable" Command="{Binding RefreshAllPivotTable, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biChangeDataSourcePivotTable" Command="{Binding ChangeDataSourcePivotTable, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biPivotTableActionsClearGroup" Command="{Binding PivotTableActionsClearGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biClearAllPivotTable" />
<dxb:BarButtonItemLink BarItemName="biClearFiltersPivotTable" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biClearAllPivotTable" Command="{Binding ClearAllPivotTable, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biClearFiltersPivotTable" Command="{Binding ClearFiltersPivotTable, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biPivotTableActionsSelectGroup" Command="{Binding PivotTableActionsSelectGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biSelectValuesPivotTable" />
<dxb:BarButtonItemLink BarItemName="biSelectLabelsPivotTable" />
<dxb:BarButtonItemLink BarItemName="biSelectEntirePivotTable" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biSelectValuesPivotTable" Command="{Binding SelectValuesPivotTable, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biSelectLabelsPivotTable" Command="{Binding SelectLabelsPivotTable, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biSelectEntirePivotTable" Command="{Binding SelectEntirePivotTable, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biMovePivotTable" Command="{Binding MovePivotTable, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biPivotTableCalculationFieldsItemsSetsGroup" Command="{Binding PivotTableCalculationFieldsItemsSetsGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biPivotTableCalculatedField" />
<dxb:BarButtonItemLink BarItemName="biPivotTableCalculatedItem" />
<dxb:BarButtonItemLink BarItemName="biPivotTableCalculatedItemSolveOrder" />
<dxb:BarButtonItemLink BarItemName="biPivotTableListFormulas" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biPivotTableCalculatedField" Command="{Binding PivotTableCalculatedField, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biPivotTableCalculatedItem" Command="{Binding PivotTableCalculatedItem, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biPivotTableCalculatedItemSolveOrder" Command="{Binding PivotTableCalculatedItemSolveOrder, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biPivotTableListFormulas" Command="{Binding PivotTableListFormulas, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarCheckItem x:Name="biFieldListPanelPivotTable" Command="{Binding FieldListPanelPivotTable, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarCheckItem x:Name="biShowPivotTableExpandCollapseButtons" Command="{Binding ShowPivotTableExpandCollapseButtons, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarCheckItem x:Name="biShowPivotTableFieldHeaders" Command="{Binding ShowPivotTableFieldHeaders, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biPivotTableLayoutSubtotalsGroup" Command="{Binding PivotTableLayoutSubtotalsGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biPivotTableDoNotShowSubtotals" />
<dxb:BarButtonItemLink BarItemName="biPivotTableShowAllSubtotalsAtBottom" />
<dxb:BarButtonItemLink BarItemName="biPivotTableShowAllSubtotalsAtTop" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biPivotTableDoNotShowSubtotals" Command="{Binding PivotTableDoNotShowSubtotals, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biPivotTableShowAllSubtotalsAtBottom" Command="{Binding PivotTableShowAllSubtotalsAtBottom, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biPivotTableShowAllSubtotalsAtTop" Command="{Binding PivotTableShowAllSubtotalsAtTop, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biPivotTableLayoutGrandTotalsGroup" Command="{Binding PivotTableLayoutGrandTotalsGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biPivotTableGrandTotalsOffRowsColumns" />
<dxb:BarButtonItemLink BarItemName="biPivotTableGrandTotalsOnRowsColumns" />
<dxb:BarButtonItemLink BarItemName="biPivotTableGrandTotalsOnRowsOnly" />
<dxb:BarButtonItemLink BarItemName="biPivotTableGrandTotalsOnColumnsOnly" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biPivotTableGrandTotalsOffRowsColumns" Command="{Binding PivotTableGrandTotalsOffRowsColumns, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biPivotTableGrandTotalsOnRowsColumns" Command="{Binding PivotTableGrandTotalsOnRowsColumns, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biPivotTableGrandTotalsOnRowsOnly" Command="{Binding PivotTableGrandTotalsOnRowsOnly, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biPivotTableGrandTotalsOnColumnsOnly" Command="{Binding PivotTableGrandTotalsOnColumnsOnly, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biPivotTableLayoutReportLayoutGroup" Command="{Binding PivotTableLayoutReportLayoutGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biPivotTableShowCompactForm" />
<dxb:BarButtonItemLink BarItemName="biPivotTableShowOutlineForm" />
<dxb:BarButtonItemLink BarItemName="biPivotTableShowTabularForm" />
<dxb:BarButtonItemLink BarItemName="biPivotTableRepeatAllItemLabels" />
<dxb:BarButtonItemLink BarItemName="biPivotTableDoNotRepeatItemLabels" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biPivotTableShowCompactForm" Command="{Binding PivotTableShowCompactForm, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biPivotTableShowOutlineForm" Command="{Binding PivotTableShowOutlineForm, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biPivotTableShowTabularForm" Command="{Binding PivotTableShowTabularForm, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biPivotTableRepeatAllItemLabels" Command="{Binding PivotTableRepeatAllItemLabels, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biPivotTableDoNotRepeatItemLabels" Command="{Binding PivotTableDoNotRepeatItemLabels, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarSubItem x:Name="biPivotTableLayoutBlankRowsGroup" Command="{Binding PivotTableLayoutBlankRowsGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxb:BarSubItem.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biPivotTableInsertBlankLineEachItem" />
<dxb:BarButtonItemLink BarItemName="biPivotTableRemoveBlankLineEachItem" />
</dxb:BarSubItem.ItemLinks>
</dxb:BarSubItem>
<dxb:BarButtonItem x:Name="biPivotTableInsertBlankLineEachItem" Command="{Binding PivotTableInsertBlankLineEachItem, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarButtonItem x:Name="biPivotTableRemoveBlankLineEachItem" Command="{Binding PivotTableRemoveBlankLineEachItem, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarStaticItem x:Name="biPivotTableToggleRowHeaders" ContentTemplate="{Binding CheckEditTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" Command="{Binding PivotTableToggleRowHeaders, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarStaticItem x:Name="biPivotTableToggleColumnHeaders" ContentTemplate="{Binding CheckEditTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" Command="{Binding PivotTableToggleColumnHeaders, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarStaticItem x:Name="biPivotTableToggleBandedRows" ContentTemplate="{Binding CheckEditTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" Command="{Binding PivotTableToggleBandedRows, Mode=OneTime, Source={StaticResource commands}}" />
<dxb:BarStaticItem x:Name="biPivotTableToggleBandedColumns" ContentTemplate="{Binding CheckEditTemplate, Mode=OneTime, Source={StaticResource defaultBarItemTemplates}}" Command="{Binding PivotTableToggleBandedColumns, Mode=OneTime, Source={StaticResource commands}}" />
</dxb:BarManager.Items>
<DockPanel>
<dxr:RibbonControl x:Name="ribbonControl1" DockPanel.Dock="Top" ShowApplicationButton="False" RibbonStyle="Office2010">
<dxr:RibbonControl.ToolbarItemLinks>
<dxb:BarButtonItemLink BarItemName="biFileSave" />
<dxb:BarButtonItemLink BarItemName="biFileUndo" />
<dxb:BarButtonItemLink BarItemName="biFileRedo" />
</dxr:RibbonControl.ToolbarItemLinks>
<dxr:RibbonDefaultPageCategory>
<dxr:RibbonPage x:Name="pageFile" Caption="{Binding ConverterParameter=Caption_PageFile, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup x:Name="grpFileCommon" Caption="{Binding ConverterParameter=Caption_GroupCommon, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biFileNew" />
<dxb:BarButtonItemLink BarItemName="biFileOpen" />
<dxb:BarButtonItemLink BarItemName="biFileSave" />
<dxb:BarButtonItemLink BarItemName="biFileSaveAs" />
<dxb:BarButtonItemLink BarItemName="biFileQuickPrint" />
<dxb:BarButtonItemLink BarItemName="biFilePrint" />
<dxb:BarButtonItemLink BarItemName="biFilePrintPreview" />
<dxb:BarButtonItemLink BarItemName="biFileUndo" />
<dxb:BarButtonItemLink BarItemName="biFileRedo" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpFileInfo" Caption="{Binding ConverterParameter=Caption_GroupInfo, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biFileEncrypt" />
<dxb:BarButtonItemLink BarItemName="biFileShowDocumentProperties" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup Caption="Database">
<dxb:BarButtonItem x:Name="buttonAddRecord" Content="Add Record" LargeGlyph="{dx:DXImage Image=Add_32x32.png}" Glyph="{dx:DXImage Image=Add_16x16.png}" ItemClick="buttonAddRecord_ItemClick"/>
<dxb:BarButtonItem x:Name="buttonRemoveRecord" Content="Remove Record" LargeGlyph="{dx:DXImage Image=Remove_32x32.png}" Glyph="{dx:DXImage Image=Remove_16x16.png}" ItemClick="buttonRemoveRecord_ItemClick"/>
<dxb:BarButtonItem x:Name="buttonApplyChanges" Content="Apply Changes" LargeGlyph="{dx:DXImage Image=Apply_32x32.png}" Glyph="{dx:DXImage Image=Apply_16x16.png}" ItemClick="buttonApplyChanges_ItemClick"/>
<dxb:BarButtonItem x:Name="buttonCancelChanges" Content="Cancel Changes" LargeGlyph="{dx:DXImage Image=Cancel_32x32.png}" Glyph="{dx:DXImage Image=Cancel_16x16.png}" ItemClick="buttonCancelChanges_ItemClick"/>
</dxr:RibbonPageGroup>
</dxr:RibbonPage>
<dxr:RibbonPage x:Name="pageHome" Caption="{Binding ConverterParameter=Caption_PageHome, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup x:Name="grpHomeClipboard" Caption="{Binding ConverterParameter=Caption_GroupClipboard, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biEditPaste" />
<dxb:BarButtonItemLink BarItemName="biEditCut" />
<dxb:BarButtonItemLink BarItemName="biEditCopy" />
<dxb:BarButtonItemLink BarItemName="biEditPasteSpecial" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpHomeFont" CaptionButtonCommand="{Binding FormatCellsFont, Mode=OneTime, Source={StaticResource commands}}" Caption="{Binding ConverterParameter=Caption_GroupFont, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup.ItemLinks>
<dxr:BarButtonGroupLink BarItemName="biFont" />
<dxr:BarButtonGroupLink BarItemName="biFontShape" />
<dxr:BarButtonGroupLink BarItemName="biFontColor" />
<dxr:BarButtonGroupLink BarItemName="bi" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpHomeAlignment" CaptionButtonCommand="{Binding FormatCellsAlignment, Mode=OneTime, Source={StaticResource commands}}" Caption="{Binding ConverterParameter=Caption_GroupAlignment, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup.ItemLinks>
<dxr:BarButtonGroupLink BarItemName="biVerticalAlignment" />
<dxr:BarButtonGroupLink BarItemName="biHorizontalAlignment" />
<dxr:BarButtonGroupLink BarItemName="biIndent" />
<dxb:BarCheckItemLink BarItemName="biFormatWrapText" />
<dxb:BarSubItemLink BarItemName="biEditingMergeCellsCommandGroup" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpHomeNumber" CaptionButtonCommand="{Binding FormatCellsNumber, Mode=OneTime, Source={StaticResource commands}}" Caption="{Binding ConverterParameter=Caption_GroupNumber, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup.ItemLinks>
<dxr:BarButtonGroupLink BarItemName="biFormatNumbers" />
<dxr:BarButtonGroupLink BarItemName="biFormatNumberDecimals" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpHomeStyles" Caption="{Binding ConverterParameter=Caption_GroupStyles, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biConditionalFormattingCommandGroup" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpHomeCells" Caption="{Binding ConverterParameter=Caption_GroupCells, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biInsertCellsCommandGroup" />
<dxb:BarSubItemLink BarItemName="biRemoveCellsCommandGroup" />
<dxb:BarSubItemLink BarItemName="biFormatCommandGroup" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpHomeEditing" Caption="{Binding ConverterParameter=Caption_GroupEditing, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biEditingAutoSumCommandGroup" />
<dxb:BarSubItemLink BarItemName="biEditingFillCommandGroup" />
<dxb:BarSubItemLink BarItemName="biFormatClearCommandGroup" />
<dxb:BarSubItemLink BarItemName="biEditingSortAndFilterCommandGroup" />
<dxb:BarSubItemLink BarItemName="biEditingFindAndSelectCommandGroup" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
</dxr:RibbonPage>
<dxr:RibbonPage x:Name="pageInsert" Caption="{Binding ConverterParameter=Caption_PageInsert, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup x:Name="grpInsertTables" Caption="{Binding ConverterParameter=Caption_GroupTables, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biInsertPivotTable" />
<dxb:BarButtonItemLink BarItemName="biInsertTable" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpInsertIllustrations" Caption="{Binding ConverterParameter=Caption_GroupIllustrations, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biInsertPicture" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpInsertCharts" Caption="{Binding ConverterParameter=Caption_GroupCharts, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSplitButtonItemLink BarItemName="biInsertChartColumnCommandGroup" />
<dxb:BarSplitButtonItemLink BarItemName="biInsertChartLineCommandGroup" />
<dxb:BarSplitButtonItemLink BarItemName="biInsertChartPieCommandGroup" />
<dxb:BarSplitButtonItemLink BarItemName="biInsertChartBarCommandGroup" />
<dxb:BarSplitButtonItemLink BarItemName="biInsertChartAreaCommandGroup" />
<dxb:BarSplitButtonItemLink BarItemName="biInsertChartScatterCommandGroup" />
<dxb:BarSplitButtonItemLink BarItemName="biInsertChartOtherCommandGroup" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpInsertLinks" Caption="{Binding ConverterParameter=Caption_GroupLinks, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biInsertHyperlink" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpInsertSymbols" Caption="{Binding ConverterParameter=Caption_GroupSymbols, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biInsertSymbol" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
</dxr:RibbonPage>
<dxr:RibbonPage x:Name="pagePageLayout" Caption="{Binding ConverterParameter=Caption_PagePageLayout, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup x:Name="grpPageLayoutPageSetup" CaptionButtonCommand="{Binding PageSetupPage, Mode=OneTime, Source={StaticResource commands}}" Caption="{Binding ConverterParameter=Caption_GroupPageSetup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biPageSetupMarginsCommandGroup" />
<dxb:BarSubItemLink BarItemName="biPageSetupOrientationCommandGroup" />
<dxb:BarSubItemLink BarItemName="biPageSetupPaperKindCommandGroup" />
<dxb:BarSubItemLink BarItemName="biPageSetupPrintAreaCommandGroup" />
<dxb:BarButtonItemLink BarItemName="biPageSetupPrintTitles" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpPageLayoutShow" Caption="{Binding ConverterParameter=Caption_GroupShow, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarStaticItemLink BarItemName="biViewShowGridlines" />
<dxb:BarStaticItemLink BarItemName="biViewShowHeadings" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpPageLayoutPrint" CaptionButtonCommand="{Binding PageSetupSheet, Mode=OneTime, Source={StaticResource commands}}" Caption="{Binding ConverterParameter=Caption_GroupPrint, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarStaticItemLink BarItemName="biPageSetupPrintGridlines" />
<dxb:BarStaticItemLink BarItemName="biPageSetupPrintHeadings" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpPageLayoutArrange" Caption="{Binding ConverterParameter=Caption_GroupArrange, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biPageLayoutArrangeBringForwardCommandGroup" />
<dxb:BarSubItemLink BarItemName="biPageLayoutArrangeSendBackwardCommandGroup" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
</dxr:RibbonPage>
<dxr:RibbonPage x:Name="pageFormulas" Caption="{Binding ConverterParameter=Caption_PageFormulas, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup x:Name="grpFormulasFunctionLibrary" Caption="{Binding ConverterParameter=Caption_GroupFunctionLibrary, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biFunctionsAutoSumCommandGroup" />
<dxb:BarSubItemLink BarItemName="biFunctionsFinancialCommandGroup" />
<dxb:BarSubItemLink BarItemName="biFunctionsLogicalCommandGroup" />
<dxb:BarSubItemLink BarItemName="biFunctionsTextCommandGroup" />
<dxb:BarSubItemLink BarItemName="biFunctionsDateAndTimeCommandGroup" />
<dxb:BarSubItemLink BarItemName="biFunctionsLookupAndReferenceCommandGroup" />
<dxb:BarSubItemLink BarItemName="biFunctionsMathAndTrigonometryCommandGroup" />
<dxb:BarSubItemLink BarItemName="biFunctionsStatisticalCommandGroup" />
<dxb:BarSubItemLink BarItemName="biFunctionsEngineeringCommandGroup" />
<dxb:BarSubItemLink BarItemName="biFunctionsInformationCommandGroup" />
<dxb:BarSubItemLink BarItemName="biFunctionsCompatibilityCommandGroup" />
<dxb:BarSubItemLink BarItemName="biFunctionsWebCommandGroup" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpFormulasDefinedNames" Caption="{Binding ConverterParameter=Caption_GroupFormulaDefinedNames, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biFormulasShowNameManager" />
<dxb:BarButtonItemLink BarItemName="biFormulasDefineNameCommand" />
<dxb:BarSubItemLink BarItemName="biFormulasInsertDefinedNameCommandGroup" />
<dxb:BarButtonItemLink BarItemName="biFormulasCreateDefinedNamesFromSelection" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpFormulasFormulaAuditing" Caption="{Binding ConverterParameter=Caption_GroupFormulaAuditing, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarCheckItemLink BarItemName="biViewShowFormulas" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpFormulasCalculation" Caption="{Binding ConverterParameter=Caption_GroupFormulaCalculation, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biFormulasCalculationOptionsCommandGroup" />
<dxb:BarButtonItemLink BarItemName="biFormulasCalculateNow" />
<dxb:BarButtonItemLink BarItemName="biFormulasCalculateSheet" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
</dxr:RibbonPage>
<dxr:RibbonPage x:Name="pageData" Caption="{Binding ConverterParameter=Caption_PageData, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup x:Name="grpDataSortFilter" Caption="{Binding ConverterParameter=Caption_GroupSortAndFilter, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biDataSortAscending" />
<dxb:BarButtonItemLink BarItemName="biDataSortDescending" />
<dxb:BarCheckItemLink BarItemName="biDataFilterToggle" />
<dxb:BarButtonItemLink BarItemName="biDataFilterClear" />
<dxb:BarButtonItemLink BarItemName="biDataFilterReApply" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpDataDataTools" Caption="{Binding ConverterParameter=Caption_GroupDataTools, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biDataValidationCommandGroup" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpDataOutline" CaptionButtonCommand="{Binding DataOutlineSetting, Mode=OneTime, Source={StaticResource commands}}" Caption="{Binding ConverterParameter=Caption_GroupOutline, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biDataOutlineGroupCommandGroup" />
<dxb:BarSubItemLink BarItemName="biDataOutlineUngroupCommandGroup" />
<dxb:BarButtonItemLink BarItemName="biDataSubtotal" />
<dxb:BarButtonItemLink BarItemName="biDataShowDetail" />
<dxb:BarButtonItemLink BarItemName="biDataHideDetail" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
</dxr:RibbonPage>
<dxr:RibbonPage x:Name="pageReview" Caption="{Binding ConverterParameter=Caption_PageReview, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup x:Name="grpReviewComments" Caption="{Binding ConverterParameter=Caption_GroupComments, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biReviewInsertComment" />
<dxb:BarButtonItemLink BarItemName="biReviewEditComment" />
<dxb:BarButtonItemLink BarItemName="biReviewDeleteComment" />
<dxb:BarButtonItemLink BarItemName="biReviewShowHideComment" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpReviewChanges" Caption="{Binding ConverterParameter=Caption_GroupChanges, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biReviewProtectSheet" />
<dxb:BarButtonItemLink BarItemName="biReviewUnprotectSheet" />
<dxb:BarButtonItemLink BarItemName="biReviewProtectWorkbook" />
<dxb:BarButtonItemLink BarItemName="biReviewUnprotectWorkbook" />
<dxb:BarButtonItemLink BarItemName="biReviewShowProtectedRangeManager" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
</dxr:RibbonPage>
<dxr:RibbonPage x:Name="pageView" Caption="{Binding ConverterParameter=Caption_PageView, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup x:Name="grpViewShow" Caption="{Binding ConverterParameter=Caption_GroupShow, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarStaticItemLink BarItemName="biViewShowGridlines" />
<dxb:BarStaticItemLink BarItemName="biViewShowHeadings" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpViewZoom" Caption="{Binding ConverterParameter=Caption_GroupZoom, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biViewZoom" />
<dxb:BarButtonItemLink BarItemName="biViewZoomOut" />
<dxb:BarButtonItemLink BarItemName="biViewZoomIn" />
<dxb:BarButtonItemLink BarItemName="biViewZoom100Percent" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpViewWindow" Caption="{Binding ConverterParameter=Caption_GroupWindow, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biViewFreezePanesCommandGroup" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
</dxr:RibbonPage>
</dxr:RibbonDefaultPageCategory>
<dxr:RibbonPageCategory x:Name="catChartTools" Caption="{Binding ConverterParameter=Caption_PageCategoryChartTools, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" Custom:AttachedCommand.Command="{Binding ToolsChartCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:RibbonPage x:Name="pageChartToolsDesign" Caption="{Binding ConverterParameter=Caption_PageChartsDesign, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup x:Name="grpChartToolsDesignData" Caption="{Binding ConverterParameter=Caption_GroupChartsDesignData, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biChartSwitchRowColumn" />
<dxb:BarButtonItemLink BarItemName="biChartSelectData" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpChartToolsDesignChartLayouts" Caption="{Binding ConverterParameter=Caption_GroupChartsDesignLayouts, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxr:RibbonGalleryBarItemLink BarItemName="biGalleryChartLayout" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
</dxr:RibbonPage>
<dxr:RibbonPage x:Name="pageChartToolsLayout" Caption="{Binding ConverterParameter=Caption_PageChartsLayout, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup x:Name="grpChartToolsLayoutLabels" Caption="{Binding ConverterParameter=Caption_GroupChartsLayoutLabels, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSplitButtonItemLink BarItemName="biChartTitleCommandGroup" />
<dxb:BarSubItemLink BarItemName="biChartAxisTitlesCommandGroup" />
<dxb:BarSplitButtonItemLink BarItemName="biChartLegendCommandGroup" />
<dxb:BarSplitButtonItemLink BarItemName="biChartDataLabelsCommandGroup" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpChartToolsLayoutAxes" Caption="{Binding ConverterParameter=Caption_GroupChartsLayoutAxes, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biChartAxesCommandGroup" />
<dxb:BarSubItemLink BarItemName="biChartGridlinesCommandGroup" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpChartToolsLayoutAnalysis" Caption="{Binding ConverterParameter=Caption_GroupChartsLayoutAnalysis, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSplitButtonItemLink BarItemName="biChartLinesCommandGroup" />
<dxb:BarSplitButtonItemLink BarItemName="biChartUpDownBarsCommandGroup" />
<dxb:BarSplitButtonItemLink BarItemName="biChartErrorBarsCommandGroup" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
</dxr:RibbonPage>
<dxr:RibbonPage x:Name="pageChartToolsFormat" Caption="{Binding ConverterParameter=Caption_PageFormat, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup x:Name="grpChartToolsFormatArrange" Caption="{Binding ConverterParameter=Caption_GroupArrange, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biChartToolsFormatArrangeBringForwardCommandGroup" />
<dxb:BarSubItemLink BarItemName="biChartToolsFormatArrangeSendBackwardCommandGroup" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
</dxr:RibbonPage>
</dxr:RibbonPageCategory>
<dxr:RibbonPageCategory x:Name="catPictureTools" Caption="{Binding ConverterParameter=Caption_PageCategoryPictureTools, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" Custom:AttachedCommand.Command="{Binding ToolsPictureCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:RibbonPage x:Name="pagePictureToolsFormat" Caption="{Binding ConverterParameter=Caption_PageFormat, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup x:Name="grpPictureToolsFormatArrange" Caption="{Binding ConverterParameter=Caption_GroupArrange, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biPictureToolsFormatArrangeBringForwardCommandGroup" />
<dxb:BarSubItemLink BarItemName="biPictureToolsFormatArrangeSendBackwardCommandGroup" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
</dxr:RibbonPage>
</dxr:RibbonPageCategory>
<dxr:RibbonPageCategory x:Name="catDrawingTools" Caption="{Binding ConverterParameter=Caption_PageCategoryDrawingTools, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" Custom:AttachedCommand.Command="{Binding ToolsDrawingCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:RibbonPage x:Name="pageDrawingToolsFormat" Caption="{Binding ConverterParameter=Caption_PageFormat, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup x:Name="grpDrawingToolsFormatArrange" Caption="{Binding ConverterParameter=Caption_GroupArrange, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biDrawingToolsFormatArrangeBringForwardCommandGroup" />
<dxb:BarSubItemLink BarItemName="biDrawingToolsFormatArrangeSendBackwardCommandGroup" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
</dxr:RibbonPage>
</dxr:RibbonPageCategory>
<dxr:RibbonPageCategory x:Name="catTableTools" Caption="{Binding ConverterParameter=Caption_PageCategoryTableTools, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" Custom:AttachedCommand.Command="{Binding TableToolsCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:RibbonPage x:Name="pageTableToolsDesign" Caption="{Binding ConverterParameter=Caption_TableToolsDesignPage, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup x:Name="grpTableToolsDesignTools" Caption="{Binding ConverterParameter=Caption_GroupTableTools, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biTableConvertToRange" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpTableToolsDesignTableStyleOptions" Caption="{Binding ConverterParameter=Caption_GroupTableStyleOptions, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarStaticItemLink BarItemName="biTableToggleHeaderRow" />
<dxb:BarStaticItemLink BarItemName="biTableToggleTotalRow" />
<dxb:BarStaticItemLink BarItemName="biTableToggleBandedColumns" />
<dxb:BarStaticItemLink BarItemName="biTableToggleFirstColumn" />
<dxb:BarStaticItemLink BarItemName="biTableToggleLastColumn" />
<dxb:BarStaticItemLink BarItemName="biTableToggleBandedRows" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
</dxr:RibbonPage>
</dxr:RibbonPageCategory>
<dxr:RibbonPageCategory x:Name="catPivotTableTools" Caption="{Binding ConverterParameter=Caption_PageCategoryPivotTableTools, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" Custom:AttachedCommand.Command="{Binding ToolsPivotTableCommandGroup, Mode=OneTime, Source={StaticResource commands}}">
<dxr:RibbonPage x:Name="pagePivotTableToolsAnalyze" Caption="{Binding ConverterParameter=Caption_PivotTableAnalyze, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup x:Name="grpPivotTableToolsAnalyzePivotTable" Caption="{Binding ConverterParameter=Caption_PivotTableAnalyzePivotTable, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biOptionsPivotTable" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpPivotTableToolsAnalyzeActiveField" Caption="{Binding ConverterParameter=Caption_PivotTableAnalyzeActiveField, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biSelectFieldTypePivotTable" />
<dxb:BarButtonItemLink BarItemName="biPivotTableExpandField" />
<dxb:BarButtonItemLink BarItemName="biPivotTableCollapseField" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpPivotTableToolsAnalyzeGroup" Caption="{Binding ConverterParameter=Caption_PivotTableAnalyzeGroup, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarButtonItemLink BarItemName="biPivotTableGroupSelection" />
<dxb:BarButtonItemLink BarItemName="biPivotTableUngroup" />
<dxb:BarButtonItemLink BarItemName="biPivotTableGroupField" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpPivotTableToolsAnalyzeData" Caption="{Binding ConverterParameter=Caption_PivotTableAnalyzeData, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biPivotTableDataRefreshGroup" />
<dxb:BarButtonItemLink BarItemName="biChangeDataSourcePivotTable" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpPivotTableToolsAnalyzeActions" Caption="{Binding ConverterParameter=Caption_PivotTableAnalyzeActions, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biPivotTableActionsClearGroup" />
<dxb:BarSubItemLink BarItemName="biPivotTableActionsSelectGroup" />
<dxb:BarButtonItemLink BarItemName="biMovePivotTable" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpPivotTableToolsAnalyzeCalculations" Caption="{Binding ConverterParameter=Caption_PivotTableAnalyzeCalculations, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biPivotTableCalculationFieldsItemsSetsGroup" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpPivotTableToolsAnalyzeShow" Caption="{Binding ConverterParameter=Caption_PivotTableAnalyzeShow, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarCheckItemLink BarItemName="biFieldListPanelPivotTable" />
<dxb:BarCheckItemLink BarItemName="biShowPivotTableExpandCollapseButtons" />
<dxb:BarCheckItemLink BarItemName="biShowPivotTableFieldHeaders" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
</dxr:RibbonPage>
<dxr:RibbonPage x:Name="pagePivotTableToolsDesign" Caption="{Binding ConverterParameter=Caption_PivotTableDesign, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}">
<dxr:RibbonPageGroup x:Name="grpPivotTableToolsDesignLayout" Caption="{Binding ConverterParameter=Caption_PivotTableDesignLayout, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarSubItemLink BarItemName="biPivotTableLayoutSubtotalsGroup" />
<dxb:BarSubItemLink BarItemName="biPivotTableLayoutGrandTotalsGroup" />
<dxb:BarSubItemLink BarItemName="biPivotTableLayoutReportLayoutGroup" />
<dxb:BarSubItemLink BarItemName="biPivotTableLayoutBlankRowsGroup" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
<dxr:RibbonPageGroup x:Name="grpPivotTableToolsDesignPivotTableStyleOptions" Caption="{Binding ConverterParameter=Caption_PivotTableDesignPivotTableStyleOptions, Converter={StaticResource stringIdConverter}, Mode=OneTime, Source={StaticResource stringIdConverter}}" ShowCaptionButton="False">
<dxr:RibbonPageGroup.ItemLinks>
<dxb:BarStaticItemLink BarItemName="biPivotTableToggleRowHeaders" />
<dxb:BarStaticItemLink BarItemName="biPivotTableToggleColumnHeaders" />
<dxb:BarStaticItemLink BarItemName="biPivotTableToggleBandedRows" />
<dxb:BarStaticItemLink BarItemName="biPivotTableToggleBandedColumns" />
</dxr:RibbonPageGroup.ItemLinks>
</dxr:RibbonPageGroup>
</dxr:RibbonPage>
</dxr:RibbonPageCategory>
</dxr:RibbonControl>
<Grid>
<Grid.RowDefinitions>
<RowDefinition Height="Auto" />
<RowDefinition Height="*" />
</Grid.RowDefinitions>
<dxsps:SpreadsheetFormulaBarControl x:Name="formulaBar" SpreadsheetControl="{Binding ElementName=spreadsheetControl}" />
<dxsps:SpreadsheetControl x:Name="spreadsheetControl" BarManager="{Binding ElementName=barManager1, Mode=OneTime}" Ribbon="{Binding ElementName=ribbonControl1, Mode=OneTime}" Grid.Row="1" PreviewMouseLeftButtonDown="spreadsheetControl_PreviewMouseLeftButtonDown" RowsRemoved="spreadsheetControl_RowsRemoved" RowsRemoving="spreadsheetControl_RowsRemoving" >
<dxsps:SpreadsheetControl.Options>
<dxsps:SpreadsheetControlOptions RaiseEventsOnModificationsViaAPI="True"/>
</dxsps:SpreadsheetControl.Options>
</dxsps:SpreadsheetControl>
</Grid>
</DockPanel>
</dxb:BarManager>
</Grid>
</dxr:DXRibbonWindow>
C##region #Namespaces
using DevExpress.Spreadsheet;
using System;
using System.Windows;
using WpfSpreadsheet_BindToDataSource.NWindDataSetTableAdapters;
// ...
#endregion #Namespaces
namespace WpfSpreadsheet_BindToDataSource
{
/// <summary>
/// Interaction logic for MainWindow.xaml
/// </summary>
public partial class MainWindow : DevExpress.Xpf.Ribbon.DXRibbonWindow
{
bool applyChangesOnRowsRemoved = false;
#region #BindToData
NWindDataSet dataSet;
SuppliersTableAdapter adapter;
public MainWindow()
{
InitializeComponent();
BindWorksheetToDataSource();
}
private void BindWorksheetToDataSource()
{
dataSet = new NWindDataSet();
adapter = new SuppliersTableAdapter();
// Populate the "Suppliers" data table with data.
adapter.Fill(dataSet.Suppliers);
IWorkbook workbook = spreadsheetControl.Document;
// Load the template document into the SpreadsheetControl.
workbook.LoadDocument("Documents\\Suppliers_template.xlsx", DocumentFormat.Xlsx);
Worksheet sheet = workbook.Worksheets[0];
// Load data from the "Suppliers" data table into the worksheet starting from the cell "B12".
sheet.DataBindings.BindToDataSource(dataSet.Suppliers, 11, 1);
}
#endregion #BindToData
#region #UpdateData
void spreadsheetControl_PreviewMouseLeftButtonDown(object sender, System.Windows.Input.MouseButtonEventArgs e)
{
Point winPoint = e.GetPosition(spreadsheetControl);
System.Drawing.Point point = new System.Drawing.Point((int)winPoint.X, (int)winPoint.Y);
Cell cell = spreadsheetControl.GetCellFromPoint(point);
if (cell == null)
return;
Worksheet sheet = spreadsheetControl.ActiveWorksheet;
string cellReference = cell.GetReferenceA1();
// If the "Save" cell is clicked in the data entry form,
// add a row containing the entered values to the database table.
if (cellReference == "I4")
{
AddRow(sheet);
HideDataEntryForm(sheet);
ApplyChanges();
}
// If the "Cancel" cell is clicked in the data entry form,
// cancel adding new data and hide the data entry form.
else if (cellReference == "I6")
{
HideDataEntryForm(sheet);
}
}
void AddRow(Worksheet sheet)
{
try
{
// Append a new row to the "Suppliers" data table.
dataSet.Suppliers.AddSuppliersRow(
sheet["C4"].Value.TextValue, sheet["C6"].Value.TextValue, sheet["C8"].Value.TextValue,
sheet["E4"].Value.TextValue, sheet["E6"].Value.TextValue, sheet["E8"].Value.TextValue,
sheet.Cells["G4"].DisplayText, sheet.Cells["G6"].DisplayText);
}
catch (Exception ex)
{
string message = string.Format("Cannot add a row to a database table.\n{0}", ex.Message);
MessageBox.Show(message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
void HideDataEntryForm(Worksheet sheet)
{
CellRange range = sheet.Range.Parse("C4,C6,C8,E4,E6,E8,G4,G6");
range.ClearContents();
sheet.Rows.Hide(2, 9);
}
void ApplyChanges()
{
try
{
// Send the updated data back to the database.
adapter.Update(dataSet.Suppliers);
}
catch (Exception ex)
{
string message = string.Format("Cannot update data in a database table.\n{0}", ex.Message);
MessageBox.Show(message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
void spreadsheetControl_RowsRemoving(object sender, RowsChangingEventArgs e)
{
Worksheet sheet = spreadsheetControl.ActiveWorksheet;
CellRange rowRange = sheet.Range.FromLTRB(0, e.StartIndex, 16383, e.StartIndex + e.Count - 1);
CellRange boundRange = sheet.DataBindings[0].Range;
// If the rows to be removed belong to the data-bound range,
// display a dialog requesting the user to confirm the deletion of records.
if (boundRange.IsIntersecting(rowRange))
{
MessageBoxResult result = MessageBox.Show("Want to delete the selected supplier(s)?", "Delete",
MessageBoxButton.YesNo, MessageBoxImage.Question);
applyChangesOnRowsRemoved = result == MessageBoxResult.Yes;
e.Cancel = result == MessageBoxResult.No;
return;
}
}
void spreadsheetControl_RowsRemoved(object sender, RowsChangedEventArgs e)
{
if (applyChangesOnRowsRemoved)
{
applyChangesOnRowsRemoved = false;
// Update data in the database.
ApplyChanges();
}
}
void buttonAddRecord_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
CloseInplaceEditor();
Worksheet sheet = spreadsheetControl.ActiveWorksheet;
// Display the data entry form on the worksheet to add a new record to the "Suppliers" data table.
if (!sheet.Rows[4].Visible)
sheet.Rows.Unhide(2, 9);
spreadsheetControl.SelectedCell = sheet["C4"];
}
void buttonRemoveRecord_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
CloseInplaceEditor();
Worksheet sheet = spreadsheetControl.ActiveWorksheet;
CellRange selectedRange = spreadsheetControl.Selection;
CellRange boundRange = sheet.DataBindings[0].Range;
// Verify that the selected cell range belongs to the data-bound range.
if (!boundRange.IsIntersecting(selectedRange) || selectedRange.TopRowIndex < boundRange.TopRowIndex)
{
MessageBox.Show("Select a record first!", "Remove Record", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
// Remove the topmost row of the selected cell range.
sheet.Rows.Remove(selectedRange.TopRowIndex);
}
void buttonApplyChanges_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
CloseInplaceEditor();
// Update data in the database.
ApplyChanges();
}
void buttonCancelChanges_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
// Close the cell in-place editor if it's currently active.
CloseInplaceEditor();
// Load the latest saved data into the "Suppliers" data table.
adapter.Fill(dataSet.Suppliers);
}
void CloseInplaceEditor()
{
if (spreadsheetControl.IsCellEditorActive)
spreadsheetControl.CloseCellEditor(DevExpress.XtraSpreadsheet.CellEditorEnterValueMode.Default);
}
#endregion #UpdateData
}
}