1package io.protobase.f7.spreadsheet;
  2
  3import io.protobase.f7.errors.RefException;
  4import io.protobase.f7.testutils.TestExecution;
  5import org.junit.Test;
  6
  7public class GeneralLessThanOrEqualComparisonTest extends TestExecution {
  8  @Test
  9  public void test_Number() {
 10    runner().addCell("Alpha", "A1", "= 1 <= 1").addExpectedValue("Alpha", "A1", true).run();
 11    runner().addCell("Alpha", "A1", "= 1 <= 2").addExpectedValue("Alpha", "A1", true).run();
 12    runner().addCell("Alpha", "A1", "= -10 <= 0").addExpectedValue("Alpha", "A1", true).run();
 13    runner().addCell("Alpha", "A1", "= 2 <= 1").addExpectedValue("Alpha", "A1", false).run();
 14    runner().addCell("Alpha", "A1", "= 0 <= -10").addExpectedValue("Alpha", "A1", false).run();
 15    runner().addCell("Alpha", "A1", "= 1.1928731 <= 1.1928731").addExpectedValue("Alpha", "A1", true).run();
 16  }
 17
 18  @Test
 19  public void test_String() {
 20    runner().addCell("Alpha", "A1", "= \"Yes\" <= \"Yes\"").addExpectedValue("Alpha", "A1", true).run();
 21    runner().addCell("Alpha", "A1", "= \"Yes\" <= \"No\"").addExpectedValue("Alpha", "A1", false).run();
 22    runner().addCell("Alpha", "A1", "= \"No\"<= \"Yes\"").addExpectedValue("Alpha", "A1", true).run();
 23    runner().addCell("Alpha", "A1", "= \"\" <= \"\"").addExpectedValue("Alpha", "A1", true).run();
 24    runner().addCell("Alpha", "A1", "= \" \" <= \"\"").addExpectedValue("Alpha", "A1", false).run();
 25    runner().addCell("Alpha", "A1", "= \"\" <= \" \"").addExpectedValue("Alpha", "A1", true).run();
 26  }
 27
 28  @Test
 29  public void test_Boolean() {
 30    runner().addCell("Alpha", "A1", "= TRUE <= TRUE").addExpectedValue("Alpha", "A1", true).run();
 31    runner().addCell("Alpha", "A1", "= FALSE <= FALSE").addExpectedValue("Alpha", "A1", true).run();
 32    runner().addCell("Alpha", "A1", "= TRUE <= FALSE").addExpectedValue("Alpha", "A1", false).run();
 33    runner().addCell("Alpha", "A1", "= FALSE <= TRUE").addExpectedValue("Alpha", "A1", true).run();
 34  }
 35
 36  @Test
 37  public void test_ArrayLiteral() {
 38    runner().addCell("Alpha", "A1", "= {1, 2, 3} <= {1, 2, 3}").addExpectedValue("Alpha", "A1", true).run();
 39    runner().addCell("Alpha", "A1", "= {1, 2, 3} <= {44}").addExpectedValue("Alpha", "A1", true).run();
 40    runner().addCell("Alpha", "A1", "= {44, 2, 3} <= {1}").addExpectedValue("Alpha", "A1", false).run();
 41    runner().addCell("Alpha", "A1", "= {44, #REF!} <= {44, #REF!}").addExpectedValue("Alpha", "A1", true).run();
 42  }
 43
 44  @Test
 45  public void test_NumberToBoolean() {
 46    runner().addCell("Alpha", "A1", "= 0 <= TRUE").addExpectedValue("Alpha", "A1", true).run();
 47    runner().addCell("Alpha", "A1", "= 1 <= TRUE").addExpectedValue("Alpha", "A1", true).run(); // Important.
 48    runner().addCell("Alpha", "A1", "= 1 <= FALSE").addExpectedValue("Alpha", "A1", true).run();
 49    runner().addCell("Alpha", "A1", "= 0 <= FALSE").addExpectedValue("Alpha", "A1", true).run();
 50    runner().addCell("Alpha", "A1", "= -1 <= TRUE").addExpectedValue("Alpha", "A1", true).run();
 51    runner().addCell("Alpha", "A1", "= -1 <= FALSE").addExpectedValue("Alpha", "A1", true).run();
 52  }
 53
 54  @Test
 55  public void test_NumberToString() {
 56    runner().addCell("Alpha", "A1", "= 0 <= \"\"").addExpectedValue("Alpha", "A1", true).run();
 57    runner().addCell("Alpha", "A1", "= 0 <= \"0\"").addExpectedValue("Alpha", "A1", true).run();
 58    runner().addCell("Alpha", "A1", "= 1 <= \"0\"").addExpectedValue("Alpha", "A1", true).run();
 59    runner().addCell("Alpha", "A1", "= 1 <= \"1\"").addExpectedValue("Alpha", "A1", true).run();
 60    runner().addCell("Alpha", "A1", "= -1 <= \"1\"").addExpectedValue("Alpha", "A1", true).run();
 61    runner().addCell("Alpha", "A1", "= 1000 <= \"-100\"").addExpectedValue("Alpha", "A1", true).run();
 62    runner().addCell("Alpha", "A1", "= 1000 <= \"Anything in the world.\"").addExpectedValue("Alpha", "A1", true).run();
 63  }
 64
 65  @Test
 66  public void test_NumberToArrayLiteral() {
 67    runner().addCell("Alpha", "A1", "= -1 <= {0, 1, 2}").addExpectedValue("Alpha", "A1", true).run();
 68    runner().addCell("Alpha", "A1", "= 0 <= {0, 1, 2}").addExpectedValue("Alpha", "A1", true).run();
 69    runner().addCell("Alpha", "A1", "= 1 <= {0, 1, 2}").addExpectedValue("Alpha", "A1", false).run();
 70    runner().addCell("Alpha", "A1", "= 0 <= {1, 1, 2}").addExpectedValue("Alpha", "A1", true).run();
 71    runner().addCell("Alpha", "A1", "= 0 <= {1, \"Ignore me.\"}").addExpectedValue("Alpha", "A1", true).run();
 72  }
 73
 74  @Test
 75  public void test_NumberToBlank() {
 76    runner().addCell("Alpha", "A1", "= 0 <= M9").addExpectedValue("Alpha", "A1", true).run();
 77    runner().addCell("Alpha", "A1", "= 1 <= M9").addExpectedValue("Alpha", "A1", false).run();
 78    runner().addCell("Alpha", "A1", "= M9 <= 0").addExpectedValue("Alpha", "A1", true).run();
 79    runner().addCell("Alpha", "A1", "= M9 <= 1").addExpectedValue("Alpha", "A1", true).run();
 80    runner().addCell("Alpha", "A1", "= -1 <= M9").addExpectedValue("Alpha", "A1", true).run();
 81    runner().addCell("Alpha", "A1", "= M9 <= -1").addExpectedValue("Alpha", "A1", false).run();
 82  }
 83
 84  @Test
 85  public void test_StringToBoolean() {
 86    runner().addCell("Alpha", "A1", "= \"TRUE\" <= TRUE").addExpectedValue("Alpha", "A1", true).run();
 87    runner().addCell("Alpha", "A1", "= \"FALSE\" <= FALSE").addExpectedValue("Alpha", "A1", true).run();
 88    runner().addCell("Alpha", "A1", "= \"TRUE\" <= TRUE").addExpectedValue("Alpha", "A1", true).run();
 89    runner().addCell("Alpha", "A1", "= \"\" <= TRUE").addExpectedValue("Alpha", "A1", true).run();
 90    runner().addCell("Alpha", "A1", "= \"\" <= FALSE").addExpectedValue("Alpha", "A1", true).run();
 91    runner().addCell("Alpha", "A1", "= \"Anything\" <= FALSE").addExpectedValue("Alpha", "A1", true).run();
 92  }
 93
 94  @Test
 95  public void test_StringToBlank() {
 96    runner().addCell("Alpha", "A1", "= \"\" <= M10").addExpectedValue("Alpha", "A1", true).run();
 97    runner().addCell("Alpha", "A1", "= M10 <= \"\"").addExpectedValue("Alpha", "A1", true).run();
 98    runner().addCell("Alpha", "A1", "= \" \" <= M10").addExpectedValue("Alpha", "A1", false).run();
 99    runner().addCell("Alpha", "A1", "= M10 <= \" \"").addExpectedValue("Alpha", "A1", true).run();
100    runner().addCell("Alpha", "A1", "= \"One\" <= M10").addExpectedValue("Alpha", "A1", false).run();
101    runner().addCell("Alpha", "A1", "= M10 <= \"One\"").addExpectedValue("Alpha", "A1", true).run();
102  }
103
104  @Test
105  public void test_BooleanToBlank() {
106    runner().addCell("Alpha", "A1", "= TRUE <= M10").addExpectedValue("Alpha", "A1", false).run();
107    runner().addCell("Alpha", "A1", "= FALSE <= M10").addExpectedValue("Alpha", "A1", true).run();
108    runner().addCell("Alpha", "A1", "= M10 <= TRUE").addExpectedValue("Alpha", "A1", true).run();
109    runner().addCell("Alpha", "A1", "= M10 <= FALSE").addExpectedValue("Alpha", "A1", true).run();
110  }
111
112  @Test
113  public void test_ArrayLiteralToString() {
114    runner().addCell("Alpha", "A1", "= {\"A\", \"B\"} <= \"A\"").addExpectedValue("Alpha", "A1", true).run();
115    runner().addCell("Alpha", "A1", "= {\"A\", \"B\"} <= \"B\"").addExpectedValue("Alpha", "A1", true).run();
116    runner().addCell("Alpha", "A1", "= \"A\" <= {\"A\", \"B\"}").addExpectedValue("Alpha", "A1", true).run();
117    runner().addCell("Alpha", "A1", "= \"B\" <= {\"A\", \"B\"}").addExpectedValue("Alpha", "A1", false).run();
118  }
119
120  @Test
121  public void test_ArrayLiteralToBoolean() {
122    runner().addCell("Alpha", "A1", "= {TRUE, FALSE} <= TRUE").addExpectedValue("Alpha", "A1", true).run();
123    runner().addCell("Alpha", "A1", "= TRUE <= {TRUE, FALSE}").addExpectedValue("Alpha", "A1", true).run();
124    runner().addCell("Alpha", "A1", "= {FALSE, FALSE} <= TRUE").addExpectedValue("Alpha", "A1", true).run();
125    runner().addCell("Alpha", "A1", "= TRUE <= {FALSE, FALSE}").addExpectedValue("Alpha", "A1", false).run();
126  }
127
128  @Test
129  public void test_Error() {
130    runner().addCell("Alpha", "A1", "= 10 <= #REF!").addExpectedValue("Alpha", "A1", new RefException()).run();
131    runner().addCell("Alpha", "A1", "= #REF! <= TRUE").addExpectedValue("Alpha", "A1", new RefException()).run();
132  }
133}