Skip to main content

PivotGridStringId Enum

Lists values corresponding to strings that can be localized.

Namespace: DevExpress.XtraPivotGrid.Localization

Assembly: DevExpress.PivotGrid.v23.2.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Declaration

public enum PivotGridStringId

Members

Name Description
RowHeadersCustomization

The text displayed within the Row Header Area when it contains no field headers.

Default value: Drop Row Fields Here

ColumnHeadersCustomization

The text displayed within the Column Area when it contains no field headers.

Default value: Drop Column Fields Here

FilterHeadersCustomization

The text displayed within the Filter Header Area when it contains no field headers.

Default value: Drop Filter Fields Here

DataHeadersCustomization

The text displayed within the Data Header Area when it contains no field headers.

Default value: Drop Data Items Here

RowArea

The text that represents the row area (displayed within the Customization Form).

Default value: Row Area

ColumnArea

The text that represents the column area (displayed within the Customization Form).

Default value: Column Area

FilterArea

The text that represents the filter area (displayed within the Customization Form).

Default value: Filter Area

DataArea

The text that represents the data area (displayed within the Customization Form).

Default value: Data Area

FilterShowAll

The caption of the filter dropdown list item used to show all field values.

Default value: (Show All)

FilterOk

The caption of the OK button displayed within the filter dropdown.

Default value: OK

FilterCancel

The caption of the Cancel button displayed within the filter dropdown.

Default value: Cancel

FilterBlank

The caption of the blank item in the group filter drop-down.

Default value: (Blank)

FilterShowBlanks

The caption of the filter dropdown list item used to show blank values.

Default value: (Show Blanks)

FilterInvert

The caption of the filter dropdown’s popup menu item used to invert the selection.

Default value: Invert Filter

CustomizationFormCaption

The caption of the Customization Form.

Default value: PivotGrid Field List

CustomizationFormText

The text displayed above the Customization Form’s field list.

Default value: Drag fields here to hide

CustomizationFormEmptyFilterText

The text displayed in the Customization Form’s field list when the string typed in the search box does not match any field name.

Default value: No match for the search string

CustomizationFormAddTo

The caption of the ‘Add To’ button displayed within the Customization Form.

Default value: Add To

CustomizationFormHint

The text displayed above the areas section in the Customization Form.

Default value: Drag fields between areas below:

CustomizationFormDeferLayoutUpdate

The caption of the check box in the Customization Form that allows you to perform delayed layout updates.

Default value: Defer Layout Update

CustomizationFormUpdate

The caption of the Customization Form’s update button.

Default value: Update

CustomizationFormListBoxText

The text displayed within the Customization Form’s field list when it is empty.

Default value: Drag a field here to customize layout

CustomizationFormHiddenFields

The text displayed within the Customization Form above the hidden fields list.

Default value: Hidden Fields

CustomizationFormAvailableFields

The text displayed above the Hidden Fields section in the Excel-style Customization Form when visible fields are included in it.

Default value: Choose fields to add to the report:

Total

The text displayed after the field name within the grand total column/row header, if a specific caption for grand total headers has not been specified.

Default value: Total

GrandTotal

The caption of grand total columns and rows.

Default value: Grand Total

TotalFormat

A pattern used to format headers of automatic total summary columns/rows.

Default value: {0} Total

Where {0} - the field value

TotalFormatCount

A pattern used to format headers of count total summary columns/rows.

Default value: {0} Count

Where {0} - the field value

TotalFormatSum

A pattern used to format headers of sum total summary columns/rows.

Default value: {0} Sum

Where {0} - the field value

TotalFormatMin

A pattern used to format headers of minimum total summary columns/rows.

Default value: {0} Min

Where {0} - the field value

TotalFormatMax

A pattern used to format headers of maximum total summary columns/rows.

Default value: {0} Max

Where {0} - the field value

TotalFormatAverage

A pattern used to format headers of average total summary columns/rows.

Default value: {0} Average

Where {0} - the field value

TotalFormatStdDev

A pattern used to format headers of standard deviation of a population subset total summary columns/rows.

Default value: {0} StdDev

Where {0} - the field value

TotalFormatStdDevp

A pattern used to format headers of standard deviation of the whole population total summary columns/rows.

Default value: {0} StdDevp

Where {0} - the field value

TotalFormatVar

A pattern used to format headers of variance of a population subset total summary columns/rows.

Default value: {0} Var

Where {0} - the field value

TotalFormatVarp

A pattern used to format headers of variance of the whole population total summary columns/rows.

Default value: {0} Varp

Where {0} - the field value

TotalFormatCustom

A pattern used to format headers of data fields with manually calculated summary values.

Default value: {0} Custom

Where {0} - the field value

TotalFormatCountDistinct

A pattern used to format headers of count distinct total summary columns/rows.

Default value: {0} Count Distinct

Where {0} - the field value

TotalFormatMedian

A pattern used to format headers of median total summary columns/rows.

Default value: {0} Median

Where {0} - the field value

TotalFormatMode

A pattern used to format headers of mode total summary columns/rows.

Default value: {0} Mode

Where {0} - the field value

PrintDesigner

