Aspose::Cells::Style::GetNumber method
Contents
[
Hide
]Style::GetNumber method
Gets or sets the display format of numbers and dates. The formatting patterns are different for different regions.
int32_t Aspose::Cells::Style::GetNumber()
Remarks
For example, the formatting patterns represented by numbers for en_US region:
| Value | Type | Format String |
|---|---|---|
| 0 | General | General |
| 1 | Decimal | 0 |
| 2 | Decimal | 0.00 |
| 3 | Decimal | #,##0 |
| 4 | Decimal | #,##0.00 |
| 5 | Currency | $#,##0_);($#,##0) |
| 6 | Currency | $#,##0_);Red |
| 7 | Currency | $#,##0.00_);($#,##0.00) |
| 8 | Currency | $#,##0.00_);Red |
| 9 | Percentage | 0% |
| 10 | Percentage | 0.00% |
| 11 | Scientific | 0.00E+00 |
| 12 | Fraction | # ?/? |
| 13 | Fraction | # ??/?? |
| 14 | Date | m/d/yyyy |
| 15 | Date | d-mmm-yy |
| 16 | Date | d-mmm |
| 17 | Date | mmm-yy |
| 18 | Time | h:mm AM/PM |
| 19 | Time | h:mm:ss AM/PM |
| 20 | Time | h:mm |
| 21 | Time | h:mm:ss |
| 22 | Time | m/d/yyyy h:mm |
| 37 | Accounting | #,##0_);(#,##0) |
| 38 | Accounting | #,##0_);Red |
| 39 | Accounting | #,##0.00_);(#,##0.00) |
| 40 | Accounting | #,##0.00_);Red |
| 41 | Accounting | (* #,##0);(* (#,##0);(* “-”);(@) |
| 42 | Currency | ($* #,##0_);($* (#,##0);($* “-”);(@) |
| 43 | Accounting | (* #,##0.00_);(* (#,##0.00);(* “-”??);(@) |
| 44 | Currency | ($* #,##0.00_);($* (#,##0.00);($* “-”??);(@_) |
| 45 | Time | mm:ss |
| 46 | Time | [h]:mm:ss |
| 47 | Time | mm:ss.0 |
| 48 | Scientific | ##0.0E+0 |
| 49 | Text |
See Also
- Class Vector
- Class Style
- Namespace Aspose::Cells
- Library Aspose.Cells for C++