aspose 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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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
 
Similar Threads
i am not able to add formula in my jxl sheet formula is like =sheetname!s12
finding the empty cell using jxl
JXL: Reading Time Format
Formula not rendered with POI 3.6
if condition in formula in jxl