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
|
package xlsx
import (
. "gopkg.in/check.v1"
"time"
)
type DateSuite struct{}
var _ = Suite(&DateSuite{})
func (d *DateSuite) TestFractionOfADay(c *C) {
var h, m, s, n int
h, m, s, n = fractionOfADay(0)
c.Assert(h, Equals, 0)
c.Assert(m, Equals, 0)
c.Assert(s, Equals, 0)
c.Assert(n, Equals, 0)
h, m, s, n = fractionOfADay(1.0 / 24.0)
c.Assert(h, Equals, 1)
c.Assert(m, Equals, 0)
c.Assert(s, Equals, 0)
c.Assert(n, Equals, 0)
}
func (d *DateSuite) TestJulianDateToGregorianTime(c *C) {
c.Assert(julianDateToGregorianTime(2400000.5, 51544.0),
Equals, time.Date(2000, 1, 1, 0, 0, 0, 0, time.UTC))
c.Assert(julianDateToGregorianTime(2400000.5, 51544.5),
Equals, time.Date(2000, 1, 1, 12, 0, 0, 0, time.UTC))
c.Assert(julianDateToGregorianTime(2400000.5, 51544.245),
Equals, time.Date(2000, 1, 1, 5, 52, 48, 0, time.UTC))
c.Assert(julianDateToGregorianTime(2400000.5, 51544.2456),
Equals, time.Date(2000, 1, 1, 5, 53, 39, 840000000, time.UTC))
/* test rounding: 0.24560789123*24*3600 = 21220.521802272 */
c.Assert(julianDateToGregorianTime(2400000.5, 51544.24560789123),
Equals, time.Date(2000, 1, 1, 5, 53, 40, 521802000, time.UTC))
c.Assert(julianDateToGregorianTime(2400000.5, 51544.1),
Equals, time.Date(2000, 1, 1, 2, 24, 00, 0, time.UTC))
c.Assert(julianDateToGregorianTime(2400000.5, 51544.75),
Equals, time.Date(2000, 1, 1, 18, 0, 0, 0, time.UTC))
}
func (d *DateSuite) TestTimeFromExcelTime(c *C) {
date := TimeFromExcelTime(0, false)
c.Assert(date, Equals, time.Date(1899, 12, 30, 0, 0, 0, 0, time.UTC))
date = TimeFromExcelTime(60, false)
c.Assert(date, Equals, time.Date(1900, 2, 28, 0, 0, 0, 0, time.UTC))
date = TimeFromExcelTime(61, false)
c.Assert(date, Equals, time.Date(1900, 3, 1, 0, 0, 0, 0, time.UTC))
date = TimeFromExcelTime(41275.0, false)
c.Assert(date, Equals, time.Date(2013, 1, 1, 0, 0, 0, 0, time.UTC))
date = TimeFromExcelTime(401769, false)
c.Assert(date, Equals, time.Date(3000, 1, 1, 0, 0, 0, 0, time.UTC))
}
func (d *DateSuite) TestTimeFromExcelTimeWithFractionalPart(c *C) {
date := TimeFromExcelTime(0.114583333333333, false)
c.Assert(date.Round(time.Second), Equals, time.Date(1899, 12, 30, 2, 45, 0, 0, time.UTC))
date = TimeFromExcelTime(60.1145833333333, false)
c.Assert(date.Round(time.Second), Equals, time.Date(1900, 2, 28, 2, 45, 0, 0, time.UTC))
date = TimeFromExcelTime(61.3986111111111, false)
c.Assert(date.Round(time.Second), Equals, time.Date(1900, 3, 1, 9, 34, 0, 0, time.UTC))
date = TimeFromExcelTime(37947.75, false)
c.Assert(date.Round(time.Second), Equals, time.Date(2003, 11, 22, 18, 0, 0, 0, time.UTC))
date = TimeFromExcelTime(41275.1145833333, false)
c.Assert(date.Round(time.Second), Equals, time.Date(2013, 1, 1, 2, 45, 0, 0, time.UTC))
}
func (d *DateSuite) TestTimeFromExcelTimeWith1904Offest(c *C) {
date1904Offset := TimeFromExcelTime(39813.0, true)
c.Assert(date1904Offset, Equals, time.Date(2013, 1, 1, 0, 0, 0, 0, time.UTC))
}
|
