I am using POI 3.7 beta version. When I try to access a cell of another sheet of same workbook like '=Sheet2!B6' . In our code we do not do anything with this formula and let the excel itself handle it. We only do :
As it is required for POI version after 3.0. I have verified that this formula ie. '=Sheet2!B6' is working fine when I am using POI version 2.5. But this problem occurs with POI 3.6 and 3.7.
So do I need to do something explicitly so that #REF! error does not occur.Kindly help!!!
Thanks in advance.