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/ROUNDDOWN.java
-rw-r--r--
1616
 1package io.protobase.f7.formulas.math;
 2
 3import io.protobase.f7.formulas.AbstractFormula;
 4import io.protobase.f7.formulas.FormulaName;
 5import io.protobase.f7.models.GridColumnRowKey;
 6import io.protobase.f7.utils.Converters;
 7
 8import java.math.BigDecimal;
 9import java.math.RoundingMode;
10import java.util.function.BiFunction;
11import java.util.function.Function;
12
13public class ROUNDDOWN extends AbstractFormula {
14  public static FormulaName NAME = FormulaName.ROUNDDOWN;
15  public static ROUNDDOWN SELF = new ROUNDDOWN();
16
17  public ROUNDDOWN() {
18    super();
19  }
20
21  public ROUNDDOWN(Function<Object, Object> lookup, BiFunction<GridColumnRowKey, Object, Object> collateralLookup) {
22    super(lookup, collateralLookup);
23  }
24
25  @Override
26  public Object internal(GridColumnRowKey origin, Object... values) {
27    checkLengthBetween(values.length, 1, 2, NAME);
28    Object value = Converters.first(collateralLookup.apply(origin, values[0]));
29    Double placesRaw;
30    if (values.length == 1) {
31      placesRaw = 0.0;
32    } else {
33      placesRaw = Converters.toDouble(Converters.first(collateralLookup.apply(origin, values[1])));
34    }
35    Double number = Converters.toDouble(value);
36    BigDecimal bd = new BigDecimal(number.toString());
37    int places;
38    if (placesRaw > 0) {
39      places = new Double(Math.floor(placesRaw.floatValue())).intValue();
40    } else {
41      places = new Double(Math.ceil(placesRaw.floatValue())).intValue();
42    }
43    if (number < 0) {
44      bd = bd.setScale(places, RoundingMode.CEILING);
45    } else {
46      bd = bd.setScale(places, RoundingMode.FLOOR);
47    }
48    return bd.doubleValue();
49  }
50}