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.