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}