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/js/execution/ExecutorSheetTest.ts
-rw-r--r--
780
 1import { runner, it, describe } from "../testutils/TestUtils";
 2
 3describe("Executor.execute - Sheet", function () {
 4  it("should allow normal sheet names with alpha-numeric identifiers", function () {
 5    runner()
 6      .addCell("SheetNameHere", "A1", "= 10")
 7      .addCell("Sheet.Name.Here", "A1", "= 10")
 8      .addExpectedValue("SheetNameHere", "A1", 10)
 9      .addExpectedValue("Sheet.Name.Here", "A1", 10)
10      .run();
11  });
12
13  it("should allow sheet names that are more complex", function () {
14    runner()
15      .addCell("This    Is     A   Sheet.Name", "A1", "= 10")
16      .addCell("Alpha", "A1", "= 'This    Is     A   Sheet.Name'!A1")
17      .addExpectedValue("This    Is     A   Sheet.Name", "A1", 10)
18      .addExpectedValue("Alpha", "A1", 10)
19      .run();
20  });
21});