So I would like to explain my problem more elaborately. Suppose there is an excel file where user has specified a formula like F2-F1.So in F1 there is a variable x and in F2 there is another variable y. We read that excel file and from our code populate the values of x and y. But we do not touch the formula and it stays as it is.
In this scenario when I am using POI 3.5 the formula cell is populated without any problem. But for the same file with the same code when I use POI 3.5,POI 3.6 or POI 3.7 beta the formula cell shows error and cannot render the value.
So my question is for the these versions do I explicitly need to handle these codes. But the problem is how can I handle in code as these are generated run time and JAVA code won't understand F2 or F1 as such.
Is this an issue? Is it a known one and has some work around.Its quite hard to digest that an older version supports something that newer doesn't.
Kindly help me out. As I can't find any solution. Thanks in advance!!!
I hope I am clear,If there is still doubt please let me know I can give more information.