You could use the following methods published by an expert Spreadsheet
user on the forum:
[quote]
Some named refs from my default template. No macros,
platform-independant and they should work with Excel as well:
cFilename =CELL("FILENAME")
FilePath =RIGHT(FileURLPath;LEN(FileURLPath)-7)
FileURL =MID(cFilename;2;SEARCH("'#";cFilename)-2)
FileURLPath =MID(cFilename;2;SEARCH("/[^/]+'#";cFilename)-1)
shSep =MID(ADDRESS(1;1;1;"Foo");4;1)
ThisSheet =MID(cFilename;FIND("#$";cFilename)+2;256)
shSep returns "." in Calc and "!" in Excel (useful with indirect() or
pattern matching with/without regular expressions).
"FilePath" with Windows: =SUBSTITUTE(FilePath;"/";"\")
[end quote]
Bob Treder wrote:
It looks like this is still broken in OO 2.0.3. I'm developing some training
materials in Impress and badly need relative paths to make passing of
materials work from wherever they are installed. Does anyone have a
suggestion on how to work around this? Everytime I create the link in
Impress, even with the two boxes checked that a mentioned in the messages
below the full path gets saved.
Thanks for any help you can provide.
Bob Treder
[EMAIL PROTECTED]
Date: Mon, 5 Jun 2006 09:57:42 -0700
From: Rodney D. Myers <[EMAIL PROTECTED]>
Content-Type: multipart/signed; boundary="Sig_RY+snYxoFX/W7QmyJSBI9Fk";
protocol="application/pgp-signature"; micalg=PGP-SHA1
Subject: Re: [users] Open Office relative path vs. hard coded path. OO 2.0.1
is broke
On Mon, 5 Jun 2006 11:28:22 -0500
Dan Lewis <[EMAIL PROTECTED]> wrote:
On Monday June 5 2006 11:15 am, Rodney D. Myers wrote:
I'm running Debian etch, and OO 2.0.1
In moving OO documents from a Linux computer to an Apple laptop. I've
found something odd, when trying to link info among spreadsheets.
On the laptop, I can put the "relative" path, using "./" to get the
linking to work, yet n this Linux computer I have to specify the full
path to get the linking to work.
Yet, when I open the same documents in OO 1.1.3 things work as they are
supposed to.
I always "assumed" that this was not necessary, but just using the "./"
would suffice. Am I wrong or am I missing something?
Thanks
On the Linux computer, have you set your options to use "relative"
path? It is in Tools > Options > Load & Save > General. Make sure you have
the "File system" box checked under "Save URLs relative to". It probably
is not. If you checked the Apple laptop for the same information, this box
is probably checked.
Dan
It is.
As an update, I'm trying to use DDE as the linking to other
spreadsheets, as listed;
=DDE("soffice";"./bar_payouts2006.sxc";"May.I55")
This works under Linux OO 1.1.3, and OS X neo office 1.2.2 (I think
that's their revision #)
Yet I open the same spreadsheet under Linux OO 2.0.1 & OS X Neo Office
2.*.*, and the linking is broke.
Tools -> Options -> Load/Save -> Save URL's relative to;
filesystem & internet are checked, as on the OS X computer.
--
If you're seeking, check out http://www.rci.org.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
