1. I had insert a link to an external cell as described in the LibreOffice help (https://help.libreoffice.org/Calc/Referencing_a_Cell_in_Another_Document -> To Reference a Cell in Another Document) 2. The automatically created syntax in the target cell was now: =['file:///path/filename.ods']SheetName!A1 3. But this generates the Err507 (error in the parentheses). Which parentheses? 4. I corrected it to the syntax, that described on the website (see 1.) ='file:///path/filename.ods'#SheetName.A1 5. Now I get the error "#NAME?" Which name? 6. For testing I replaced the "#" with "." ='file:///path/filename.ods'.SheetName.A1 7. Now I get the Err509 (missing operator) Which operator? What am I doing wrong? WHY DOES IT ALL NOT WORK? Thanks for your help an best regards Matthias
Hello, and thank you for bringing this issue to our attention. Sadly, I could not reproduce the behaviour you described. Have you tried resetting your user profile < see: https://wiki.documentfoundation.org/UserProfile#Resolving_corruption_in_the_user_profile > yet? That can sometimes fix any weirdness going on. If this doesn't help, please consider updating Libre Office to the newest version < see: http://www.libreoffice.org/download/libreoffice-fresh/ >. Please let us know if any of this helped fix the issue. -- Windows 10 Pro, Version 1511 (OS Build 10586.36) Version: 5.0.3.2 (x64) Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75-GL Locale: de-DE (de_DE) Version: 5.0.4.2 Build ID: 2b9802c1994aa0b7dc6079e128979269cf95bc78 Locale: de-DE (de_DE) Version: 5.1.0.2 (x64) Build ID: ecd3574d51754b043f865cf5bafee286d24db7cc CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Locale: de-DE (de_DE)
Hi all, this was it! Now it works perfect. The problem is solved. Thanks for your work! All the best. Matthias
I'm glad everything works for you now. I'm changing the status to RESOLVED WORKSFORME though, because FIXED is reserved for other purposes. Have a nice day!