From 8280a21a23d44aa90177e2bc041d0b8dc8556f4b Mon Sep 17 00:00:00 2001 From: Unit 193 Date: Mon, 12 Jun 2017 03:37:11 -0400 Subject: Import Upstream version 2.7.1 --- test/excelx/cell/test_date.rb | 38 ++++++++++++++++++++++++++++++++++++++ 1 file changed, 38 insertions(+) create mode 100644 test/excelx/cell/test_date.rb (limited to 'test/excelx/cell/test_date.rb') diff --git a/test/excelx/cell/test_date.rb b/test/excelx/cell/test_date.rb new file mode 100644 index 0000000..7bd046b --- /dev/null +++ b/test/excelx/cell/test_date.rb @@ -0,0 +1,38 @@ +require 'test_helper' + +class TestRooExcelxCellDate < Minitest::Test + def date_cell + Roo::Excelx::Cell::Date + end + + def base_date + ::Date.new(1899, 12, 30) + end + + def base_date_1904 + ::Date.new(1904, 01, 01) + end + + def test_handles_1904_base_date + cell = date_cell.new('41791', nil, [:numeric_or_formula, 'mm-dd-yy'], 6, nil, base_date_1904, nil) + assert_equal ::Date.new(2018, 06, 02), cell.value + end + + def test_formatted_value + cell = date_cell.new('41791', nil, [:numeric_or_formula, 'mm-dd-yy'], 6, nil, base_date, nil) + assert_equal '06-01-14', cell.formatted_value + + cell = date_cell.new('41791', nil, [:numeric_or_formula, 'yyyy-mm-dd'], 6, nil, base_date, nil) + assert_equal '2014-06-01', cell.formatted_value + end + + def test_value_is_date + cell = date_cell.new('41791', nil, [:numeric_or_formula, 'mm-dd-yy'], 6, nil, base_date, nil) + assert_kind_of ::Date, cell.value + end + + def test_value + cell = date_cell.new('41791', nil, [:numeric_or_formula, 'mm-dd-yy'], 6, nil, base_date, nil) + assert_equal ::Date.new(2014, 06, 01), cell.value + end +end -- cgit v1.2.3