I think I solved my problem by switching to XSSFWorkbook. Previously I used HSSF as the tutorials do, which did not work with the new functions. Reevaluating values was not necessary.
Cheers, Jacek Dnia 5 lutego 2013 13:05 Nick Burch <[email protected]> napisał(a): > > > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