The caption of the Print Designer dialog.

Default value: Print Designer

PrintDesignerPageOptions

The caption of the Print Designer dialog page that contains general printing options.

Default value: Options

PrintDesignerPageBehavior

The caption of the Print Designer dialog page that contains options used to specify the printing behavior.

Default value: Behavior

PrintDesignerCategoryDefault

The caption of the default options category in the Print Designer dialog.

Default value: Default

PrintDesignerCategoryLines

The caption of the Print Designer options category which contains options used to specify how cell borders are printed.

Default value: Lines

PrintDesignerCategoryHeaders

The caption of the Print Designer options category which contains options used to specify how field headers are printed.

Default value: Headers

PrintDesignerCategoryFieldValues

The caption of the Print Designer options category which contains options used to specify how field values are printed.

Default value: Field Values

PrintDesignerHorizontalLines

The caption of the Print Designer dialog option used to specify whether horizontal cell borders are printed.

Default value: Horizontal Lines

PrintDesignerVerticalLines

The caption of the Print Designer dialog option used to specify whether vertical cell borders are printed.

Default value: Vertical Lines

PrintDesignerFilterHeaders

The caption of the Print Designer dialog option used to specify whether headers of filter fields are printed.

Default value: Filter Headers

PrintDesignerDataHeaders

The caption of the Print Designer dialog option used to specify whether headers of data fields are printed.

Default value: Data Headers

PrintDesignerColumnHeaders

The caption of the Print Designer dialog option used to specify whether headers of column fields are printed.

Default value: Column Headers

PrintDesignerRowHeaders

The caption of the Print Designer dialog option used to specify whether headers of row fields are printed.

Default value: Row Headers

PrintDesignerHeadersOnEveryPage

The caption of the Print Designer dialog option used to specify whether headers are printed on every page.

Default value: Headers On Every Page

PrintDesignerColumnAreaOnEveryPage

Default value: Column Area On Every Page

PrintDesignerRowAreaOnEveryPage

Default value: Row Area On Every Page

PrintDesignerUnusedFilterFields

The caption of the Print Designer dialog option used to specify whether unused filter fields are printed.

Default value: Unused Filter Fields

PrintDesignerMergeColumnFieldValues

The caption of the Print Designer dialog option used to specify whether cells that display the same column field value are merged.

Default value: Merge Column Field Values

PrintDesignerMergeRowFieldValues

The caption of the Print Designer dialog option used to specify whether cells that display the same row field value are merged.

Default value: Merge Row Field Values

PrintDesignerUsePrintAppearance

The caption of the Print Designer dialog option used to specify whether print appearances are used when the pivot grid is printed.

Default value: Use Print Appearance

PopupMenuRefreshData

The caption of the context menu item used to refresh the pivot grid’s data.

Default value: Reload Data

PopupMenuSortAscending

The caption of the field header’s context menu item used to sort the field values in ascending order.

Default value: Sort A-Z

PopupMenuSortDescending

The caption of the field header’s context menu item used to sort the field values in descending order.

Default value: Sort Z-A

PopupMenuClearSorting

The caption of the field header’s context menu item used to clear the currently applied sorting.

Default value: Clear Sorting

PopupMenuShowExpression

The caption of the field value’s context menu item used to invoke the Expression Editor.

Default value: Expression Editor…

PopupMenuHideField

The caption of the field header’s context menu item used to hide the field.

Default value: Hide

PopupMenuBestFit

Default value: Best Fit

PopupMenuSummaryType

Default value: Summary Type

PopupMenuSortBySummary

Default value: Sort by Summary

PopupMenuShowFieldList

The caption of the context menu item used to invoke the Customization Form.

Default value: Show Field List

PopupMenuHideFieldList

The caption of the context menu item used to hide the Customization Form.

Default value: Hide Field List

PopupMenuFieldOrder

The name of the field header’s context menu item which contains subitems used to reorder fields.

Default value: Order

PopupMenuMovetoBeginning

The caption of the field header’s context menu item used to move the field to the first position in its area.

Default value: Move to Beginning

PopupMenuMovetoLeft

The caption of the field header’s context menu item used to move the field left.

Default value: Move to Left

PopupMenuMovetoRight

The caption of the field header’s context menu item used to move the field right.

Default value: Move to Right

PopupMenuMovetoEnd

The caption of the field header’s context menu item used to move the field to the last position in its area.

Default value: Move to End

PopupMenuCollapse

The name of the field value’s context menu item used to collapse the field value.

Default value: Collapse

PopupMenuExpand

The name of the field value’s context menu item used to expand the field value.

Default value: Expand

PopupMenuCollapseAll

The name of the field value’s context menu item used to collapse all values of the field.

Default value: Collapse All

PopupMenuExpandAll

The name of the field value’s context menu item used to expand all values of the field.

Default value: Expand All

PopupMenuShowFilter

Default value: Show Filter

PopupMenuHideFilter

Default value: Hide Filter

PopupMenuSortFieldByColumn

The caption of the column field value’s context menu item used to sort the other field values by this column.

Default value: Sort “{0}” by This Column

PopupMenuSortFieldByRow

