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/>
