1import { describe, it, runner } from "../testutils/TestUtils";
 2
 3describe("Executor.execute - Unary Plus", function () {
 4  it("should work with number", function () {
 5    runner().addCell("Alpha", "A1", "= +0").addExpectedValue("Alpha", "A1", 0.0).run();
 6    runner().addCell("Alpha", "A1", "= +1").addExpectedValue("Alpha", "A1", 1.0).run();
 7    runner().addCell("Alpha", "A1", "= +2792").addExpectedValue("Alpha", "A1", 2792.0).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    runner()
18      .addCell("Alpha", "A1", "= +-10.167531")
19      .addExpectedValue("Alpha", "A1", -10.167531)
20      .run();
21  });
22
23  it("should work with string", function () {
24    runner().addCell("Alpha", "A1", '= +"0"').addExpectedValue("Alpha", "A1", 0.0).run();
25    runner().addCell("Alpha", "A1", '= +"1"').addExpectedValue("Alpha", "A1", 1.0).run();
26    runner().addCell("Alpha", "A1", '= +"2792"').addExpectedValue("Alpha", "A1", 2792.0).run();
27    runner().addCell("Alpha", "A1", '= +"1.32e10"').addExpectedValue("Alpha", "A1", 1.32e10).run();
28    runner()
29      .addCell("Alpha", "A1", '= +"0.2318937"')
30      .addExpectedValue("Alpha", "A1", 0.2318937)
31      .run();
32    runner()
33      .addCell("Alpha", "A1", '= +"10.167531"')
34      .addExpectedValue("Alpha", "A1", 10.167531)
35      .run();
36  });
37
38  it("should work with boolean", function () {
39    runner().addCell("Alpha", "A1", "= +TRUE").addExpectedValue("Alpha", "A1", 1.0).run();
40    runner().addCell("Alpha", "A1", "= +FALSE").addExpectedValue("Alpha", "A1", 0.0).run();
41  });
42
43  it("should work with array literal", function () {
44    runner().addCell("Alpha", "A1", "= +{1, 2, 3}").addExpectedValue("Alpha", "A1", 1.0).run();
45    runner().addCell("Alpha", "A1", "= +{1, #REF!}").addExpectedValue("Alpha", "A1", 1.0).run();
46  });
47
48  it("should work with multiple symbols", function () {
49    runner().addCell("Alpha", "A1", "= +1").addExpectedValue("Alpha", "A1", 1.0).run();
50    runner().addCell("Alpha", "A1", "= +++1").addExpectedValue("Alpha", "A1", 1.0).run();
51    runner().addCell("Alpha", "A1", "= ++++1").addExpectedValue("Alpha", "A1", 1.0).run();
52  });
53
54  it("should work with unary minus", function () {
55    runner().addCell("Alpha", "A1", "= +-1").addExpectedValue("Alpha", "A1", -1.0).run();
56    runner().addCell("Alpha", "A1", "= +-+1").addExpectedValue("Alpha", "A1", -1.0).run();
57    runner().addCell("Alpha", "A1", "= +---+-----+-+1").addExpectedValue("Alpha", "A1", -1.0).run();
58    runner().addCell("Alpha", "A1", "= +---+----+-+1").addExpectedValue("Alpha", "A1", 1.0).run();
59    runner().addCell("Alpha", "A1", "= +---+---+-+1").addExpectedValue("Alpha", "A1", -1.0).run();
60    runner().addCell("Alpha", "A1", "= +---+--+-+1").addExpectedValue("Alpha", "A1", 1.0).run();
61  });
62});