The caption of the row field value’s context menu item used to sort the other field values by this row.

Default value: Sort “{0}” by This Row

PopupMenuRemoveAllSortByColumn

The name of the field value’s context menu item used to remove sorting by column.

Default value: Remove All Sorting

PopupMenuFixRowTop

The name of the field header’s context menu item that pins the row to the top.

Default value: Pin This Row to the Bottom

PopupMenuFixRowBottom

The name of the field header’s context menu item that pins the row to the bottom.

Default value: Pin This Row to the Bottom

PopupMenuFixColumnLeft

The name of the field header’s context menu item that pins the column to the left.

Default value: Pin This Column to the Left

PopupMenuFixColumnRight

The name of the field header’s context menu item that pins the column to the right.

Default value: Pin This Column to the Right

PopupMenuUnfixRowTop

The name of the field header’s context menu item that unpins the row from the top.

Default value: Unpin This Row from the Top

PopupMenuUnfixRowBottom

The name of the field header’s context menu item that unpins the row from the bottom.

Default value: Unpin This Row from the Bottom

PopupMenuUnfixColumnLeft

The name of the field header’s context menu item that unpins the column from the left.

Default value: Unpin This Column from the Left

PopupMenuUnfixColumnRight

The name of the field header’s context menu item that unpins the column from the right.

Default value: Unpin This Column from the Right

DataFieldCaption

The text displayed within the data field header.

Default value: Data

TopValueOthersRow

The text displayed within the header of the ‘Others’ row.

Default value: Others

CellError

The text displayed within a cell when an error occurs (the cell’s value is PivotSummaryValue.ErrorValue).

Default value: Error

ValueError

The text displayed within a field value cell when an error occurs.

Default value: Error

PrefilterInvalidProperty

If you specify an invalid field name in a Prefilter expression, this string will be displayed in the Prefilter window instead of that field name.

Default value: (invalid property)

FilterInvalidCriteria
FilterFormCaption

Default value: Filter Editor

EditFilter

Default value: Edit Filter

OLAPMeasuresCaption

The caption of the ‘measures’ tree item displayed in the field section of the Customization Form in the OLAP mode.

Default value: Measures

OLAPKPIsCaption

The caption of the ‘KPIs’ tree item displayed in the field section of the Customization Form in the OLAP mode.

Default value: KPIs

OLAPKPITypeValue

The caption of the ‘Value’ tree item (the KPI actually achieved value) displayed in the field section of the Customization Form in the OLAP mode.

Default value: Value

OLAPKPITypeGoal

The caption of the ‘Goal’ tree item (the KPI goal value) displayed in the field section of the Customization Form in the OLAP mode.

Default value: Goal

OLAPKPITypeStatus

The caption of the ‘Status’ tree item (the KPI status value) displayed in the field section of the Customization Form in the OLAP mode.

Default value: Status

OLAPKPITypeTrend

The caption of the ‘Trend’ tree item (the KPI trend value) displayed in the field section of the Customization Form in the OLAP mode.

Default value: Trend

OLAPKPITypeWeight

The caption of the ‘Weight’ tree item (the KPI weight value) displayed in the field section of the Customization Form in the OLAP mode.

Default value: Weight

OLAPDrillDownFilterException

The error message which is displayed when a drill-through is performed while multiple items are selected in the report filter field.

Default value: Show Details command cannot be executed when multiple items are selected in a report filter field. Select a single item for each field in the report filter area before performing a drill-through.

OLAPDrillDownTopNException

The error message which is displayed when a drill-through is performed while Top N is applied to one of the row/column fields.

Default value: Show Details command cannot be executed when Top N is applied to one of the row/column fields.

OLAPNoOleDbProvidersMessage

The message that appears if no OLE DB provider can be found on the system when binding the pivot grid to an OLAP data source.

Default value: In order to use the PivotGrid OLAP functionality, you should have a MS OLAP OleDb provider installed on your system.\r\nYou can download it here:

TrendGoingUp

The text of the tooltip displayed for KPI values representing an ascending trend.

Default value: Going Up

TrendGoingDown

The text of the tooltip displayed for KPI values representing a descending trend.

Default value: Going Down

TrendNoChange

The text of the tooltip displayed for KPI values representing a horizontal trend.

Default value: No Change

StatusBad

The text of the tooltip displayed for KPI values representing a bad progress state.

Default value: Bad

StatusNeutral

The text of the tooltip displayed for KPI values representing a neutral progress state.

Default value: Neutral

StatusGood

The text of the tooltip displayed for KPI values representing a good progress state.

Default value: Good

DateTimeQuarterFormat

Default value: Q{0}

SummaryCount

The text displayed within the headers of count summary data fields.

Default value: Count

SummarySum

The text displayed within the headers of sum summary data fields.

Default value: Sum

SummaryMin

The text displayed within the headers of minimum summary data fields.

Default value: Min

SummaryMax

The text displayed within the headers of maximum summary data fields.

Default value: Max

SummaryAverage

The text displayed within the headers of average summary data fields.

Default value: Average

SummaryStdDev

The text displayed within the headers of standard deviation of a population subset summary data fields.

