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

JXL api 1.2.6 jar Formula ERROR

prabhakar ganta

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


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