1package io.protobase.f7.spreadsheet;
 2
 3import io.protobase.f7.testutils.TestExecution;
 4import org.junit.Test;
 5
 6public class GeneralNumberTest extends TestExecution {
 7  @Test
 8  public void test_Integer() {
 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", "= 2738281").addExpectedValue("Alpha", "A1", 2738281.0).run();
12    runner().addCell("Alpha", "A1", "= 0001776").addExpectedValue("Alpha", "A1", 1776.0).run();
13  }
14
15  @Test
16  public void test_Decimal() {
17    runner().addCell("Alpha", "A1", "= 0.0").addExpectedValue("Alpha", "A1", 0.0).run();
18    runner().addCell("Alpha", "A1", "= 0.187328").addExpectedValue("Alpha", "A1", 0.187328).run();
19    runner().addCell("Alpha", "A1", "= 38133.09128901").addExpectedValue("Alpha", "A1", 38133.09128901).run();
20    runner().addCell("Alpha", "A1", "= 4.00000000000001").addExpectedValue("Alpha", "A1", 4.00000000000001).run();
21    runner().addCell("Alpha", "A1", "= 33.0000000000000").addExpectedValue("Alpha", "A1", 33.0).run();
22  }
23
24  @Test
25  public void test_InferredPositiveScientificNotation() {
26    runner().addCell("Alpha", "A1", "= 12387e0").addExpectedValue("Alpha", "A1", 12387.0).run();
27    runner().addCell("Alpha", "A1", "= 12387e1").addExpectedValue("Alpha", "A1", 123870.0).run();
28    runner().addCell("Alpha", "A1", "= 1.0e4").addExpectedValue("Alpha", "A1", 10000.0).run();
29    runner().addCell("Alpha", "A1", "= 0.0009e4").addExpectedValue("Alpha", "A1", 9.0).run();
30  }
31
32  @Test
33  public void test_PositiveScientificNotation() {
34    runner().addCell("Alpha", "A1", "= 12387e+0").addExpectedValue("Alpha", "A1", 12387.0).run();
35    runner().addCell("Alpha", "A1", "= 12387e+1").addExpectedValue("Alpha", "A1", 123870.0).run();
36    runner().addCell("Alpha", "A1", "= 1.0e+4").addExpectedValue("Alpha", "A1", 10000.0).run();
37    runner().addCell("Alpha", "A1", "= 0.0009e+4").addExpectedValue("Alpha", "A1", 9.0).run();
38  }
39
40  @Test
41  public void test_NegativeScientificNotation() {
42    runner().addCell("Alpha", "A1", "= 12387e-0").addExpectedValue("Alpha", "A1", 12387e-0).run();
43    runner().addCell("Alpha", "A1", "= 12387e-1").addExpectedValue("Alpha", "A1", 12387e-1).run();
44    runner().addCell("Alpha", "A1", "= 1.0e-4").addExpectedValue("Alpha", "A1", 1.0e-4).run();
45    runner().addCell("Alpha", "A1", "= 0.0009e-4").addExpectedValue("Alpha", "A1", 0.0009e-4).run();
46  }
47}