This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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
Formula not rendered with POI 3.6
JXL: Reading Time Format
i am not able to add formula in my jxl sheet formula is like =sheetname!s12
finding the empty cell using jxl
if condition in formula in jxl