wood burning stoves 2.0*
The moose likes Other JSE/JEE APIs and the fly likes JEXCEL API  formula cell read problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Other JSE/JEE APIs
Bookmark "JEXCEL API  formula cell read problem" Watch "JEXCEL API  formula cell read problem" New topic
Author

JEXCEL API formula cell read problem

Manohar
Greenhorn

Joined: Aug 14, 2003
Posts: 4
I have created an excel file and placed 10 in A0 and 20 in A4 and in B4 I have formula A0+A4. Now when I modify the value of A4(100) in output.xls(generated), I still get the old value in the Formula Cell i.e. 30 and not as 110. Can anyone guide me.
Valentin Crettaz
Gold Digger
Sheriff

Joined: Aug 26, 2001
Posts: 7610
Moving this thread to the Other Java APIs forum. Please continue this dicussion there. Thank you


SCJP 5, SCJD, SCBCD, SCWCD, SCDJWS, IBM XML
[Blog] [Blogroll] [My Reviews] My Linked In
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JEXCEL API formula cell read problem
 
Similar Threads
Reading only text content of the foruma cell + POI 3.5
Read MS Excel Sheet Formula Execution Value Without Opening it
JExcel Help
JExelApi read formulaNumberValue
Apache POI Not implemented yet issue with Excel 2007 formulas