Class: Axlsx::NumFmt

Inherits:

Object

• Object
• Axlsx::NumFmt

show all

Defined in:

lib/axlsx/stylesheet/num_fmt.rb

Overview

Instance Attribute Summary (collapse)

• - (String) formatCode

  The formatting to use for this number format.

• - (Integer) numFmtId

  An unsinged integer referencing a standard or custom number format.

Instance Method Summary (collapse)

• - (NumFmt) initialize(options = {}) constructor

  A new instance of NumFmt.

• - (Object) to_xml(xml)

  Creates a numFmt element applying the instance values of this object as attributes.

45
46
47
48
49
50
51

# File 'lib/axlsx/stylesheet/num_fmt.rb', line 45

def initialize(options={})
  @numFmtId = 0
  @formatCode = ""
  options.each do |o|
    self.send("#{o[0]}=", o[1]) if self.respond_to? o[0]
  end
end

44
45
46

# File 'lib/axlsx/stylesheet/num_fmt.rb', line 44

def formatCode
  @formatCode
end

 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 @

40
41
42

# File 'lib/axlsx/stylesheet/num_fmt.rb', line 40

def numFmtId
  @numFmtId
end

58

# File 'lib/axlsx/stylesheet/num_fmt.rb', line 58

def to_xml(xml) xml.numFmt(self.instance_values) end