As we know that Aspose.Grid is composed of two controls: Aspose.Grid.Desktop & Aspose.Grid.Web. Both controls support a large number of number formats, which are divided into two sections with respect to each control as follows:
- Number Formats Supported in Aspose.Grid.Desktop
- Number Formats Supported in Aspose.Grid.Web
Number Formats Supported in Aspose.Grid.Desktop
Aspose.Grid.Desktop supports 59 types of number formats which are listed below:
|
Index
|
Number Formats
|
|
0
|
General
|
|
1
|
0
|
|
2
|
0.00
|
|
3
|
#,##0
|
|
4
|
#,##0.00
|
|
5
|
\"$\"#,##0_);(\"$\"#,##0)
|
|
6
|
\"$\"#,##0_);[Red](\"$\"#,##0)
|
|
7
|
\"$\"#,##0.00_);(\"$\"#,##0.00)
|
|
8
|
\"$\"#,##0.00;[Red]\"$\"-#,##0.00
|
|
9
|
0%
|
|
10
|
0.00%
|
|
11
|
0.00E+00
|
|
12
|
#?/?
|
|
13
|
#/
|
|
14
|
m/d/yy
|
|
15
|
d-mmm-yy
|
|
16
|
d-mmm
|
|
17
|
mmm-yy
|
|
18
|
h:mm AM/PM
|
|
19
|
h:mm:ss AM/PM
|
|
20
|
h:mm
|
|
21
|
h:mm:ss
|
|
22
|
m/d/yy h:mm
|
|
23
|
\"$\"#,##0;[Red](\"$\"#,##0)
|
|
24
|
\"$\"#,##0.00;(\"$\"#,##0.00)
|
|
25
|
\"$\"#,##0.00;[Red](\"$\"#,##0.00)
|
|
26
|
\"$\"#,##0.00_);[Red](\"$\"#,##0.00)
|
|
27
|
M月D日
|
|
28
|
M月D日
|
|
29
|
M月D日
|
|
30
|
M/D/YY
|
|
31
|
YYYY年M月D日
|
|
32
|
h时mm分
|
|
33
|
h\时\"mm\"分\"ss\"秒\"
|
|
34
|
tth时mm分
|
|
35
|
tth时mm分ss秒
|
|
36
|
YYYY年M月
|
|
37
|
(#,##0);(#,##0)
|
|
38
|
(#,##0);[Red](#,##0)
|
|
39
|
(#,##0.00);(#,##0.00)
|
|
40
|
(#,##0.00);[Red](#,##0.00)
|
|
41
|
(\"$\"#,##0);(\"$\"(#,##0);(\"$\"*\"-\");(@_)
|
|
42
|
(#,##0);((#,##0);(*\-\");(@_)
|
|
43
|
(#,##0.00);((#,##0.00);(*\-\"??);(@_)
|
|
44
|
(\"$\"#,##0.00);(\"$\"(#,##0.00);(\"$\"*\"-\"??);(@_)
|
|
45
|
mm:ss
|
|
46
|
h:mm:ss
|
|
47
|
mm:ss.0
|
|
48
|
##0.0E+0
|
|
49
|
@
|
|
50
|
YYYY年M月
|
|
51
|
|