Sha256: 67a974a214a0033c375b54c04f30c0e1f9c5ad78e198dd416a1ef1517e301f5b

Contents?: true

Size: 1.47 KB

Versions: 25

Compression:

Stored size: 1.47 KB

Contents

require 'spec_helper'

describe Roo::Excelx::Format do
  describe '#to_type' do
    FORMATS = {
      'General' => :float,
      '0' => :float,
      '0.00' => :float,
      '#,##0' => :float,
      '#,##0.00' => :float,
      '0%' => :percentage,
      '0.00%' => :percentage,
      '0.00E+00' => :float,
      '# ?/?' => :float, # ??? TODO:
      '# ??/??' => :float, # ??? TODO:
      'mm-dd-yy' => :date,
      'd-mmm-yy' => :date,
      'd-mmm' => :date,
      'mmm-yy' => :date,
      'h:mm AM/PM' => :date,
      'h:mm:ss AM/PM' => :date,
      'h:mm' => :time,
      'h:mm:ss' => :time,
      'm/d/yy h:mm' => :datetime,
      '#,##0 ;(#,##0)' => :float,
      '#,##0 ;[Red](#,##0)' => :float,
      '#,##0.00;(#,##0.00)' => :float,
      '#,##0.00;[Red](#,##0.00)' => :float,
      '#,##0_);[Red](#,##0)' => :float,
      'mm:ss' => :time,
      '[h]:mm:ss' => :time,
      'mmss.0' => :time,
      '##0.0E+0' => :float,
      '@' => :float,
      #-- zusaetzliche Formate, die nicht standardmaessig definiert sind:
      'yyyy\\-mm\\-dd' => :date,
      'dd/mm/yy' => :date,
      'hh:mm:ss' => :time,
      'dd/mm/yy\\ hh:mm' => :datetime,
      'dd/mmm/yy\\ hh:mm' => :datetime,
      'dd/mmm/yy' => :date, # 2011-05-21
      'yyyy-mm-dd' => :date, # 2011-09-16
      'yyyy-mm-dd;@' => :date,
      '#0_);[Red]\(0\)' => :float
    }.each do |format, type|
      it "translates #{format} to #{type}" do
        expect(Roo::Excelx::Format.to_type(format)).to eq(type)
      end
    end
  end
end

Version data entries

25 entries across 25 versions & 3 rubygems

Version Path
roo-2.10.1 spec/lib/roo/excelx/format_spec.rb
roo-2.10.0 spec/lib/roo/excelx/format_spec.rb
roo-2.9.0 spec/lib/roo/excelx/format_spec.rb
roo-2.8.3 spec/lib/roo/excelx/format_spec.rb
roo-2.8.2 spec/lib/roo/excelx/format_spec.rb
roo-2.8.1 spec/lib/roo/excelx/format_spec.rb
roo-2.8.0 spec/lib/roo/excelx/format_spec.rb
roo-2.7.1 spec/lib/roo/excelx/format_spec.rb
roo-2.7.0 spec/lib/roo/excelx/format_spec.rb
roo-2.6.0 spec/lib/roo/excelx/format_spec.rb
roo-2.5.1 spec/lib/roo/excelx/format_spec.rb
roo-2.5.0 spec/lib/roo/excelx/format_spec.rb
roo-2.4.0 spec/lib/roo/excelx/format_spec.rb
roo-2.3.2 spec/lib/roo/excelx/format_spec.rb
roo-2.3.1 spec/lib/roo/excelx/format_spec.rb
roo-2.3.0 spec/lib/roo/excelx/format_spec.rb
roo-2.2.0 spec/lib/roo/excelx/format_spec.rb
roo-2.1.1 spec/lib/roo/excelx/format_spec.rb
roo-2.1.0 spec/lib/roo/excelx/format_spec.rb
roo-2.0.1 spec/lib/roo/excelx/format_spec.rb