On Tue, 5 Feb 2013, zephod wrote:
Are you triggering a formula recalculation at the end of the processing
of the file? Excel caches formula values, so you'll need to update
those when you're done making changes
No, I'm just constructing a spreadsheet with formulas and store it in a
file. Formulas with some functions work OK, but the ones with the new
functions that I listed don't. How would I trigger the recalculation you
suggest? Why some formulas work and others not?
When you're done making changes to the file, you need to re-evaluate.
Otherwise, Excel will show old/confused values until you force a refresh
(it caches values). See http://poi.apache.org/spreadsheet/eval.html
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
