Which version of POI? Are you using the latest POI-3.8 ? A similar issue was fixed in r1242701 committed on Feb 10: http://svn.apache.org/viewvc?view=revision&sortby=date&revision=1242701
The origin is https://issues.apache.org/bugzilla/show_bug.cgi?id=49896 At least, we have a unit test that proves that full path inside VLOOKUP is preserved and POI returns you formulas like this: "VLOOKUP(A2,'[C:Documents and Settings/Yegor/My Documents/csco.xls]Sheet1'!$A$2:$B$3,2,FALSE)" Your case looks similar, so I suspect you are using an older version of POI. Yegor On Wed, Apr 4, 2012 at 3:21 PM, Mark Coleman <[email protected]> wrote: > Hello, > > I have a cell which references another cell in another spreadsheet. The > formula looks like this when I view it in Excel... > > *='M:\Improvements\Spreadsheet Scanner\Spreadsheet > Scanner\test_data\[C.xls]Sheet1'!$A$1* > > ...however when I use getCellFormula() the following is returned... > > *[C.xls]Sheet1!$A$1* > > Somehow I'm losing the path. Is this the intended behaviour? If so, how can > I get the path? If not, what am I doing wrong? > > Kind regards, > > -- > > > Mark Coleman > uGly Duckling B.V. > Burgemeester le Fevre de Montignylaan 30 > 3055LG Rotterdam, the Netherlands > > KvK nummer: 52272125 > BTW nummer: NL850371570B.01 > Rabobank: 14.68.33.473 > E: [email protected] > M: +31 (0) 646347972 > W: http://uGlyDuckling.nl <http://www.uglyduckling.nl/> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
