NumberType
NumberType enumeration
Represents the number or datetime format type.
public enum NumberType
Values
Name | Value | Description |
---|---|---|
General | 0 |
General |
Decimal1 | 1 |
Decimal 0 |
Decimal2 | 2 |
Decimal 0.00 |
Decimal3 | 3 |
Decimal #,##0 |
Decimal4 | 4 |
Decimal #,##0.00 |
Currency1 | 5 |
Currency $#,##0;$-#,##0 |
Currency2 | 6 |
Currency $#,##0;[Red]$-#,##0 |
Currency3 | 7 |
Currency $#,##0.00;$-#,##0.00 |
Currency4 | 8 |
Currency $#,##0.00;[Red]$-#,##0.00 |
Percentage1 | 9 |
Percentage 0% |
Percentage2 | 10 |
Percentage 0.00% |
Scientific1 | 11 |
Scientific 0.00E+00 |
Fraction1 | 12 |
Fraction # ?/? |
Fraction2 | 13 |
Fraction # ??/?? |
Date1 | 14 |
Date m/d/yyyy |
Date2 | 15 |
Date d-mmm-yy |
Date3 | 16 |
Date d-mmm |
Date4 | 17 |
Date mmm-yy |
Time1 | 18 |
Time h:mm AM/PM |
Time2 | 19 |
Time h:mm:ss AM/PM |
Time3 | 20 |
Time h:mm |
Time4 | 21 |
Time h:mm:ss |
Time5 | 22 |
Time m/d/yy h:mm |
Currency5 | 37 |
Currency #,##0;-#,##0 |
Currency6 | 38 |
Currency #,##0;[Red]-#,##0 |
Currency7 | 39 |
Currency #,##0.00;-#,##0.00 |
Currency8 | 40 |
Currency #,##0.00;[Red]-#,##0.00 |
Accounting1 | 41 |
Accounting _ * #,##0_ ;_ * -#,##0_ ;_ * “-”_ ;_ @_ |
Accounting2 | 42 |
Accounting _ $* #,##0_ ;_ $* -#,##0_ ;_ $* “-”_ ;_ @_ |
Accounting3 | 43 |
Accounting _ * #,##0.00_ ;_ * -#,##0.00_ ;_ * “-”??_ ;_ @_ |
Accounting4 | 44 |
Accounting _ $* #,##0.00_ ;_ $* -#,##0.00_ ;_ $* “-”??_ ;_ @_ |
Time6 | 45 |
Time mm:ss |
Time7 | 46 |
Time [h]:mm:ss |
Time8 | 47 |
Time mm:ss.0 |
Scientific2 | 48 |
Scientific ##0.0E+00 |
Text | 49 |
Text @ |
Currency9 | 23 |
Currency $#,##0;($#,##0) |
Currency10 | 24 |
Currency $#,##0;Red |
Currency11 | 25 |
Currency $#,##0.00;($#,##0.00) |
Currency12 | 26 |
Currency $#,##0.00;Red |
EasternDate1 | 27 |
Date YYYY?M? |
EasternDate2 | 28 |
Date M?D? |
EasternDate3 | 29 |
Date M?D? |
EasternDate4 | 30 |
Date M/D/YY |
EasternDate5 | 31 |
Date YYYY?M?D? |
EasternDate6 | 36 |
Date YYYY?M? |
EasternDate7 | 50 |
Date YYYY?M? |
EasternDate8 | 51 |
Date M?D? |
EasternDate9 | 52 |
Date YYYY?M? |
EasternDate10 | 53 |
Date M?D? |
EasternDate11 | 54 |
Date M?D? |
EasternDate12 | 57 |
Date YYYY?M? |
EasternDate13 | 58 |
Date M?D? |
EasternTime1 | 32 |
Time h?mm? |
EasternTime2 | 33 |
Time h?mm?ss? |
EasternTime3 | 34 |
Time tth?mm? |
EasternTime4 | 35 |
Time tth?mm?ss? |
EasternTime5 | 55 |
Time tth?mm? |
EasternTime6 | 56 |
Time tth?mm?ss? |
See Also
- namespace Aspose.Cells.GridWeb.Data
- assembly Aspose.Cells.GridWeb