Using Apache POI HSSF, how can I refresh all formula cells at once?

Sure. Refreshing all the formulas in a workbook is possibly the more typical use case anyway.

Up vote 4 down vote favorite 1 share g+ share fb share tw.

I am filling cells of an Excel file using Apache POI, and there are a lot of formula cells in the document. However, their values are not refreshed when I open the document in Excel. It's my understanding that I need to use a FormulaEvaluator to refresh formula cells.

Is there a way, though, to update all formula cells at once? There are a lot of them, and while making an exhaustive list is not out of question, it's certainly not something I'm very willing to do. Java apache-poi link|improve this question edited May 9 '11 at 13:14skaffman114k8136227 asked May 9 '11 at 13:13zneak21.9k23770 89% accept rate.

Sure. Refreshing all the formulas in a workbook is possibly the more typical use case anyway. If you're using HSSF, call evaluatorAllFormulaCells: HSSFFormulaEvaluator.

EvaluateAllFormulaCells(hssfWorkbook) If you're using XSSF, call evaluatorAllFormulaCells: XSSFFormulaEvaluator. EvaluateAllFormulaCells(xssfWorkbook) More details are available on the poi website.

Thank you very much! – zneak May 9 '11 at 13:37.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.