f7
f7 is a spreadsheet formula execution library
git clone https://git.vogt.world/f7.git
Log | Files | README.md | LICENSE.md
← All files
name: src/test/java/io/protobase/f7/spreadsheet/GeneralSupportedTextFormulasTest.java
-rw-r--r--
777
 1package io.protobase.f7.spreadsheet;
 2
 3import io.protobase.f7.testutils.TestExecution;
 4import org.junit.Test;
 5
 6public class GeneralSupportedTextFormulasTest extends TestExecution {
 7  @Test
 8  public void test_CONCAT() {
 9    runner().addCell("Alpha", "A1", "=CONCAT(\"One\", \"Two\")").addExpectedValue("Alpha", "A1", "OneTwo").run();
10  }
11
12  @Test
13  public void test_CONCATENATE() {
14    runner().addCell("Alpha", "A1", "=CONCATENATE(\"One\", \"Two\")").addExpectedValue("Alpha", "A1", "OneTwo").run();
15  }
16
17  @Test
18  public void test_T() {
19    runner().addCell("Alpha", "A1", "=T(\"One\")").addExpectedValue("Alpha", "A1", "One").run();
20  }
21
22  @Test
23  public void test_LEN() {
24    runner().addCell("Alpha", "A1", "=LEN(\"One\")").addExpectedValue("Alpha", "A1", 3.0).run();
25  }
26}