On Thu, 1 Nov 2012, Chris Bamford wrote:
Exception in thread "main" java.lang.RuntimeException: Coding Error:
Expected ExpPtg to be converted from Shared to Non-Shared Formula by
ValueRecordsAggregate, but it wasn't
which I see is listed as a bug here:
https://issues.apache.org/bugzilla/show_bug.cgi?id=52158
Ah, yes. Some work is needed on that, but no-one has so far found the time
to do it :(
However, if I setFormulasNotResults(false) it runs OK and I see numbers
being displayed, not Strings like "D1+C3". Is this what you'd expect?
Yes. Formulas in Excel (.xls) are stored with two parts. One is the last
value (number or string) that the formula evaluated to. The other is the
formula itself, stored in a parsed format. With the false flag, you get
the last result Excel calculated returned. With true, we try to turn the
parsed formula tokens back into a string. For your case, the formula is
actually shared across multiple cells, and another bit of POI is objecting
because the sharing is expected to be resolved but hasn't been
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
