Problemunvalidated
When I change the formula to use LEFT, concatenation of three columns and a fallback value — Apache POI 5.2.5. Tension: the evaluator returns an error. Outcome: result.getErrorValue() == 15 (#VALUE! error).
ea4d6e2c-48df-4656-9ae5-2c05fa54be9b
When I change the formula to use LEFT, concatenation of three columns and a fallback value — Apache POI 5.2.5. Tension: the evaluator returns an error. Outcome: result.getErrorValue() == 15 (#VALUE! error).