Hi Nick, > You could just get POI to calculate the values for you: > http://poi.apache.org/spreadsheet/eval.html
I had already tried this, but unfortunately I came across a phenomenon which gave me an impression that the POI formula evaluation might still have some incorrect behaviors. I reported this as next: https://issues.apache.org/bugzilla/show_bug.cgi?id=50209 So I thought that getting Excel to caluculate formula is more reliable. But, I see that there is no way like HSSFSheet. setForceFormulaRecalculation() in case of XSSF. Thanks for your help. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
