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 Open Source Projects and the fly likes JXL api 1.2.6 jar  Formula ERROR Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "JXL api 1.2.6 jar  Formula ERROR" Watch "JXL api 1.2.6 jar  Formula ERROR" New topic
Author

JXL api 1.2.6 jar Formula ERROR

prabhakar ganta
Greenhorn

Joined: Mar 14, 2011
Posts: 1
Hi All,

I am facing the issue with formula range calculation using jxl api jar where the formula is not getting calculated however it is being displayed as #value!. When i go to the indvidual cell and press F2+enter the formula is getting recalcuated and displaying the expected value.

The formula used
a1:a3/b1:b3 the output of this formula should be placed in c1:c3 cells.

Now I am getting #VALUE! when I try to run the same. The cell content is
This error is getting solved only when I go to that cell and press tab key or F2 key.

Please provide some solution


Regards
Prabhakar



 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JXL api 1.2.6 jar Formula ERROR