Decompiled Code For INDEX( F$61:G$61, C61, D61 )
The expression
=INDEX( F$61:G$61, C61, D61 )
is compiled to the following class(es):
package org.formulacompiler.gen; import org.formulacompiler.runtime.Computation; import org.formulacompiler.runtime.FormulaException; import org.formulacompiler.runtime.internal.Environment; import org.formulacompiler.runtime.internal.Runtime_v2; import org.formulacompiler.tests.reference.base.Inputs; import org.formulacompiler.tests.reference.base.Outputs; final class $Root extends Outputs implements Computation { private final Inputs $inputs; final Environment $environment; $Root(Inputs inputs, Environment environment) { $environment = environment; $inputs = inputs; } final double get$0() { return $idx$0($lin$1$2((int) Runtime_v2.checkDouble(get$3()), (int) Runtime_v2.checkDouble(get$4()))); } public final double dbl() { return get$0(); } final int $lin$1$2(int i, int i_0_) { if (i >= 1 && i <= 1 && i_0_ >= 1 && i_0_ <= 2) return (i - 1) * 2 + (i_0_ - 1); throw new FormulaException ("#VALUE/REF! because index is out of range in INDEX"); } final double $idx$0(int i) { switch (i) { case 0: return get$1(); case 1: return get$2(); default: throw new FormulaException ("#VALUE/REF! because index is out of range in INDEX"); } } final double get$1() { return $inputs.dbl(3); } final double get$2() { return $inputs.dbl(4); } final double get$3() { return $inputs.dbl(0); } final double get$4() { return $inputs.dbl(1); } }