[prev in list] [next in list] [prev in thread] [next in thread]
List: poi-user
Subject: IF(12<10;1;2) read by getCellFormula as IF(12<10,1,2)
From: Jaap Gordijn <gordijn () cs ! vu ! nl>
Date: 2007-04-27 15:01:54
Message-ID: 46321062.2010800 () cs ! vu ! nl
[Download RAW message or body]
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/
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic