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/java/io/protobase/f7/formulas/math/MOD.java
-rw-r--r--
1135
 1package io.protobase.f7.formulas.math;
 2
 3import io.protobase.f7.errors.DivException;
 4import io.protobase.f7.formulas.AbstractFormula;
 5import io.protobase.f7.formulas.FormulaName;
 6import io.protobase.f7.models.GridColumnRowKey;
 7import io.protobase.f7.utils.Converters;
 8
 9import java.util.function.BiFunction;
10import java.util.function.Function;
11
12public class MOD extends AbstractFormula {
13  public static FormulaName NAME = FormulaName.MOD;
14  public static MOD SELF = new MOD();
15
16  public MOD() {
17    super();
18  }
19
20  public MOD(Function<Object, Object> lookup, BiFunction<GridColumnRowKey, Object, Object> collateralLookup) {
21    super(lookup, collateralLookup);
22  }
23
24  @Override
25  public Object internal(GridColumnRowKey origin, Object... values) {
26    checkLength(values.length, 2, NAME);
27    Double first = Converters.toDouble(Converters.first(collateralLookup.apply(origin, values[0])));
28    Double second = Converters.toDouble(Converters.first(collateralLookup.apply(origin, values[1])));
29    if (second == -0 || second == 0) {
30      return new DivException("MOD parameter 2 cannot be zero.");
31    }
32    return first % second;
33  }
34}