Bug 120910 - Link to External data: impossible to link the other .ods document in LO Calc
Summary: Link to External data: impossible to link the other .ods document in LO Calc
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Calc-External-Datalink
  Show dependency treegraph
Reported: 2018-10-25 13:18 UTC by Vera Blagoveschenskaya
Modified: 2018-10-26 22:03 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

screen (120.20 KB, image/png)
2018-10-25 13:19 UTC, Vera Blagoveschenskaya

Note You need to log in before you can comment on or make changes to this bug.
Description Vera Blagoveschenskaya 2018-10-25 13:18:32 UTC
Link to External data: impossible to link the other .ods document in LO Calc

Steps to Reproduce:
I want to link two .ods documents: test1.ods and test2.ods

1. In test1.ods click Sheet -> Link to External data
2. In External Data dialog select document you want to link via button Browse
3. Document is selected, but Button OK is disabled

Actual Results:
OK is disabled, impossible to link the other .ods document

Expected Results:
Possibility to link .ods document
(BTW .csv is linked normally)

IF .ods linking is not supported, I expect some user warning about it

Reproducible: Always

User Profile Reset: No

Additional Info:
Reproduced for 

Build ID: 25af42bc70e1a0a61d2ea90d7b0ef1ed6000ed69
CPU threads: 1; OS: Linux 4.14; UI render: default; VCL: kde5; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2018-10-23_18:02:41
Locale: ru-RU (ru_RU.UTF-8); Calc: threaded

Also, there is a problem to link with .odt document: I can't select it in the Dialog window
Comment 1 Vera Blagoveschenskaya 2018-10-25 13:19:16 UTC
Created attachment 145999 [details]
Comment 2 Roman Kuznetsov 2018-10-26 22:03:05 UTC
from Calc Help:

Inserts data from an HTML, Calc, CSV or Excel file into the current sheet as a link. >>>The data must be located within a named range.<<<

If you have named range in your test2.ods, then you will see range name in dialog "External Data" in field Available tables/ranges

Status -> NOTABUG