-
Notifications
You must be signed in to change notification settings - Fork 106
/
date-arithmetic.spec.ts
102 lines (89 loc) · 3.71 KB
/
date-arithmetic.spec.ts
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
import {HyperFormula} from '../../src'
import '../testConfig'
import {adr} from '../testUtils'
describe('Date arithmetic', () => {
it('subtract two dates', () => {
const engine = HyperFormula.buildFromArray([
['02/02/2020', '02/06/2019', '=A1-B1'],
])
expect(engine.getCellValue(adr('C1'))).toBe(361)
})
it('compare two dates', () => {
const engine = HyperFormula.buildFromArray([
['02/02/2020', '02/06/2019', '=A1>B1', '=A1<B1', '=A1>=B1', '=A1<=B1'],
])
expect(engine.getCellValue(adr('C1'))).toBe(true)
expect(engine.getCellValue(adr('D1'))).toBe(false)
expect(engine.getCellValue(adr('E1'))).toBe(true)
expect(engine.getCellValue(adr('F1'))).toBe(false)
})
it('compare two datestrings', () => {
const engine = HyperFormula.buildFromArray([
['="02/02/2020"', '="02/06/2019"', '=A1>B1', '=A1<B1', '=A1>=B1', '=A1<=B1'],
])
expect(engine.getCellValue(adr('C1'))).toBe(true)
expect(engine.getCellValue(adr('D1'))).toBe(false)
expect(engine.getCellValue(adr('E1'))).toBe(true)
expect(engine.getCellValue(adr('F1'))).toBe(false)
})
it('compare date with datestring, different dates', () => {
const engine = HyperFormula.buildFromArray([
['="02/02/2020"', '02/06/2019', '=A1>B1', '=A1<B1', '=A1>=B1', '=A1<=B1', '=A1=B1', '=A1<>B1'],
])
expect(engine.getCellValue(adr('C1'))).toBe(true)
expect(engine.getCellValue(adr('D1'))).toBe(false)
expect(engine.getCellValue(adr('E1'))).toBe(true)
expect(engine.getCellValue(adr('F1'))).toBe(false)
expect(engine.getCellValue(adr('G1'))).toBe(false)
expect(engine.getCellValue(adr('H1'))).toBe(true)
})
it('compare date with datestring, the same dates', () => {
const engine = HyperFormula.buildFromArray([
['="02/02/2020"', '02/02/2020', '=A1>B1', '=A1<B1', '=A1>=B1', '=A1<=B1', '=A1=B1', '=A1<>B1'],
])
expect(engine.getCellValue(adr('C1'))).toBe(false)
expect(engine.getCellValue(adr('D1'))).toBe(false)
expect(engine.getCellValue(adr('E1'))).toBe(true)
expect(engine.getCellValue(adr('F1'))).toBe(true)
expect(engine.getCellValue(adr('G1'))).toBe(true)
expect(engine.getCellValue(adr('H1'))).toBe(false)
})
it('compare date with bool', () => {
const engine = HyperFormula.buildFromArray([
['="02/02/2020"', '=TRUE()', '=A1>B1', '=A1<B1', '=A1>=B1', '=A1<=B1'],
])
expect(engine.getCellValue(adr('C1'))).toBe(false)
expect(engine.getCellValue(adr('D1'))).toBe(true)
expect(engine.getCellValue(adr('E1'))).toBe(false)
expect(engine.getCellValue(adr('F1'))).toBe(true)
})
it('compare date with number', () => {
const engine = HyperFormula.buildFromArray([
['02/02/2020', '2', '=A1>B1', '=A1<B1', '=A1>=B1', '=A1<=B1'],
])
expect(engine.getCellValue(adr('C1'))).toBe(true)
expect(engine.getCellValue(adr('D1'))).toBe(false)
expect(engine.getCellValue(adr('E1'))).toBe(true)
expect(engine.getCellValue(adr('F1'))).toBe(false)
})
it('sum date with number', () => {
const engine = HyperFormula.buildFromArray([
['02/02/2020', '2', '=A1+B1'],
])
expect(engine.getCellValue(adr('C1'))).toBe(43865)
})
it('sum date with boolean', () => {
const engine = HyperFormula.buildFromArray([
['02/02/2020', '=TRUE()', '=A1+B1'],
])
expect(engine.getCellValue(adr('C1'))).toBe(43864)
})
it('functions on dates', () => {
const engine = HyperFormula.buildFromArray([
['=ISEVEN("02/02/2020")', '=COS("02/02/2020")', '=BITOR("02/02/2020","08/16/1985")'],
], { smartRounding : false})
expect(engine.getCellValue(adr('A1'))).toBe(false)
expect(engine.getCellValue(adr('B1'))).toBe(0.9965266857693633)
expect(engine.getCellValue(adr('C1'))).toBe(64383)
})
})