Default value: StdDev

SummaryStdDevp

The text displayed within the headers of standard deviation of the whole population summary data fields.

Default value: StdDevp

SummaryVar

The text displayed within the headers of variance of a population subset summary data fields.

Default value: Var

SummaryVarp

The text displayed within the headers of variance of the whole population summary data fields.

Default value: Varp

SummaryCustom

The text displayed within the headers of data fields with manually calculated summary values.

Default value: Custom

SummaryCountDistinct

The text displayed within the headers of count distinct summary data fields.

Default value: Count Distinct

SummaryMedian

The text displayed within the headers of median summary data fields.

Default value: Median

SummaryMode

The text displayed within the headers of mode summary data fields.

Default value: Mode

CustomizationFormStackedDefault

The text that represents the Customization Form’s ‘Fields Section and Areas Section Stacked’ layout mode (displayed in the popup menu invoked by clicking the Customization Form Layout button).

Default value: Fields Section and Areas Section Stacked

CustomizationFormStackedSideBySide

The text that represents the Customization Form’s ‘Fields Section and Areas Section Side-By-Side’ layout mode (displayed in the popup menu invoked by clicking the Customization Form Layout button).

Default value: Fields Section and Areas Section Side-By-Side

CustomizationFormTopPanelOnly

The text that represents the Customization Form’s ‘Fields Section Only’ layout mode (displayed in the popup menu invoked by clicking the Customization Form Layout button).

Default value: Fields Section Only

CustomizationFormBottomPanelOnly2by2

The text that represents the Customization Form’s ‘Areas Section Only (2 by 2)’ layout mode (displayed in the popup menu invoked by clicking the Customization Form Layout button).

Default value: Areas Section Only (2 by 2)

CustomizationFormBottomPanelOnly1by4

The text that represents the Customization Form’s ‘Area Section Only (1 by 4)’ layout mode (displayed in the popup menu invoked by clicking the Customization Form Layout button).

Default value: Areas Section Only (1 by 4)

CustomizationFormLayoutButtonTooltip

The text displayed within the Customization Form Layout button’s tooltip.

Default value: Customization Form Layout

Alt_Expand

The alternative text for the expand button.

Default value: [Expand]

Alt_Collapse

The alternative text for the collapse button.

Default value: [Collapse]

Alt_SortedAscending

The alternative text for the ascending sorting image.

Default value: (Ascending)

Alt_SortedDescending

The alternative text for the descending sorting image.

Default value: (Descending)

Alt_FilterWindowSizeGrip

The alternative text for the filter drop-down’s size grip.

Default value: [Resize]

Alt_FilterButton

The alternative text for the filter button used when the field values are not filtered.

Default value: [Filter]

Alt_FilterButtonActive

The alternative text for the filter button used when the field values are filtered.

Default value: [Filtered]

Alt_DragHideField

The alternative text for the image displayed when a field is about to be hidden via drag-and-drop.

Default value: Hide

Alt_FilterAreaHeaders

The alternative text for the image displayed near the caption of the Filter Area Headers section in the Customization Form.

Default value: [Filter Area Headers]

Alt_ColumnAreaHeaders

The alternative text for the image displayed near the caption of the Column Area Headers section in the Customization Form.

Default value: [Column Area Headers]

Alt_RowAreaHeaders

The alternative text for the image displayed near the caption of the Row Area Headers section in the Customization Form.

Default value: [Row Area Headers]

Alt_DataAreaHeaders

The alternative text for the image displayed near the caption of the Data Area Headers section in the Customization Form.

Default value: [Data Area Headers]

Alt_FieldListHeaders

The alternative text for the image displayed near the caption of the Hidden Headers section in the Customization Form.

Default value: [Hidden Field’s Headers]

Alt_LayoutButton

The alternative text for the image displayed on the Layout button in the Customization Form.

Default value: [Layout Button]

Alt_StackedDefaultLayout

The alternative text for the image corresponding to the ‘Fields Section and Areas Section Stacked’ layout, displayed in the Customization Form Layout menu.

Default value: [Stacked Default Layout]

Alt_StackedSideBySideLayout

The alternative text for the image corresponding to the ‘Fields Section and Areas Section Side-By-Side’ layout, displayed in the Customization Form Layout menu.

Default value: [Stacked Side By Side Layout]

Alt_TopPanelOnlyLayout

The alternative text for the image corresponding to the ‘Fields Section Only’ layout, displayed in the Customization Form Layout menu.

Default value: [Top Panel Only Layout]

Alt_BottomPanelOnly2by2Layout

The alternative text for the image corresponding to the ‘Areas Section Only (2 by 2)’ layout, displayed in the Customization Form Layout menu.

Default value: [Bottom Panel Only 2 by 2 Layout]

Alt_BottomPanelOnly1by4Layout

The alternative text for the image corresponding to the ‘Areas Section Only (1 by 4)’ layout, displayed in the Customization Form Layout menu.

Default value: [Bottom Panel Only 1 by 4 Layout]

SearchBoxText

The text displayed within the Search Box in the Group Filter popup when the box is empty.

Default value: Search

PopupMenuKPIGraphic

