Am 12.02.2011 15:23, Cor Nouws wrote:
plino wrote (12-02-11 11:59)
OpenOffice and LibreOffice use absolute paths
='file:///C:/Source.ods'#$Sheet1.B2
while Excel uses relative paths
This is not correct. OOo/LO show an absolute path. But you can choose it
to be absolute or relative:
Tools > Options > Load/save > General, section Save > relative to file
system ..
Best,
Cor
This does not apply to external links.
=MID(CELL("Filename");2;SEARCH("/[^/]+'#";CELL("Filename"))-1) [with
regexes enabled in the Calc options] gets the document path. This can be
used with some concatenation and INDIRECT.
--
Unsubscribe instructions: E-mail to [email protected]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***
