Bug 33849 - Problem while Reading cell with formula value
Summary: Problem while Reading cell with formula value
Status: RESOLVED INVALID
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.0-dev
Hardware: PC Windows 2000
: P2 critical (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-03-04 17:47 UTC by Monica
Modified: 2005-11-09 03:29 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Monica 2005-03-04 17:47:32 UTC 
Hi,

I have an Excel shet containign formulas that I tried to read.When I tried to 
read cell with formula I am not getting any value.I am using Jar files from 
"poi-bin-2.0-RC2-20040102" I tried to use valueRowt.getCell((short)
r)).getCellFormula() but it's not working it is giving Method with name 
getCellFormula() is not found in HSSFCell.

Can you please suggest me how to read value from formula cell.
If I am not using right version can you please provide URL where I can get New 
version.

Thanks
Monica
Comment 1 Avik Sengupta 2005-03-07 09:44:41 UTC 
Not a bug. Method name not found means you have classpath issues. 

Also, questions should be addressed to the mailing list rather than bugzilla.
Comment 2 surender kotagiri 2005-11-09 12:18:52 UTC 
Problem while Reading cell with formula value
Comment 3 surender kotagiri 2005-11-09 12:29:43 UTC 
Please if anybody have solution for this please give an example.

thanks & regards,
Surender kotagiri


(In reply to comment #0)
> Hi,
> I have an Excel shet containign formulas that I tried to read.When I tried to 
> read cell with formula I am not getting any value.I am using Jar files from 
> "poi-bin-2.0-RC2-20040102" I tried to use valueRowt.getCell((short)
> r)).getCellFormula() but it's not working it is giving Method with name 
> getCellFormula() is not found in HSSFCell.
> Can you please suggest me how to read value from formula cell.
> If I am not using right version can you please provide URL where I can get 
New 
> version.
> Thanks
> Monica