Hi all, I apologize if this is a repost, I originally tried to post from nabble, and not sure if that worked or not. I am rewriting the question a bit, so it doesn't seem to repetitive. :)
If anyone has any ideas on how to do this, I would be very grateful. I am creating an HSSF excel spreadsheet using POI. Currently, I use cell.setCellValue to set the information in the a cell, however, when I open the spreadsheet, it is impossible for me to get the cells to recalculate with the standard excel functions. No matter what I try F9, Ctrl-F9, Ctrl->Alt-F9, the cells don't calculate. The only thing that seems to get them to calculate is to either click on the cell, and hit enter, or do a replace for = with =. So, I have tried to use setCellFormula, but the problem is, I want to set the cell formula in the spreadsheet I am writing to an addin function, so that the addin will be able to pull the values in. But, the cell parser keeps saying that the formula is not registered, since of course it is not an add-in function. I have read the instructions on how to create a new function, but I would rather be ignored by the parser, as it requires pulling information through an addin, so POI would not be able to accurately calculate it. I also tried adding "setForceFormulaReclaculation(true)" to the spreadsheet, but that didn't seem to do anything. I have also tried POI versions 3.4, 3.7, and 3.8 beta 3, but they all seem to do the exact same thing. Any ideas? Thanks for your help in advance! - Ben McKenzie
