1package io.protobase.f7.spreadsheet;
 2
 3import io.protobase.f7.testutils.TestExecution;
 4import org.junit.Test;
 5
 6public class GeneralSupportedLogicFormulasTest extends TestExecution {
 7  @Test
 8  public void test_AND() {
 9    runner().addCell("Alpha", "A1", "=AND(TRUE, 1, 1)").addExpectedValue("Alpha", "A1", true).run();
10  }
11
12  @Test
13  public void test_EQ() {
14    runner().addCell("Alpha", "A1", "=EQ(10, 298132.222)").addExpectedValue("Alpha", "A1", false).run();
15  }
16
17  @Test
18  public void test_EXACT() {
19    runner().addCell("Alpha", "A1", "=EXACT(\"One\", \"Two\")").addExpectedValue("Alpha", "A1", false).run();
20  }
21
22  @Test
23  public void test_FALSE() {
24    runner().addCell("Alpha", "A1", "=FALSE()").addExpectedValue("Alpha", "A1", false).run();
25  }
26
27  @Test
28  public void test_GTE() {
29    runner().addCell("Alpha", "A1", "=GTE(10.4, 0.11111)").addExpectedValue("Alpha", "A1", true).run();
30  }
31
32  @Test
33  public void test_GT() {
34    runner().addCell("Alpha", "A1", "=GT(10.4, 0.11111)").addExpectedValue("Alpha", "A1", true).run();
35  }
36
37  @Test
38  public void test_IFERROR() {
39    runner().addCell("Alpha", "A1", "=IFERROR(#DIV/0!, 1)").addExpectedValue("Alpha", "A1", 1.0).run();
40  }
41
42  @Test
43  public void test_IFNA() {
44    runner().addCell("Alpha", "A1", "=IFNA(#N/A, 1)").addExpectedValue("Alpha", "A1", 1.0).run();
45  }
46
47  @Test
48  public void test_IF() {
49    runner().addCell("Alpha", "A1", "=IF(TRUE, 99, 1)").addExpectedValue("Alpha", "A1", 99.0).run();
50  }
51
52  @Test
53  public void test_LTE() {
54    runner().addCell("Alpha", "A1", "=LTE(10.4, 0.11111)").addExpectedValue("Alpha", "A1", false).run();
55  }
56
57  @Test
58  public void test_LT() {
59    runner().addCell("Alpha", "A1", "=LT(10.4, 0.11111)").addExpectedValue("Alpha", "A1", false).run();
60  }
61
62  @Test
63  public void test_NE() {
64    runner().addCell("Alpha", "A1", "=NE(10.4, 0.11111)").addExpectedValue("Alpha", "A1", true).run();
65  }
66
67  @Test
68  public void test_NOT() {
69    runner().addCell("Alpha", "A1", "=NOT(TRUE())").addExpectedValue("Alpha", "A1", false).run();
70  }
71
72  @Test
73  public void test_OR() {
74    runner().addCell("Alpha", "A1", "=OR(TRUE, 1, 1)").addExpectedValue("Alpha", "A1", true).run();
75  }
76
77  @Test
78  public void test_TRUE() {
79    runner().addCell("Alpha", "A1", "=TRUE()").addExpectedValue("Alpha", "A1", true).run();
80  }
81
82  @Test
83  public void test_XOR() {
84    runner().addCell("Alpha", "A1", "=XOR(TRUE, 1, 1)").addExpectedValue("Alpha", "A1", true).run();
85  }
86}