spreadsheet
typeScript/javascript spreadsheet parser, with formulas.
git clone https://git.vogt.world/spreadsheet.git
Log | Files | README.md
← All files
name: tests/Formulas/ConvertTest.ts
-rw-r--r--
2176
 1import {
 2  TO_DATE,
 3  TO_DOLLARS,
 4  TO_PERCENT,
 5  TO_TEXT
 6} from "../../src/Formulas/Convert";
 7import * as ERRORS from "../../src/Errors";
 8import {
 9  assertEquals,
10  catchAndAssertEquals,
11  test
12} from "../Utils/Asserts";
13
14
15test("TO_DATE", function(){
16  assertEquals(TO_DATE(10), 10);
17  assertEquals(TO_DATE(false), false);
18  assertEquals(TO_DATE(true), true);
19  assertEquals(TO_DATE(-100), -100);
20  assertEquals(TO_DATE("June 10, 2010"), "June 10, 2010");
21  assertEquals(TO_DATE("str"), "str");
22  catchAndAssertEquals(function() {
23    TO_DATE.apply(this, [10, 10]);
24  }, ERRORS.NA_ERROR);
25  catchAndAssertEquals(function() {
26    TO_DATE.apply(this, [])
27  }, ERRORS.NA_ERROR);
28});
29
30test("TO_DOLLARS", function(){
31  assertEquals(TO_DOLLARS(10), 10);
32  assertEquals(TO_DOLLARS(false), false);
33  assertEquals(TO_DOLLARS(true), true);
34  assertEquals(TO_DOLLARS(-100), -100);
35  assertEquals(TO_DOLLARS("June 10, 2010"), "June 10, 2010");
36  assertEquals(TO_DOLLARS("str"), "str");
37  catchAndAssertEquals(function() {
38    TO_DOLLARS.apply(this, [10, 10]);
39  }, ERRORS.NA_ERROR);
40  catchAndAssertEquals(function() {
41    TO_DOLLARS.apply(this, [])
42  }, ERRORS.NA_ERROR);
43});
44
45test("TO_PERCENT", function(){
46  assertEquals(TO_PERCENT(10), 10);
47  assertEquals(TO_PERCENT(false), false);
48  assertEquals(TO_PERCENT(true), true);
49  assertEquals(TO_PERCENT(-100), -100);
50  assertEquals(TO_PERCENT("June 10, 2010"), "June 10, 2010");
51  assertEquals(TO_PERCENT("str"), "str");
52  catchAndAssertEquals(function() {
53    TO_PERCENT.apply(this, [10, 10]);
54  }, ERRORS.NA_ERROR);
55  catchAndAssertEquals(function() {
56    TO_PERCENT.apply(this, [])
57  }, ERRORS.NA_ERROR);
58});
59
60test("TO_TEXT", function(){
61  assertEquals(TO_TEXT(10), "10");
62  assertEquals(TO_TEXT(10.23984728937), "10.23984728937");
63  assertEquals(TO_TEXT(false), "FALSE");
64  assertEquals(TO_TEXT(true), "TRUE");
65  assertEquals(TO_TEXT(-100), "-100");
66  assertEquals(TO_TEXT("June 10, 2010"), "June 10, 2010");
67  assertEquals(TO_TEXT("str"), "str");
68  catchAndAssertEquals(function() {
69    TO_TEXT.apply(this, [10, 10]);
70  }, ERRORS.NA_ERROR);
71  catchAndAssertEquals(function() {
72    TO_TEXT.apply(this, [])
73  }, ERRORS.NA_ERROR);
74});