Hi all, I am trying to do something in POI, and I am finding myself completely stumped on how to do it.
I want to have a user defined function set from a java program (using POI), which then will allow it to be calculated when the spreadsheet opens in Excel. it would be impossible to calculate this function in POI. However, when I use cell.setCellValue() and open the file, the cells are not able to calculate, and no matter what I try F9, Ctrl-F9, etc, 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 =. When I use setCellFormula, I get an error saying that the function is not registered, which of course it is not, since it is a add-in defined function. I also tried addin "setForceFormulaReclaculation(true)" to the spreadsheet, but that didn't seem to do anything. Any ideas? Thanks for your help in advance! -- View this message in context: http://apache-poi.1045710.n5.nabble.com/using-an-add-in-defined-function-in-a-sheet-tp4710148p4710148.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
