Class: OpenXml::Xlsx::Elements::NumberFormat

Inherits:
Struct
  • Object
show all
Defined in:
lib/openxml/xlsx/elements/number_format.rb

Constant Summary collapse

INTEGER =

0

ImpliedNumberFormat.new(1).freeze
DECIMAL =

0.00

ImpliedNumberFormat.new(2).freeze
INTEGER_THOUSANDS =

#,##0

ImpliedNumberFormat.new(3).freeze
DECIMAL_THOUSANDS =

#,##0.00

ImpliedNumberFormat.new(4).freeze
INTEGER_PERCENT =

0%

ImpliedNumberFormat.new(9).freeze
DECIMAL_PERCENT =

0.00%

ImpliedNumberFormat.new(10).freeze
SCIENTIFIC =

0.00E+00

ImpliedNumberFormat.new(11).freeze
FRACTION =

?/?

ImpliedNumberFormat.new(12).freeze
FRACTION2 =

??/??

ImpliedNumberFormat.new(13).freeze
DATE =

mm-dd-yy

ImpliedNumberFormat.new(14).freeze
DATE_ALT =

d-mmm-yy

ImpliedNumberFormat.new(15).freeze
DAY_MONTH =

d-mmm

ImpliedNumberFormat.new(16).freeze
MONTH_YEAR =

mmm-yy

ImpliedNumberFormat.new(17).freeze
TIME =

h:mm AM/PM

ImpliedNumberFormat.new(18).freeze
TIME_SECONDS =

h:mm:ss AM/PM

ImpliedNumberFormat.new(19).freeze
TIME_ALT =

h:mm

ImpliedNumberFormat.new(20).freeze
TIME_SECONDS_ALT =

h:mm:ss

ImpliedNumberFormat.new(21).freeze
DATETIME =

m/d/yy h:mm

ImpliedNumberFormat.new(22).freeze
FINANCIAL_INTEGER =

#,##0 ;(#,##0)

ImpliedNumberFormat.new(37).freeze
FINANCIAL_INTEGER_RED =

#,##0 ;[Red](#,##0)

ImpliedNumberFormat.new(38).freeze
FINANCIAL_DECIMAL =

#,##0.00 ;(#,##0.00)

ImpliedNumberFormat.new(39).freeze
FINANCIAL_DECIMAL_RED =

#,##0.00 ;[Red](#,##0.00)

ImpliedNumberFormat.new(40).freeze
INTERVAL =

mm:ss

ImpliedNumberFormat.new(45).freeze
INTERVAL_HOURS =

[h]:mm:ss

ImpliedNumberFormat.new(46).freeze
TIMESTAMP =

mmss.0

ImpliedNumberFormat.new(47).freeze

Instance Attribute Summary collapse

Instance Method Summary collapse

Instance Attribute Details

#format ⇒ Object

Returns the value of attribute format

Returns:

  • (Object) —

    the current value of format



6
7
8
 
# File 'lib/openxml/xlsx/elements/number_format.rb', line 6

def format
  @format
end

Instance Method Details

#to_xml(id, xml) ⇒ Object 



40
41
42
 
# File 'lib/openxml/xlsx/elements/number_format.rb', line 40

def to_xml(id, xml)
  xml.numFmt(numFmtId: id, formatCode: format)
end