poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harsh" <hubri...@nimaya.com>
Subject RE: Problem reading "AB.CD.E" as a string
Date Sun, 09 Mar 2003 11:28:57 GMT
Hi,
	It is basically Formula Calculator for Excel. We are using it 
To calculate formula in Excel on Unix Platform. 

Check out their web site. And One more thing , It is not free :-)
http://jsc.tomschuetz.com/

Harsh Ubriani
Nimaya Technologies, Hyderabad
India


-----Original Message-----
From: H@rry [mailto:apachePOI@SoftHome.net] 
Sent: Monday, March 10, 2003 9:23 AM
To: POI Users List
Subject: RE: Problem reading "AB.CD.E" as a string

JSC??? Is it a JAVA? where can I get this module???

"I know that the world is always unfair. 
 But I don't understand why it is never  unfair to my advantage."


@harry 
 

-----Original Message-----
From: Harsh [mailto:hubriani@nimaya.com]
Sent: Saturday, March 08, 2003 7:30 PM
To: 'POI Users List'
Subject: RE: Problem reading "AB.CD.E" as a string


Hi,

I suggest you one Thing. 
Use cell.getFormulaValue() which will return you Formula "=B9".

Now you can use JSC (Formula Calculator for Excel) to get 
The result of formula whichis "AB.CD.E".

Tell me if you need more details,
Harsh Ubriani
Nimaya Technologies, Hyderabad



-----Original Message-----
From: Kenneth Cheung [mailto:kenneth_cheung@scotiacapital.com] 
Sent: Friday, March 07, 2003 8:49 PM
To: poi-user@jakarta.apache.org
Subject: Problem reading "AB.CD.E" as a string


Hi,

Suppose in cell B9 I have a string "AB.CD.E" and in cell B10, I have
"=B9".

While I have no problem getting the string in B9 using
cell.getStringCellValue( ), I get a null if I try to read the value of
B10.

Now, if I use cell.getNumericCellValue( ) I get "NaN"  (not a number?)

I'm using Dev version 1.8.0 running on Solaris w/ JDK 1.3

Any help would be greatly appreciated.

Thanks
Ken



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org



Mime
View raw message