f7
f7 is a spreadsheet formula execution library
git clone https://git.vogt.world/f7.git
Log | Files | README.md | LICENSE.md
← All files
name: src/test/java/io/protobase/f7/spreadsheet/GeneralUnaryPlusTest.java
-rw-r--r--
2954
 1package io.protobase.f7.spreadsheet;
 2
 3import io.protobase.f7.testutils.TestExecution;
 4import org.junit.Test;
 5
 6public class GeneralUnaryPlusTest extends TestExecution {
 7  @Test
 8  public void test_Number() {
 9    runner().addCell("Alpha", "A1", "= +0").addExpectedValue("Alpha", "A1", 0.0).run();
10    runner().addCell("Alpha", "A1", "= +1").addExpectedValue("Alpha", "A1", 1.0).run();
11    runner().addCell("Alpha", "A1", "= +2792").addExpectedValue("Alpha", "A1", 2792.0).run();
12    runner().addCell("Alpha", "A1", "= +1.32e10").addExpectedValue("Alpha", "A1", 1.32e10).run();
13    runner().addCell("Alpha", "A1", "= +0.2318937").addExpectedValue("Alpha", "A1", 0.2318937).run();
14    runner().addCell("Alpha", "A1", "= +10.167531").addExpectedValue("Alpha", "A1", 10.167531).run();
15    runner().addCell("Alpha", "A1", "= +-10.167531").addExpectedValue("Alpha", "A1", -10.167531).run();
16  }
17
18  @Test
19  public void test_String() {
20    runner().addCell("Alpha", "A1", "= +\"0\"").addExpectedValue("Alpha", "A1", 0.0).run();
21    runner().addCell("Alpha", "A1", "= +\"1\"").addExpectedValue("Alpha", "A1", 1.0).run();
22    runner().addCell("Alpha", "A1", "= +\"2792\"").addExpectedValue("Alpha", "A1", 2792.0).run();
23    runner().addCell("Alpha", "A1", "= +\"1.32e10\"").addExpectedValue("Alpha", "A1", 1.32e10).run();
24    runner().addCell("Alpha", "A1", "= +\"0.2318937\"").addExpectedValue("Alpha", "A1", 0.2318937).run();
25    runner().addCell("Alpha", "A1", "= +\"10.167531\"").addExpectedValue("Alpha", "A1", 10.167531).run();
26  }
27
28  @Test
29  public void test_Boolean() {
30    runner().addCell("Alpha", "A1", "= +TRUE").addExpectedValue("Alpha", "A1", 1.0).run();
31    runner().addCell("Alpha", "A1", "= +FALSE").addExpectedValue("Alpha", "A1", 0.0).run();
32  }
33
34  @Test
35  public void test_ArrayLiteral() {
36    runner().addCell("Alpha", "A1", "= +{1, 2, 3}").addExpectedValue("Alpha", "A1", 1.0).run();
37    runner().addCell("Alpha", "A1", "= +{1, #REF!}").addExpectedValue("Alpha", "A1", 1.0).run();
38  }
39
40  @Test
41  public void test_MultipleUnaryPlus() {
42    runner().addCell("Alpha", "A1", "= +1").addExpectedValue("Alpha", "A1", 1.0).run();
43    runner().addCell("Alpha", "A1", "= +++1").addExpectedValue("Alpha", "A1", 1.0).run();
44    runner().addCell("Alpha", "A1", "= ++++1").addExpectedValue("Alpha", "A1", 1.0).run();
45  }
46
47  @Test
48  public void test_UnaryPlusAndUnaryMinus() {
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    runner().addCell("Alpha", "A1", "= +---+----+-+1").addExpectedValue("Alpha", "A1", 1.0).run();
53    runner().addCell("Alpha", "A1", "= +---+---+-+1").addExpectedValue("Alpha", "A1", -1.0).run();
54    runner().addCell("Alpha", "A1", "= +---+--+-+1").addExpectedValue("Alpha", "A1", 1.0).run();
55  }
56}