Hey Eric,
this is a Excel - File format?
LibreOffice do not use [..] or "!"
So, the right syntax should be:
=('file:///c:/path/to/file.ods'#$Tabelle1.D13)
And jey, you can work with copy & paste:
Open both Calc files
Select in source file the cell-range which should be connect - press
richt mouse button, hold button, press shift + Strg - draw mouse to
target - file an target cell - release buttons.
That´s it :)
Best regards
Thomas
Am 23.08.2016 um 15:39 schrieb E. Mommsen:
Hi
I'm using LO 5.1.4.2 64bit on Windows.
When I insert a formula with a reference to an external file into a
cell, err:507 ("Fehler in Klammerung") or err:520 is displayed in the
cell. The formula seams to be correct:
=['file:///c:/path/to/file.ods']tablename!d13
Insertion by mouse-click or copy&paste does not make any difference.
Local references within the same file work correctly.
I just upgraded from 4.4. Is there a stable version 5 of LibreOffice
without this error?
Best regards, Eric
--
Liste abmelden mit E-Mail an: discuss+unsubscr...@de.libreoffice.org
Probleme?
http://de.libreoffice.org/hilfe-kontakt/mailing-listen/abmeldung-liste/
Tipps zu Listenmails: http://wiki.documentfoundation.org/Netiquette/de
Listenarchiv: http://listarchives.libreoffice.org/de/discuss/
Alle E-Mails an diese Liste werden unlöschbar öffentlich archiviert
