Re: [libreoffice-users] Re: Automatic updating of a cell from one spreadsheet to another doesn't work

I'm not getting anything like that when I try. I'll try with a new user
account. Maybe there's something wrong with a configuration file. Then I'll
try a few other things. Now that I know what a good link looks like.

Thanks!

I may be back for more help. If these things don't work and a clean install
on a different PC doesn't either. Now at least I can diagnose the condition.

On Fri, Jul 3, 2015 at 12:57 PM, Andreas Säger <villeroy@t-online.de> wrote:

> Am 02.07.2015 um 19:49 schrieb QC:
> > 19) It doesn't work. No path to the document.
>
>
> When I copy&paste-special a range of cells with link option, LibreOffice
> creates an external reference like
> 'file:///path/document.ods'#%SheetX.$A$1:$F$9 as an array formula. Same
> when I use the mouse pointer to mark a reference in another spreadsheet
> window.
> Apache OpenOffice still creates DDE links from the paste-special
> operation and file:/// links from the pointer operation.
>
> A valid DDE link looks like this:
> =DDE("soffice","C:\PATH\document.ods";$SheetX.$A$1:$F$9)
> The path-name is in system notation and not URL notation.
>
>
> --
> 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

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