The caption of a data field header context menu item that opens a submenu used to choose KPI graphics.

Default value: KPI Graphics

PopupMenuKPIGraphicNone

The caption of the context menu item that is used to disable KPI graphics.

Default value: None

PopupMenuKPIGraphicServerDefined

The caption of the context menu item that identifies server-defined KPI graphics.

Default value: Server Defined

PopupMenuKPIGraphicShapes

The caption of the context menu item that identifies the Shapes KPI graphics.

Default value: Shapes

PopupMenuKPIGraphicTrafficLights

The caption of the context menu item that identifies the Traffic Lights KPI graphics.

Default value: Traffic Lights

PopupMenuKPIGraphicRoadSigns

The caption of the context menu item that identifies the Road Signs KPI graphics.

Default value: Road Signs

PopupMenuKPIGraphicGauge

The caption of the context menu item that identifies the Gauge KPI graphics.

Default value: Gauge

PopupMenuKPIGraphicReversedGauge

The caption of the context menu item that identifies the Reversed Gauge KPI graphics.

Default value: Reversed Gauge

PopupMenuKPIGraphicThermometer

The caption of the context menu item that identifies the Thermometer KPI graphics.

Default value: Thermometer

PopupMenuKPIGraphicReversedThermometer

The caption of the context menu item that identifies the Reversed Thermometer KPI graphics.

Default value: Reversed Thermometer

PopupMenuKPIGraphicCylinder

The caption of the context menu item that identifies the Cylinder KPI graphics.

Default value: Cylinder

PopupMenuKPIGraphicReversedCylinder

The caption of the context menu item that identifies the Reversed Cylinder KPI graphics.

Default value: Reversed Cylinder

PopupMenuKPIGraphicFaces

The caption of the context menu item that identifies the Faces KPI graphics.

Default value: Faces

PopupMenuKPIGraphicVarianceArrow

The caption of the context menu item that identifies the Variance Arrow KPI graphics.

Default value: Variance Arrow

PopupMenuKPIGraphicStandardArrow

The caption of the context menu item that identifies the Standard Arrow KPI graphics.

Default value: Standard Arrow

PopupMenuKPIGraphicStatusArrow

The caption of the context menu item that identifies the Status Arrow KPI graphics.

Default value: Status Arrow

PopupMenuKPIGraphicReversedStatusArrow

The caption of the context menu item that identifies the Reversed Status Arrow KPI graphics.

Default value: Reversed Status Arrow

SummaryFilterRangeFrom

The text displayed on top of the summary filter popup window before the text editor used to specify the minimum of the visible values range.

Default value: Show values from

SummaryFilterRangeTo

The text displayed on top of the summary filter popup window, before the text editor used to specify the maximum of the visible values range.

Default value: to

SummaryFilterLegendHidden

The description for a legend item that identifies hidden summary values. Shown in the legend of the summary distribution diagram displayed within summary filter popup windows.

Default value: Hidden

SummaryFilterLegendVisible

The description for a legend item that identifies visible summary values. Shown in the legend of the summary distribution diagram displayed within summary filter popup windows.

Default value: Visible

SummaryFilterApplyToSpecificLevel

The caption of a check box that enables end-users to select a detail level to which summary filtering should be applied.

Default value: Apply to specific level

SummaryFilterColumnField

The caption of a combo box used to select a column field that identifies a detail level to which summary filtering is applied.

Default value: Column field:

SummaryFilterRowField

The caption of a combo box used to select a row field that identifies a detail level to which summary filtering is applied.

Default value: Row field:

SummaryFilterMaxValueCount

The description displayed above a constant line that indicates the maximum number of summary values that fall into a single subrange. This constant line is shown in a summary distribution diagram displayed within summary filter popup windows.

Default value: Max Count

SummaryFilterMaxVisibleCount

The description displayed above a constant line that indicates the maximum number of visible summary values that fall into a single subrange. This constant line is shown in a summary distribution diagram displayed within summary filter popup windows.

Default value: Max Visible Count

SummaryFilterLabelValues

The horizontal axis label of the summary distribution diagram displayed in summary filter popup windows.

Default value: Values

SummaryFilterClearButton

The caption of a button that resets the summary filter.

Default value: Clear

DrillDownException

The error message which is displayed when a drilldown dataset cannot be retrieved.

Default value: Error retrieving drilldown dataset.

OptimizedEngineServerModeNotSupportedException

Default value: The Optimized data processing engine does not support Server Mode. Do not switch to the Optimized engine when working with data sources that operate in Server Mode.

PopupMenuFormatRules

The caption of the context menu item used to invoke the Format Rules menu.

Default value: Format Rules

PopupMenuFormatRulesIntersectionOnly

The caption of the check box in the Format Rules context menu that allows you to specify whether the rule is applied only to field intersection.

Default value: Apply only to specific level

PopupMenuFormatRulesClearMeasureRules

The caption of the context menu item used to clear rules from specific measure.

Default value: Clear Rules from This Measure

PopupMenuFormatRulesClearIntersectionRules

The caption of the context menu item used to clear rules from specific intersection.

Default value: Clear Rules from This Intersection

