Skip to main content
All docs
V25.1
  • Row

    PivotField.NumberFormatLocal Property

    Specifies a local number format used to display numeric values (for example, date and time) within the PivotTable field.

    Namespace: DevExpress.Spreadsheet

    Assembly: DevExpress.Spreadsheet.v25.1.Core.dll

    NuGet Package: DevExpress.Spreadsheet.Core

    Declaration

    string NumberFormatLocal { get; set; }

    Property Value

    Type Description
    String

    The number format to apply to the pivot field.

    Remarks

    The Spreadsheet allows you to use Microsoft Excel number formats to format numeric values within a row, column, or page field. Use the NumberFormatLocal property to specify a number format based on the local culture defined by the DocumentOptions.Culture property. The PivotField.NumberFormat option allows you to obtain or specify a number format in the invariant culture.

    To apply a number format to a data field, use the PivotDataField.NumberFormat or PivotDataField.NumberFormatLocal property.

    See Also