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/ASIN.ts
-rw-r--r--
889
 1import { NumException } from "../../errors/NumException";
 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 ASIN extends AbstractFormula {
 9  static SELF: ASIN = new ASIN();
10  NAME = FormulaName.ASIN;
11
12  internal(origin: SheetColumnRowKey, ...values: Array<Complex>) {
13    AbstractFormula.checkLength(values.length, 1, this.NAME);
14    const value = Converters.toNumber(Converters.first(this.collateralLookup(origin, values[0])));
15    if (value < -1 || value > 1) {
16      return new NumException(
17        `ASIN parameter 1 value is ${value}. Valid values should be between -1 and 1, inclusively`
18      );
19    }
20    return Math.asin(value);
21  }
22}