Using poi-3.0-rc4, I'm reading an Excel spreadsheet (which works fine); changing some values (which works fine), and saving it out as a new version (which also works fine).
But, when I open the spreadsheet, all of my formula cells are not calculated (nor can I tell the spreadsheet to recalc using F9 for example). The are formula type cells according to HSSF. The formulas are there, if I click on them I can see them when I open the spreadsheet in Excel. If I then click onto the slot at the top where you can edit the formula itself (and then leave focus) the correct value is calculated and displayed. But I can't force the whole spreadsheet to recalculate; I have to "fix" it one cell at a time. Any idea what I could be doing wrong? Thank you, -J
