Decompiled Code For HLOOKUP( C114, D$114:G$116, 1.0, false )
The expression
=HLOOKUP( C114, D$114:G$116, 1.0, false )
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; private boolean $arr$0$init; private String[] $constarr$0; $Root(Inputs inputs, Environment environment) { $environment = environment; $inputs = inputs; } final String get$0() { return $idx$0(Runtime_v2.fun_MATCH_Exact(get$1(), $arr$0()) - 1); } public final String str() { return get$0(); } final String[] $arr$0() { if (!$arr$0$init) { $arr$0$init = true; String[] strings = $constarr$0(); strings[0] = get$2(); strings[1] = get$3(); strings[2] = get$4(); strings[3] = get$5(); return strings; } return $constarr$0(); } final String[] $constarr$0() { if ($constarr$0 == null) $constarr$0 = new String[4]; return $constarr$0; } final String $idx$0(int i) { switch (i) { case 0: return get$2(); case 1: return get$3(); case 2: return get$4(); case 3: return get$5(); default: throw new FormulaException ("#VALUE/REF! because index is out of range in INDEX"); } } final String get$1() { return Runtime_v2.stringFromString($inputs.str(0)); } final String get$2() { return Runtime_v2.stringFromString($inputs.str(1)); } final String get$3() { return Runtime_v2.stringFromString($inputs.str(2)); } final String get$4() { return Runtime_v2.stringFromString($inputs.str(3)); } final String get$5() { return Runtime_v2.stringFromString($inputs.str(4)); } }