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});