References to external files - relative vs full path - WAS Re: [libreoffice-users] Re: Calc - blank cell not treated as 0 in formula when referenced from external file/sheet

Thanks Miguel, but...

I was thinking more of how to do this in the formula itself.

Using this option - which apparently is enabled by default since mine
was, and upon testing, I discovered the reference is indeed relative.

But, this is confusing - when looking at the formula, it shows the full
path to the file.

So, it appears there is no way to use full paths in one document, and
relative paths in a different document?


On 1/17/2017, 5:20:53 PM, m.a.riosv <miguelangelrv@libreoffice.org> wrote:
> Set up references as relative path is on:
>
> Menu/Tools/Options/LibreOffice/Load-Save/General
>
> Miguel Ángel.


-- 
To unsubscribe e-mail to: users+unsubscribe@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