But Excel it shows the result as #value. If I go into edit on the formula and hit enter, it recalcs and works fine. Forcing re-calc with an F9 or AltF9 or Ctl Alt F9 does nothing. Tried evaluator.evaluateFormulaCell(cell); within POI but that crashes, presumably LINEST and or array functions are not implemented.
So my solution has been to write an excel macro that loops through the rows and columns, pasting each cell onto itself, thus forcing recalc.
Is there a way of programatically from POI setting a cell so it is recalulated by Excel when it opens / hit f9?