Re: How to make new Excel 2007 functions like SUMIFS work inApachePOI?

[zephod <ze...@tlen.pl>]

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 <ap...@gagravarr.org> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
> 
> 







---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org