Bug 97185 - Links to external cells not works
Summary: Links to external cells not works
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-01-16 15:19 UTC by MatthiasRw
Modified: 2016-01-17 14:05 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description MatthiasRw 2016-01-16 15:19:53 UTC
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
Comment 1 FutureProject 2016-01-17 01:12:03 UTC
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)
Comment 2 MatthiasRw 2016-01-17 13:00:30 UTC
Hi all,

this was it! Now it works perfect.
The problem is solved.

Thanks for your work!
All the best.
Matthias
Comment 3 FutureProject 2016-01-17 14:05:09 UTC
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!