1import { describe, it, runner } from "../testutils/TestUtils";
 2
 3describe("Executor.execute - Unary Minus", function () {
 4  it("should work with number", function () {
 5    runner().addCell("Alpha", "A1", "= -0").addExpectedValue("Alpha", "A1", 0).run();
 6    runner().addCell("Alpha", "A1", "= -1").addExpectedValue("Alpha", "A1", -1).run();
 7    runner().addCell("Alpha", "A1", "= -2792").addExpectedValue("Alpha", "A1", -2792).run();
 8    runner().addCell("Alpha", "A1", "= -1.32e10").addExpectedValue("Alpha", "A1", -1.32e10).run();
 9    runner()
10      .addCell("Alpha", "A1", "= -0.2318937")
11      .addExpectedValue("Alpha", "A1", -0.2318937)
12      .run();
13    runner()
14      .addCell("Alpha", "A1", "= -10.167531")
15      .addExpectedValue("Alpha", "A1", -10.167531)
16      .run();
17  });
18
19  it("should work with string", function () {
20    runner().addCell("Alpha", "A1", '= -"0"').addExpectedValue("Alpha", "A1", 0).run();
21    runner().addCell("Alpha", "A1", '= -"1"').addExpectedValue("Alpha", "A1", -1).run();
22    runner().addCell("Alpha", "A1", '= -"2792"').addExpectedValue("Alpha", "A1", -2792).run();
23    runner().addCell("Alpha", "A1", '= -"1.32e10"').addExpectedValue("Alpha", "A1", -1.32e10).run();
24    runner()
25      .addCell("Alpha", "A1", '= -"0.2318937"')
26      .addExpectedValue("Alpha", "A1", -0.2318937)
27      .run();
28    runner()
29      .addCell("Alpha", "A1", '= -"10.167531"')
30      .addExpectedValue("Alpha", "A1", -10.167531)
31      .run();
32  });
33
34  it("should work with boolean", function () {
35    runner().addCell("Alpha", "A1", "= -TRUE").addExpectedValue("Alpha", "A1", -1).run();
36    runner().addCell("Alpha", "A1", "= -FALSE").addExpectedValue("Alpha", "A1", 0).run();
37  });
38
39  it("should work with array literal", function () {
40    runner().addCell("Alpha", "A1", "= -{1, 2, 3}").addExpectedValue("Alpha", "A1", -1).run();
41    runner().addCell("Alpha", "A1", "= -{1, #REF!}").addExpectedValue("Alpha", "A1", -1).run();
42  });
43
44  it("should work witih multiple minus symbols", function () {
45    runner().addCell("Alpha", "A1", "= --1").addExpectedValue("Alpha", "A1", 1).run();
46    runner().addCell("Alpha", "A1", "= ---1").addExpectedValue("Alpha", "A1", -1).run();
47    runner().addCell("Alpha", "A1", "= ----1").addExpectedValue("Alpha", "A1", 1).run();
48  });
49});