using an add-in defined function in a sheet

[ben <bm...@highlinefi.com>]

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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org