Reading a cell formula value that includes a link to another excel file, very
common
for most of the excel files I work with, causes unusual returned string.
e.g. Excel cell contains the following formula:
='C:\[poiTest.xls]HSSF Test'!$A$6
Read the formula value using POI 3.5 beta, print it to Eclipse console, get:
'[poiTest.xls]HSSF Test'!$A$6
The C:\[ appears to be replaced with a square bracket and a little square
(dont know what it is).
Code used is:
String formulaString = cell.getCellFormula();
System.out.println ("String value: " + formulaString);
Any help appreciated.
Brian
--
View this message in context:
http://www.nabble.com/Formula-value-contains-a-link---not-reading-properly-tp22165667p22165667.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
