A formula read by getCellFormula() not be succesfully written to an XLS sheet b 2007-05-10 - By Jaap Gordijn
Back
Hi all,
Suppose I put the formula in a formula-field: IF(12<10;1;2)
If I write the spreadsheet and open the spreadsheet in Excel, everything
is fine (in Excel I read IF(12<10;1;2)).
If I read the spreadsheet using POI and getCellFormula I get:
IF(12<10,1,2) (';' replaced by ',").
How can I prevent this behaviour?
I am using the POI svn checkout of april 27th 2007
Thanks.
--
Jaap Gordijn
VUA Amsterdam, The Netherlands
Phone: ++31 20 598 7769
Mail: gordijn@(protected)
--
Jaap Gordijn
VUA Amsterdam, The Netherlands
Phone: ++31 20 598 7769
Mail: gordijn@(protected)
Web: http://www.e3value.com/
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe, e-mail: poi-user-unsubscribe@(protected)
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
|
|
