Hi, I'm currently doing a study on POI framework, especially the formula parsing/evaluation features. I can see that a lot of Excel functions are supporter, really a great job.
Anyway, I've faced an issue that may be a bug, except if I forgot something. I've written a small class that perform a "copy down" of a formula cell, updating the references on the fly. My source formulas are correctly parsed, the references are correctly shifted and the paste seems OK but when I open the generated document in Excel, some formulas shows the #VALUE! error code. If I edit one of these cell and revalidate the formula (just by pressing ENTER), it displays correctly. I didn't forget to call the HSSFFormulaEvaluator.evaluateAllFormulaCells(workbook) method before saving my workbook. These formulas evaluate correctly : A1+B1 A1*B1 SUM(A2:B2) IF(TRUE,SUM(A2:B2)) But these don't : IF(TRUE,A11+B11) IF(TRUE,A2*B2) I'm using POI 3.1 Final because I need some newly added formulas, but these #VALUE! were correctly evalulating in 3.0.2 release I used previously. Thank you for your help and have a nice week end, Pierre
FormulaTest.xls
Description: MS-Excel spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
