1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
# -*- coding: utf-8 -*-
require 'test/unit'
require 'axlsx.rb'
class TestDateTimeConverter < Test::Unit::TestCase
def setup
@converter = Axlsx::DateTimeConverter.new
@margin_of_error = 0.000_001
end
def test_date_to_serial_1900
Axlsx::Workbook.date1904 = false
tests = if RUBY_VERSION == '1.8.7'
{ # examples taken straight from the spec
"2006-02-01" => 38749.0,
"9999-12-31" => 2958465.0
}
else
{
"1893-08-05" => -2338.0, # ruby 1.8.7 cannot parse negative dates in some environments
"1900-01-01" => 2.0,
"1910-02-03" => 3687.0,
"2006-02-01" => 38749.0,
"9999-12-31" => 2958465.0
}
end
tests.each do |date_string, expected|
serial = @converter.date_to_serial Date.parse(date_string)
assert_equal serial, expected
end
end
def test_date_to_serial_1904
Axlsx::Workbook.date1904 = true
tests = if RUBY_VERSION == '1.8.7'
{ # examples taken straight from the spec
"2006-02-01" => 37287.0,
"9999-12-31" => 2957003.0
}
else
{
"1893-08-05" => -3800.0, # ruby 1.8.7 cannot parse negative dates in some environments
"1904-01-01" => 0.0,
"1910-02-03" => 2225.0,
"2006-02-01" => 37287.0,
"9999-12-31" => 2957003.0
}
end
tests.each do |date_string, expected|
serial = @converter.date_to_serial Date.parse(date_string)
assert_equal serial, expected
end
end
def test_time_to_serial_1900
Axlsx::Workbook.date1904 = false
tests = if RUBY_VERSION == '1.8.7'
{
#"9999-12-31T23:59:59Z" => 2958465.9999884
}
else
{
"1893-08-05T00:00:01Z" => -2337.999989,
"1899-12-28T18:00:00Z" => -1.25,
"1910-02-03T10:05:54Z" => 3687.4207639,
"1900-01-01T12:00:00Z" => 2.5, # wrongly indicated as 1.5 in the spec!
"9999-12-31T23:59:59Z" => 2958465.9999884
}
end
tests.each do |time_string, expected|
serial = @converter.time_to_serial Time.parse(time_string)
assert_in_delta serial, expected, @margin_of_error
end
end
def test_time_to_serial_1904
Axlsx::Workbook.date1904 = true
# ruby 1.8.7 cannot parse dates prior to epoc. see http://ruby-doc.org/core-1.8.7/Time.html
tests = if RUBY_VERSION == '1.8.7'
{ # examples taken straight from the spec
#"9999-12-31T23:59:59Z" => 2957003.9999884,
}
else
{ # examples taken straight from the spec
"1893-08-05T00:00:01Z" => -3799.999989,
"1910-02-03T10:05:54Z" => 2225.4207639,
"1904-01-01T12:00:00Z" => 0.5000000,
"9999-12-31T23:59:59Z" => 2957003.9999884
}
end
tests.each do |time_string, expected|
serial = @converter.time_to_serial Time.parse(time_string)
assert_in_delta serial, expected, @margin_of_error
end
end
def test_timezone
return if RUBY_VERSION == '1.8.7' # temporarily forcing this to only run on 1.9.2 and 1.9.3 as Time.new is quite different in 1.8.7
utc = Time.utc 2012 # January 1st, 2012 at 0:00 UTC
local = Time.new 2012, 1, 1, 1, 0, 0, 3600 # January 1st, 2012 at 1:00 GMT+1
assert_equal local, utc
assert_equal @converter.time_to_serial(local), @converter.time_to_serial(utc)
Axlsx::Workbook.date1904 = true
assert_equal @converter.time_to_serial(local), @converter.time_to_serial(utc)
end
end
|
