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/main/js/formulas/engineering/DELTA.ts
-rw-r--r--
896
 1import { isNotUndefined } from "../../utils/Other";
 2import { SheetColumnRowKey } from "../../models/common/SheetColumnRowKey";
 3import { Complex } from "../../models/common/Types";
 4import { Converters } from "../../utils/Converters";
 5import { AbstractFormula } from "../AbstractFormula";
 6import { FormulaName } from "../FormulaName";
 7
 8export class DELTA extends AbstractFormula {
 9  static SELF: DELTA = new DELTA();
10  NAME = FormulaName.DELTA;
11
12  internal(origin: SheetColumnRowKey, ...values: Array<Complex>) {
13    AbstractFormula.checkLengthBetween(values.length, 1, 2, this.NAME);
14    const first = Converters.first(this.collateralLookup(origin, values[0]));
15    const second = isNotUndefined(values[1])
16      ? Converters.first(this.collateralLookup(origin, values[1]))
17      : 0;
18    if (Converters.toNumber(first) === Converters.toNumber(second)) {
19      return 1;
20    }
21    return 0;
22  }
23}