poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jaap Gordijn <gord...@cs.vu.nl>
Subject A formula read by getCellFormula() not be succesfully written to an XLS sheet by POI
Date Thu, 10 May 2007 14:02:41 GMT
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@cs.vu.nl

-- 
Jaap Gordijn
VUA Amsterdam, The Netherlands
Phone: ++31 20 598 7769
Mail: gordijn@cs.vu.nl
Web: http://www.e3value.com/


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Mime
View raw message