You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@poi.apache.org by Jaap Gordijn <go...@cs.vu.nl> on 2007/04/27 17:01:54 UTC

IF(12<10;1;2) read by getCellFormula as IF(12<10,1,2)

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



---------------------------------------------------------------------
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/