File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Java 8 in Action this week in the Java 8 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
Read MS Excel Sheet Formula Execution Value Without Opening it
JExcel Help
JExelApi read formulaNumberValue
Reading only text content of the foruma cell + POI 3.5
Apache POI Not implemented yet issue with Excel 2007 formulas