Re: [libreoffice-users] Re: relative HYPERLINK

On 08/15/2012 01:21 PM, chilobo wrote:
> Andreas Säger wrote
> > You can not misuse a spreadsheet like this and expect that it works in 2
> > applications. Things may change if Excel 13 really provides full ODF
> > support but nobody believes that MS will go that far.
> > Needless to say that no spreadsheet application will ever work like a
> > database.
> > This would be very easy to implement with a Base database and a few
> > lines of macro code.
> I know that, ultimately we will transfer our data to a database. But during
> the process of entering data it is easier for the different users to use the
> well-know spreadsheet software :)
>
> Anyway: Shouldn't Calc be able to work with relative hyperlinks correctly?
I am puzzled by the sharing of the spreadsheet. Are the files stored on 
a server with a fixed location or they passed out to users to install 
locally?

Also, I would try setting up the linked files in a sub-folder of the 
spreadsheet folder. If the the spreadsheet is in folder Project the 
sub-folder would be Project/Files

See the following from the LO help

 *

   The following rules apply: A relative reference
   ("graphic/picture.gif") is only possible when both files exist on
   the same drive. If the files are on different drives in your local
   file system, the absolute reference follows the "file:" protocol
   ("file:///data1/xyz/picture.gif"). If the files are on different
   servers or if the target of the link is not available, the absolute
   reference uses the "http:" protocol ("http://data2/abc/picture.gif";).

> --
> View this message in context: 
> http://nabble.documentfoundation.org/relative-HYPERLINK-tp4001526p4001573.html
> Sent from the Users mailing list archive at Nabble.com.


--
Jay Lozier
jslozier@gmail.com


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted