1package io.protobase.f7.spreadsheet;
 2
 3import io.protobase.f7.testutils.TestExecution;
 4import org.junit.Test;
 5
 6public class GeneralSupportedInfoFormulasTest extends TestExecution {
 7  @Test
 8  public void test_ERRORTYPE() {
 9    runner().addCell("Alpha", "A1", "=ERRORTYPE(#NULL!)").addExpectedValue("Alpha", "A1", 1.0).run();
10  }
11
12  @Test
13  public void test_ISBLANK() {
14    runner().addCell("Alpha", "A1", "=ISBLANK(M88)").addExpectedValue("Alpha", "A1", true).run();
15  }
16
17  @Test
18  public void test_ISERROR() {
19    runner().addCell("Alpha", "A1", "=ISERROR(#N/A)").addExpectedValue("Alpha", "A1", true).run();
20  }
21
22  @Test
23  public void test_ISERR() {
24    runner().addCell("Alpha", "A1", "=ISERR(#NULL!)").addExpectedValue("Alpha", "A1", true).run();
25  }
26
27  @Test
28  public void test_ISLOGICAL() {
29    runner().addCell("Alpha", "A1", "=ISLOGICAL(false)").addExpectedValue("Alpha", "A1", true).run();
30  }
31
32  @Test
33  public void test_ISNA() {
34    runner().addCell("Alpha", "A1", "=ISNA(#N/A)").addExpectedValue("Alpha", "A1", true).run();
35  }
36
37  @Test
38  public void test_ISNONTEXT() {
39    runner().addCell("Alpha", "A1", "=ISNONTEXT(false)").addExpectedValue("Alpha", "A1", true).run();
40  }
41
42  @Test
43  public void test_ISNUMBER() {
44    runner().addCell("Alpha", "A1", "=ISNUMBER(false)").addExpectedValue("Alpha", "A1", false).run();
45  }
46
47  @Test
48  public void test_ISTEXT() {
49    runner().addCell("Alpha", "A1", "=ISTEXT(true)").addExpectedValue("Alpha", "A1", false).run();
50  }
51}