Sha256: eb2c2c9e902c21dc34bdec1ac20a70c00d62db31660ceb7b65ffe63e6dd25879
Contents?: true
Size: 861 Bytes
Versions: 2
Compression:
Stored size: 861 Bytes
Contents
require 'test_helper' class TestRooExcelxCellTime < Minitest::Test def roo_time Roo::Excelx::Cell::Time end def base_date Date.new(1899, 12, 30) end def test_formatted_value value = '0.0751' # 6488.64 seconds, or 1:48:08.64 [ ['h:mm', '1:48'], ['h:mm:ss', '1:48:09'], ['mm:ss', '48:09'], ['[h]:mm:ss', '[1]:48:09'], ['mmss.0', '4809.0'] # Cell::Time always get rounded to the nearest second. ].each do |style_format, result| cell = roo_time.new(value, nil, [:numeric_or_formula, style_format], 6, nil, base_date, nil) assert_equal result, cell.formatted_value, "Style=#{style_format} is not properly formatted" end end def test_value cell = roo_time.new('0.0751', nil, [:numeric_or_formula, 'h:mm'], 6, nil, base_date, nil) assert_kind_of Integer, cell.value end end
Version data entries
2 entries across 2 versions & 1 rubygems
Version | Path |
---|---|
roo-2.7.1 | test/excelx/cell/test_time.rb |
roo-2.7.0 | test/excelx/cell/test_time.rb |