A formula read by getCellFormula() not be succesfully written to an XLS sheet by POI

2007-05-10 Thread Jaap Gordijn
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

Re: POI 3.0 RC4

2007-05-10 Thread Nick Burch
On Mon, 7 May 2007, Joerg Hohwiller wrote: Thanks for your work. I have tested the mavenized version of POI with maven 2.0.6. Your POM is gracefully accepted and everything works well. Great, that's good to know I personally like the idea of not further splitting the POI artifact into smaller

RE: There has got to be a way

2007-05-10 Thread Nick Burch
On Thu, 10 May 2007, Levi Strope wrote: That would be of GREAT use. I'll send you an off-list mail with the files. Note that it has only been tested on a fairly simple file, so there might be issues on fancier ones. BTW: what do you think the ETA is for that? For 3.0 Final? We're having

RE: There has got to be a way

2007-05-10 Thread Levi Strope
That would be of GREAT use. BTW: what do you think the ETA is for that? -Original Message- From: Nick Burch [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 6:05 AM To: POI Users List Subject: Re: There has got to be a way On Tue, 1 May 2007, Levi Strope wrote: > All I need t

Re: There has got to be a way

2007-05-10 Thread Nick Burch
On Tue, 1 May 2007, Levi Strope wrote: All I need to do is read in a row of data, just like the spreadsheet that is attached, and parse the information reliably. There are many blank cells here, but I need to account for them. I've got some code that might help here. Instead of registering yo