PopupMenuFormatRulesClearAllRules

The caption of the context menu item used to clear rules from all measures.

Default value: Clear Rules From All Measures

PopupMenuFormatRulesMeasure

The caption of the Measure field header in the Conditional Formatting Rules Manager.

Default value: Measure

PopupMenuFormatRulesColumn

The caption of the Column field header in the Conditional Formatting Rules Manager.

Default value: Column

PopupMenuFormatRulesRow

The caption of the Row field header in the Conditional Formatting Rules Manager.

Default value: Row

PopupMenuFormatRulesAnyField

The caption of the any field item in the Conditional Formatting Rules Manager’s combo box.

Default value: (Any)

PopupMenuFormatRulesGrandTotal

The caption of the Grand Total item in the Conditional Formatting Rules Manager’s combo box.

Default value: (Grand Total)

ExpressionValidationCircularDependency

Default value: The following fields have circular dependency: {0}

ExpressionValidationInvalidProperty

Default value: The {0} not found.

ExpressionValidationNotSummaryExpressionExpected

Default value: Criteria cannot contain aggregates.

ExpressionValidationSummaryExpressionExpected

Default value: A summary expression is expected.

ExpressionValidationInvalidArgumentCount

Default value: The number of arguments for the {0} function is invalid.

ExpressionValidationInvalidFunctionArgument

Default value: The ‘{0}’ function expects ‘{1}’ as the {2} argument.

ExpressionValidationFunctionIsNotSupported

Default value: The {0} function is not supported in the current calculation mode.

ExpressionValidationExpressionIsEmpty

Default value: An expression cannot be empty.

ExpressionValidationInvalidWindowExpressionUsage

Default value: The {0} function can be used only in a window expression.

ExpressionValidationInvalidExpression

Default value: The expression cannot be evaluated.

ServerRequestError

Default value: Error occurred during processing server request ({0})

ExpressionEditorFieldDescription

Default value: Caption: {0}\r\nType: {1}

ExpressionEditorFieldsCategory

Default value: Fields

PopupMenuMore

A caption for the drop-down menu item that expands to display the additional DateTime group intervals. The menu is available if the PivotGridOptionsMenu.ShowDateTimeGroupIntervalItems property is set to DateTimeGroupIntervals.ExtendedIntervals.

Default value: More

DateTimeGroupIntervalQuarter

A caption that identifies the predefined group interval PivotGroupInterval.DateQuarter.

Default value: Quarter

DateTimeGroupIntervalMonth

A caption that identifies the predefined group interval PivotGroupInterval.DateMonth.

Default value: Month

DateTimeGroupIntervalDay

A caption that identifies the predefined group interval PivotGroupInterval.DateDay.

Default value: Day

DateTimeGroupIntervalHour

A caption that identifies the predefined group interval PivotGroupInterval.Hour.

Default value: Hour

DateTimeGroupIntervalMinute

A caption that identifies the predefined group interval PivotGroupInterval.Minute.

Default value: Minute

DateTimeGroupIntervalSecond

A caption that identifies the predefined group interval PivotGroupInterval.Second.

Default value: Second

DateTimeGroupIntervalDayOfYear

A caption that identifies the predefined group interval PivotGroupInterval.DateDayOfYear.

Default value: Day of Year

DateTimeGroupIntervalDayOfWeek

A caption that identifies the predefined group interval PivotGroupInterval.DateDayOfWeek.

Default value: Day of Week

DateTimeGroupIntervalWeekOfYear

A caption that identifies the predefined group interval PivotGroupInterval.DateWeekOfYear.

Default value: Week of Year

DateTimeGroupIntervalWeekOfMonth

A caption that identifies the predefined group interval PivotGroupInterval.DateWeekOfMonth.

Default value: Week of Month

DateTimeGroupIntervalMonthYear

A caption that identifies the predefined group interval PivotGroupInterval.DateMonthYear.

Default value: Month - Year

DateTimeGroupIntervalQuarterYear

A caption that identifies the predefined group interval PivotGroupInterval.DateQuarterYear.

Default value: Quarter - Year

DateTimeGroupIntervalDayMonthYear

A caption that identifies the predefined group interval PivotGroupInterval.DateMonthYear.

Default value: Day-Month-Year

DateTimeGroupIntervalDateHour

A caption that identifies the predefined group interval PivotGroupInterval.DateHour.

Default value: Date-Hour

DateTimeGroupIntervalDateHourMinute

A caption that identifies the predefined group interval PivotGroupInterval.DateHourMinute.

Default value: Date-Hour-Minute

DateTimeGroupIntervalDateHourMinuteSecond

A caption that identifies the predefined group interval PivotGroupInterval.DateHourMinuteSecond.

Default value: Date-Hour-Minute-Second

DateTimeGroupIntervalDateWeekYear

A caption that identifies the predefined PivotGroupInterval.DateHourMinuteSecond group interval.

Default value: Week-Year

DateTimeGroupIntervalExactDate

A caption that specifies a DateTime group interval other than the DateTime combinations defined in the PivotGroupInterval enumeration.

Default value: Exact Date

DateTimeGroupIntervalYear

