1package io.protobase.f7.spreadsheet;
 2
 3import io.protobase.f7.testutils.TestExecution;
 4import org.junit.Test;
 5
 6public class GeneralUnaryMinusTest 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  }
16
17  @Test
18  public void test_String() {
19    runner().addCell("Alpha", "A1", "= -\"0\"").addExpectedValue("Alpha", "A1", 0.0).run();
20    runner().addCell("Alpha", "A1", "= -\"1\"").addExpectedValue("Alpha", "A1", -1.0).run();
21    runner().addCell("Alpha", "A1", "= -\"2792\"").addExpectedValue("Alpha", "A1", -2792.0).run();
22    runner().addCell("Alpha", "A1", "= -\"1.32e10\"").addExpectedValue("Alpha", "A1", -1.32e10).run();
23    runner().addCell("Alpha", "A1", "= -\"0.2318937\"").addExpectedValue("Alpha", "A1", -0.2318937).run();
24    runner().addCell("Alpha", "A1", "= -\"10.167531\"").addExpectedValue("Alpha", "A1", -10.167531).run();
25  }
26
27  @Test
28  public void test_Boolean() {
29    runner().addCell("Alpha", "A1", "= -TRUE").addExpectedValue("Alpha", "A1", -1.0).run();
30    runner().addCell("Alpha", "A1", "= -FALSE").addExpectedValue("Alpha", "A1", 0.0).run();
31  }
32
33  @Test
34  public void test_ArrayLiteral() {
35    runner().addCell("Alpha", "A1", "= -{1, 2, 3}").addExpectedValue("Alpha", "A1", -1.0).run();
36    runner().addCell("Alpha", "A1", "= -{1, #REF!}").addExpectedValue("Alpha", "A1", -1.0).run();
37  }
38
39  @Test
40  public void test_MultipleUnaryMinus() {
41    runner().addCell("Alpha", "A1", "= --1").addExpectedValue("Alpha", "A1", 1.0).run();
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  }
45}