This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman 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 Building Microservices this week in the Design 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



 
Have you checked out Aspose?
 
subject: JXL api 1.2.6 jar Formula ERROR
 
It's not a secret anymore!