A caption that identifies the predefined group interval DevExpress.XtraPivotGrid.PivotGroupInterval.Year.

Default value: Year

SearchForField

The text displayed in the empty Customization Form’s search box. The search box is shown if the PivotGridOptionsCustomizationEx.CustomizationFormSearchBoxVisible property is true.

Default value: Search for a field…

FunctionDescriptionAggr

Default value: aggr(SummaryExpression, Dimension1, Dimension2, …) Aggregates underlying data using the detail level and the summary function. The level is specified by a predefined set of dimensions.

FunctionDescriptionIsTotal
FunctionDescriptionWindowAvg

Default value: WindowAvg(SummaryExpression, StartOffset, EndOffset) Returns the average of the expression within the window, which is defined using offsets from the current row.

FunctionDescriptionRankCompetition

Default value: RankCompetition(SummaryExpression, [‘asc’, ‘desc’]) Returns the standard competition rank for the current row in the window.

FunctionDescriptionWindowCountDistinct

Default value: WindowCountDistinct(SummaryExpression, StartOffset, EndOffset) Returns the distinct count of the expression within the window.

FunctionDescriptionWindowCount

Default value: WindowCount(SummaryExpression, StartOffset, EndOffset) Returns the count of the expression within the window.

FunctionDescriptionRankDense

Default value: RankDense(SummaryExpression, [‘asc’, ‘desc’]) Returns the dense rank for the current row in the window.

FunctionDescriptionFirst

Default value: First() Returns the number of rows from the current row to the first row in the window.

FunctionDescriptionIndex

Default value: Index() Returns the index of the current row in the window.

FunctionDescriptionLast

Default value: Last() Returns the number of rows from the current row to the last row in the window.

FunctionDescriptionLookup

Default value: Lookup(SummaryExpression, Position) Returns the value of the expression in a target position specified as a relative offset from the current position.

FunctionDescriptionWindowMax

Default value: WindowMax(SummaryExpression, StartOffset, EndOffset) Returns the maximum of the expression within the window.

FunctionDescriptionWindowMedian

Default value: WindowMedian(SummaryExpression, StartOffset, EndOffset) Returns the median of the expression within the window.

FunctionDescriptionWindowFirstValue
FunctionDescriptionWindowMode

Default value: WindowMode(SummaryExpression, StartOffset, EndOffset) Returns the mode of the expression within the window.

FunctionDescriptionWindowMin

Default value: WindowMin(SummaryExpression, StartOffset, EndOffset) Returns the minimum of the expression within the window.

FunctionDescriptionRankModified

Default value: RankModified(SummaryExpression, [‘asc’, ‘desc’]) Returns the modified competition rank for the current row in the window.

FunctionDescriptionRankPercentile

Default value: RankPercentile(SummaryExpression, [‘asc’, ‘desc’]) Returns the percentile rank for the current row in the window.

FunctionDescriptionRunningAvg

Default value: RunningAvg(SummaryExpression) Returns the running average of the specified expression from the first row in the window to the current row.

FunctionDescriptionRunningCount

Default value: RunningCount(SummaryExpression) Returns the running count of the specified expression from the first row in the window to the current row.

FunctionDescriptionRunningMax

Default value: RunningMax(SummaryExpression) Returns the running maximum of the specified expression from the first row in the window to the current row.

FunctionDescriptionRunningMin

Default value: RunningMin(SummaryExpression) Returns the running minimum of the specified expression from the first row in the window to the current row.

FunctionDescriptionRunningSum

Default value: RunningSum(SummaryExpression) Returns the running sum of the specified expression from the first row in the window to the current row.

FunctionDescriptionSize

Default value: Size() Returns the number of rows in the window.

FunctionDescriptionWindowStdDev

Default value: WindowStdDev(SummaryExpression, StartOffset, EndOffset) Returns the sample standard deviation of the expression within the window.

FunctionDescriptionWindowStdDevp

Default value: WindowStdDevp(SummaryExpression, StartOffset, EndOffset) Returns the biased standard deviation of the expression within the window.

FunctionDescriptionWindowSum

Default value: WindowSum(SummaryExpression, StartOffset, EndOffset) Returns the sum of the expression within the window.

FunctionDescriptionTotal

Default value: Total(SummaryExpression) Returns the total for the specified expression in a table calculation window.

FunctionDescriptionRankUnique

Default value: RankUnique(SummaryExpression, [‘asc’, ‘desc’]) Returns the unique rank for the current row in the window.

FunctionDescriptionWindowVar

Default value: WindowVar(SummaryExpression, StartOffset, EndOffset) Returns the variance of the expression within the window.

FunctionDescriptionWindowVarp

Default value: WindowVarp(SummaryExpression, StartOffset, EndOffset) Returns the biased variance of the expression within the window.

FunctionCategoryWindow

Default value: Window

FunctionCategoryCustomAggregateNames
FunctionCategoryAdvanced

A caption of the Advanced category in the Function section in the Filter editor.

Default value: Advanced

FunctionDescriptionGetDateHour

Default value: GetDateHour(DateTime) Extracts the date part with the hour value from the defined DateTime.

