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

A friendly place for programming greenhorns!

Big Moose Saloon

Search | Java FAQ | Recent Topics

Win a copy of Arduino in Action this week in the General Computing forum!

A special promo: Enter your blog post or vote on a blogger to be featured in an upcoming Journal

JavaRanch » Java Forums » Java » Other JSE/JEE APIs

Author

JEXCEL API formula cell read problem

Manohar
Greenhorn

Joined: Aug 14, 2003
Posts: 4

posted

0

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

posted

0

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
Apache POI Not implemented yet issue with Excel 2007 formulas
Read MS Excel Sheet Formula Execution Value Without Opening it
Reading only text content of the foruma cell + POI 3.5
JExelApi read formulaNumberValue
JExcel Help