Re: [de-discuss] cals: file references in formulas do not work

Hallo E. Mommsen,

am 23.08.2016 um 15:39 Uhr schrieb E. Mommsen <emommsen@arcor.de>:

> 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

Here another Syntax works for me:

='file:///E:/path/to/file.csv'#$'tablename'.A2

In my case it's a csv-file, but I think it should also work with
ods-files.

> Best regards, Eric

-- 
 ..... und tschüss

               Franklin

-- 
Liste abmelden mit E-Mail an: discuss+unsubscribe@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