From cdfc7251bde8347678d355e5fe65fc20e120bc23 Mon Sep 17 00:00:00 2001
From: Randy Morgan The recommended way to manage styles is Styles#add_style
+The recommended way to manage styles is Styles#add_style
+ A NumFmt object defines an identifier and formatting code for data in
-cells.
+A NumFmt object defines an identifier and formatting code for data in
+cells.
+
The formatting to use for this number format.
++The formatting to use for this number format. +
An unsinged integer referencing a standard or custom number format.
++An unsinged integer referencing a standard or custom number format. +
A new instance of NumFmt.
++A new instance of NumFmt. +
Creates a numFmt element applying the instance values of this object as -attributes.
++Creates a numFmt element applying the instance values of this object as +attributes. +
A new instance of NumFmt
++A new instance of NumFmt +
# File 'lib/axlsx/stylesheet/num_fmt.rb', line 45 -def initialize(={}) - @numFmtId = 0 - @formatCode = "" - .each do |o| - self.send("#{o[0]}=", o[1]) if self.respond_to? o[0] - end -end+def initialize(={}) + @numFmtId = 0 + @formatCode = "" + .each do |o| + self.send("#{o[0]}=", o[1]) if self.respond_to? o[0] + end +end +
The formatting to use for this number format.
++The formatting to use for this number format. +
The formatting to use for this number format.
++The formatting to use for this number format. +
# File 'lib/axlsx/stylesheet/num_fmt.rb', line 44 -def formatCode - @formatCode -end+def formatCode + @formatCode +end +
These are the known formats I can dig up. The constant NUM_FMT_PERCENT is +
+These are the known formats I can dig up. The constant NUM_FMT_PERCENT is 9, and uses the default % formatting. Axlsx also defines a few formats for date and time that are commonly used in asia as NUM_FMT_YYYYMMDD and -NUM_FRM_YYYYMMDDHHMMSS.
- -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/yyyy -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/yyyy h:mm -37 #,##0_);(#,##0) -38 #,##0_);[Red](#,##0) -39 #,##0.00_);(#,##0.00) -40 #,##0.00_);[Red](#,##0.00) -45 mm:ss -46 [h]:mm:ss -47 mm:ss.0 -48 ##0.0E+0 -49 @+NUM_FRM_YYYYMMDDHHMMSS. + +
+ 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/yyyy + 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/yyyy h:mm + 37 #,##0_);(#,##0) + 38 #,##0_);[Red](#,##0) + 39 #,##0.00_);(#,##0.00) + 40 #,##0.00_);[Red](#,##0.00) + 45 mm:ss + 46 [h]:mm:ss + 47 mm:ss.0 + 48 ##0.0E+0 + 49 @ +
An unsinged integer referencing a standard or custom number format.
++An unsinged integer referencing a standard or custom number format. +
An unsinged integer referencing a standard or custom number format.
++An unsinged integer referencing a standard or custom number format. +
# File 'lib/axlsx/stylesheet/num_fmt.rb', line 40 -def numFmtId - @numFmtId -end+def numFmtId + @numFmtId +end +
Creates a numFmt element applying the instance values of this object as -attributes.
++Creates a numFmt element applying the instance values of this object as +attributes. +
The document builder instance this objects xml will be added to.
++The document builder instance this objects xml will be added to. +
# File 'lib/axlsx/stylesheet/num_fmt.rb', line 60 -def to_xml(xml) xml.numFmt(self.instance_values) end+def to_xml(xml) xml.numFmt(self.instance_values) end +