JXL api 1.2.6 jar Formula ERROR

[prabhakar ganta]

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