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/math/ISEVEN.ts
-rw-r--r--
832
 1import { SheetColumnRowKey } from "../../models/common/SheetColumnRowKey";
 2import { Complex } from "../../models/common/Types";
 3import { Converters } from "../../utils/Converters";
 4import { Numbers } from "../../utils/Numbers";
 5import { AbstractFormula } from "../AbstractFormula";
 6import { FormulaName } from "../FormulaName";
 7import { ROUNDDOWN } from "./ROUNDDOWN";
 8
 9export class ISEVEN extends AbstractFormula {
10  static SELF: ISEVEN = new ISEVEN();
11  NAME = FormulaName.ISEVEN;
12
13  internal(origin: SheetColumnRowKey, ...values: Array<Complex>) {
14    AbstractFormula.checkLength(values.length, 1, this.NAME);
15    const value = Converters.toNumber(Converters.first(this.collateralLookup(origin, values[0])));
16    const rounded = Converters.toNumber(ROUNDDOWN.SELF.run(null, value));
17    return Numbers.isZero(rounded % 2);
18  }
19}