Aspose::Cells::Style::SetNumber method

Style::SetNumber method

Gets or sets the display format of numbers and dates. The formatting patterns are different for different regions.

void Aspose::Cells::Style::SetNumber(int32_t value)

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++