FunctionDescriptionGetDateHourMinute

Default value: GetDateHourMinute(DateTime) Extracts the date part with the hour and minute values from the defined DateTime.

FunctionDescriptionGetDateHourMinuteSecond

Default value: GetDateHourMinuteSecond(DateTime) Extracts the date part with the hour, minute, and second values from the defined DateTime.

FunctionDescriptionGetDateMonthYear

Default value: GetDateMonthYear(DateTime) Returns the date of the first day of the month for a given DateTime.

FunctionDescriptionGetDateQuarterYear

Default value: GetDateQuarterYear(DateTime) Returns the date of the first day of the quarter for a given DateTime.

FunctionDescriptionGetQuarter

Default value: GetQuarter(DateTime) Extracts a quarter from the defined DateTime.

FunctionDescriptionGetWeekOfMonth

Default value: GetWeekOfMonth(DateTime) Extracts the week of the month from the defined DateTime.

FunctionDescriptionGetWeekOfYear

Default value: GetWeekOfYear(DateTime) Extracts the week of the year from the defined DateTime.

FunctionDescriptionToDateTime

Default value: ToDateTime(Value) Converts Value to a DateTime value.

FunctionDescriptionToBoolean

Default value: ToBoolean(Value) Converts Value to an equivalent Boolean value.

FunctionDescriptionMakeDateTime3

Default value: MakeDateTime(Year, Month, Day) Returns a date value constructed from the specified Year, Month and Day.

FunctionDescriptionMakeDateTime4

Default value: MakeDateTime(Year, Month, Day, Hour) Returns a date value constructed from the specified Year, Month, Day and Hour.

FunctionDescriptionMakeDateTime5

Default value: MakeDateTime(Year, Month, Day, Hour, Minute) Returns a date value constructed from the specified Year, Month, Day, Hour and Minute.

FunctionDescriptionMakeDateTime6

Default value: MakeDateTime(Year, Month, Day, Hour, Minute, Second) Returns a date value constructed from the specified Year, Month, Day, Hour, Minute and Second.

FunctionDescriptionGetDateWeekYear

Default value: GetDateWeekYear(DateTime) Returns the date of the first day of the week for a given DateTime (uses culture settings).

FunctionDescriptionGetDateWeekYear2

Default value: GetDateWeekYear(DateTime, [‘FirstDay’, ‘FirstFullWeek’, ‘FirstFourDayWeek’]) Returns the date of the first day of the week for a given DateTime. The second parameter determines the rule for calculating the calendar week.

FunctionCategoryAggregate

Default value: Aggregate

FunctionDescriptionCountNotNull

Default value: CountNotNull(Value) Returns a number of non-null values in rows used to calculate an aggregate value.

FunctionDescriptionMode

Default value: Mode(Value) Returns the mode of the values, where the mode is the value that is repeated the most.

FunctionDescriptionCountDistinct

Default value: CountDistinct(Value) Returns the number of unique values in rows used to calculate an aggregate value.

FunctionDescriptionMedian

Default value: Median(Value) Returns the median of the values in rows used to calculate an aggregate value.

FunctionDescriptionStdDev

Default value: StdDev(Value) Returns an estimate of the standard deviation of a population, where the sample is a subset of the entire population.

FunctionDescriptionStdDevp

Default value: StdDevp(Value) Returns the standard deviation of a population, where the population is the entire data to be summarized.

FunctionDescriptionVar

Default value: Var(Value) Returns an estimate of the variance of a population, where the sample is a subset of the entire population.

FunctionDescriptionVarp

Default value: Varp(Value) Returns the variance of a population, where the population is the entire data to be summarized.

FunctionDescriptionCount

Default value: Count() Returns the number of rows used to calculate an aggregate value.

FunctionDescriptionMax

Default value: Max(Value) Returns the maximum value from rows used to calculate an aggregate value.

FunctionDescriptionMin

Default value: Min(Value) Returns the minimum value from rows used to calculate an aggregate value.

FunctionDescriptionAvg

Default value: Avg(Value) Calculates the average value from rows used to calculate an aggregate value.

FunctionDescriptionSum

Default value: Sum(Value) Returns the sum of the values in rows.

FunctionDescriptionWindowCustomAggregate
FunctionDescriptionRunningCustomAggregate
FunctionDescriptionFirstValue
FunctionDescriptionWindowDefinitionOrderDesc

Default value: desc(column) Data rows are sorted by values in the specified column in descending order.

FunctionDescriptionWindowDefinitionOrderAsc

Default value: asc(column) Data rows are sorted by values in the specified column in ascending order. This is the default sort order.

FunctionDescriptionWindowDefinitionOrderBy

Default value: orderBy(column1, column2, …) Specifies the columns by which the values are sorted.

FunctionDescriptionWindowDefinitionPartitionBy

Default value: partitionBy(column1, column2, …) Specifies the columns by which the data rows are partitioned. The window function is applied to each partition separately.

FunctionDescriptionWindowDefinition

Default value: w(WindowExpression, partitionByFunction, orderByFunction) Calculates aggregated values with the specified window function for the window defined by the specified partitioning and ordering.

See Also