1package io.protobase.f7.spreadsheet;
 2
 3import io.protobase.f7.errors.DivException;
 4import io.protobase.f7.testutils.TestExecution;
 5import org.junit.Test;
 6
 7public class GeneralConcatenationTest extends TestExecution {
 8  @Test
 9  public void test_String() {
10    runner().addCell("Alpha", "A1", "= \"Hello\" & \"There\"").addExpectedValue("Alpha", "A1", "HelloThere").run();
11    runner().addCell("Alpha", "A1", "= \"Hello\" & \"\"").addExpectedValue("Alpha", "A1", "Hello").run();
12    runner().addCell("Alpha", "A1", "= \"\" & \"\"").addExpectedValue("Alpha", "A1", "").run();
13    runner().addCell("Alpha", "A1", "= \"   \" & \"   \"").addExpectedValue("Alpha", "A1", "      ").run();
14  }
15
16  @Test
17  public void test_Number() {
18    runner().addCell("Alpha", "A1", "= 0 & 1").addExpectedValue("Alpha", "A1", "01").run();
19    runner().addCell("Alpha", "A1", "= 0 & 0").addExpectedValue("Alpha", "A1", "00").run();
20    runner().addCell("Alpha", "A1", "= 131238 & 99281").addExpectedValue("Alpha", "A1", "13123899281").run();
21    runner().addCell("Alpha", "A1", "= 13.1238 & 99281").addExpectedValue("Alpha", "A1", "13.123899281").run();
22    runner().addCell("Alpha", "A1", "= 0.001 & 1.0").addExpectedValue("Alpha", "A1", "0.0011").run();
23  }
24
25  @Test
26  public void test_Boolean() {
27    runner().addCell("Alpha", "A1", "= TRUE & TRUE").addExpectedValue("Alpha", "A1", "TRUETRUE").run();
28    runner().addCell("Alpha", "A1", "= TRUE & FALSE").addExpectedValue("Alpha", "A1", "TRUEFALSE").run();
29    runner().addCell("Alpha", "A1", "= FALSE & FALSE").addExpectedValue("Alpha", "A1", "FALSEFALSE").run();
30  }
31
32  @Test
33  public void test_Error() {
34    runner().addCell("Alpha", "A1", "= 1 & #DIV/0!").addExpectedValue("Alpha", "A1", new DivException()).run();
35  }
36
37  @Test
38  public void test_ArrayLiteral() {
39    runner().addCell("Alpha", "A1", "= {1} & {2}").addExpectedValue("Alpha", "A1", "12").run();
40    runner().addCell("Alpha", "A1", "= {1, 2, 3} & {4, 5, 6}").addExpectedValue("Alpha", "A1", "14").run();
41    runner().addCell("Alpha", "A1", "= {1, #NUM!} & {4, #REF!}").addExpectedValue("Alpha", "A1", "14").run();
42  }
43
44  @Test
45  public void test_Blank() {
46    runner().addCell("Alpha", "A1", "= {B1} & {B2}").addExpectedValue("Alpha", "A1", "").run();
47    runner().addCell("Alpha", "A1", "= {B1} & \"\"").addExpectedValue("Alpha", "A1", "").run();
48  }
49}