diff options
| author | Randy Morgan <[email protected]> | 2013-09-12 23:16:19 +0900 |
|---|---|---|
| committer | Randy Morgan <[email protected]> | 2013-09-13 00:08:40 +0900 |
| commit | 8cdeac65f6acfa4f63fe03f3060d77e7b7520375 (patch) | |
| tree | a34ae7731e0c0044548934351c66bd5d6f4d1ea2 /test/workbook/worksheet/tc_date_time_converter.rb | |
| parent | aa80ebdc084d8c938a435d5ef172a821652cedb3 (diff) | |
| download | caxlsx-8cdeac65f6acfa4f63fe03f3060d77e7b7520375.tar.gz caxlsx-8cdeac65f6acfa4f63fe03f3060d77e7b7520375.zip | |
Add support for automatically adjusting serialized times and dates to account for the zone
Diffstat (limited to 'test/workbook/worksheet/tc_date_time_converter.rb')
| -rw-r--r-- | test/workbook/worksheet/tc_date_time_converter.rb | 14 |
1 files changed, 3 insertions, 11 deletions
diff --git a/test/workbook/worksheet/tc_date_time_converter.rb b/test/workbook/worksheet/tc_date_time_converter.rb index 09c1c507..1bdee04b 100644 --- a/test/workbook/worksheet/tc_date_time_converter.rb +++ b/test/workbook/worksheet/tc_date_time_converter.rb @@ -113,20 +113,12 @@ class TestDateTimeConverter < Test::Unit::TestCase def test_timezone utc = Time.utc 2012 # January 1st, 2012 at 0:00 UTC - - # JRuby makes no assumption on time zone. randym - #local = begin - # Time.new 2012, 1, 1, 1, 0, 0, 3600 # January 1st, 2012 at 1:00 GMT+1 - #rescue ArgumentError - # Time.parse "2012-01-01 01:00:00 +0100" - #end - - local = Time.parse "2012-01-01 01:00:00 +0100" + local = Time.parse "2012-01-01 09:00:00 +0900" assert_equal local, utc - assert_equal Axlsx::DateTimeConverter::time_to_serial(local), Axlsx::DateTimeConverter::time_to_serial(utc) + assert_equal Axlsx::DateTimeConverter::time_to_serial(local) - local.utc_offset.to_f/86400, Axlsx::DateTimeConverter::time_to_serial(utc) Axlsx::Workbook.date1904 = true - assert_equal Axlsx::DateTimeConverter::time_to_serial(local), Axlsx::DateTimeConverter::time_to_serial(utc) + assert_equal Axlsx::DateTimeConverter::time_to_serial(local) - local.utc_offset.to_f/86400, Axlsx::DateTimeConverter::time_to_serial(utc) end end |