Sha256: 44dc5c586f889d8072d7fd47fddb129499d852eac7b763d0d4a52a7c111a61ba
Contents?: true
Size: 893 Bytes
Versions: 7
Compression:
Stored size: 893 Bytes
Contents
require 'test_helper'
class TestRooExcelxCellTime < Minitest::Test
def roo_time
Roo::Excelx::Cell::Time
end
def base_timestamp
DateTime.new(1899, 12, 30).to_time.to_i
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_timestamp, 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_timestamp, nil)
assert_kind_of Integer, cell.value
end
end
Version data entries
7 entries across 7 versions & 1 rubygems