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/ExecutorSupportedEngineeringFormulasTest.ts
-rw-r--r--
645
 1import { runner, it, describe } from "../testutils/TestUtils";
 2
 3describe("Executor.execute - Engineering Formulas", function () {
 4  it("should support BIN2DEC", function () {
 5    runner()
 6      .addCell("Alpha", "A1", `=BIN2DEC("1010101010")`)
 7      .addExpectedValue("Alpha", "A1", -342)
 8      .run();
 9  });
10
11  it("should support BIN2HEX", function () {
12    runner()
13      .addCell("Alpha", "A1", `=BIN2HEX("1010101010")`)
14      .addExpectedValue("Alpha", "A1", "FFFFFFFEAA")
15      .run();
16  });
17
18  it("should support DELTA", function () {
19    runner().addCell("Alpha", "A1", `=DELTA(1, 2)`).addExpectedValue("Alpha", "A1", 0).run();
20  });
21});