Bug 114997 - No visual indication as to where Linked External Data was imported
Summary: No visual indication as to where Linked External Data was imported
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.4.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Enhancements Calc-External-Datalink
  Show dependency treegraph
 
Reported: 2018-01-14 07:36 UTC by Dan Dascalescu
Modified: 2018-05-23 17:28 UTC (History)
2 users (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 Dan Dascalescu 2018-01-14 07:36:19 UTC
Description:
Once the user manages to Link External Data (a non-trivial task, see bug 114994, bug 114995, bug 114996, and finally bug 100993), there is no way to tell what ranges of the sheet have imported data.

This means the user can inadvertently edit data in a cell that's part of an imported range, and their data will be lost when the link is updated.

Steps to Reproduce:
1. Sheet -> Link to External Data
2. Paste the URL of an HTML file with table(s)
3. Import the data

Actual Results:  
Externally-linked data looks just like verbatim data in the sheet.

Expected Results:
There should be a visual indication around the imported data, to highlight that it is subject to change.


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36
Comment 1 Buovjaga 2018-02-11 13:33:56 UTC
Repro with Edit - Links to external.. - Update
attachment 139782 [details] can be used for quick testing

Let's ask UX
Comment 2 Eike Rathke 2018-02-15 17:11:22 UTC
Better would be to add some combination of URI and table/range name (polished and de-duplicated) to the defined database ranges, with the benefit that the data range would be selectable and addressable as usual. The tricky part would be to "link the link" for storage and adjust the resulting database range on each update of the linked data, which can happen even time based, but there's already code for updating the range for other database sources.

Future features then could associate a (real) table style with such defined database ranges.
Comment 3 Heiko Tietze 2018-02-16 10:37:30 UTC
(In reply to Eike Rathke from comment #2)
> Better would be to add some combination of URI and table/range name
> (polished and de-duplicated) to the defined database ranges, with the
> benefit that the data range would be selectable and addressable as usual.

Absolutely, today you don't even see the difference between direct input and what comes from an external source when editing the field. And when the user edits the field manually this change is overridden in case of automatic update. Would expect Edit > Link(s) to External Data to open when I press F2 but only for cells with those links and not when cells are empty.

We could lock these cells somehow as a first step. But additionally it would be nice to see (temporarily) the state of cells. Similar request was made in bug 115241 about conditional formatting. We could show some indicator for the various options like Excel's triangle but with a nicer icon.