Get Started

API Reference

Enum

ExcelNumberPreset

Edit on GitHub
Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Source OfficeIMO.Excel/ExcelSheet.Charts.cs:153
Base Enum
Implements
IComparable ISpanFormattable IFormattable IConvertible
Modifiers sealed

Common number format presets for convenience. For full control, use a custom format string.

Inheritance

  • Enum
  • ExcelNumberPreset

Usage

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Returned or exposed by

Accepted by parameters

Values

public const ExcelNumberPreset General #

General format with no specific pattern.

Value: 0
public const ExcelNumberPreset Integer #

Whole number with thousands separators.

Value: 1
public const ExcelNumberPreset Decimal #

Decimal number with configurable fraction digits.

Value: 2
public const ExcelNumberPreset Percent #

Percentage format.

Value: 3
public const ExcelNumberPreset Currency #

Currency format using culture-specific symbol.

Value: 4
public const ExcelNumberPreset Scientific #

Scientific notation.

Value: 5
public const ExcelNumberPreset DateShort #

Short date format (yyyy-mm-dd).

Value: 6
public const ExcelNumberPreset DateLong #

Long date/time format (yyyy-mm-dd hh:mm).

Value: 7
public const ExcelNumberPreset Time #

Time format (h:mm:ss).

Value: 8
public const ExcelNumberPreset DateTime #

Date and time format (yyyy-mm-dd hh:mm:ss).

Value: 9
public const ExcelNumberPreset DurationHours #

Duration in hours format ([h]:mm:ss).

Value: 10
public const ExcelNumberPreset Text #

Text format.

Value: 11