Bug Hunting Session
Bug 120591 - Add button to load or refresh the table and ranges in the external data dialog
Summary: Add button to load or refresh the table and ranges in the external data dialog
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: UI (show other bugs)
Version:
(earliest affected)
6.2.0.0.alpha0+
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Dialog-UX
  Show dependency treegraph
 
Reported: 2018-10-14 16:50 UTC by Roman Kuznetsov
Modified: 2019-06-13 14:36 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
New dialogue External Data (39.00 KB, image/png)
2018-10-14 16:51 UTC, Roman Kuznetsov
Details
Source for mockup (Pencil) (8.24 KB, application/gzip)
2018-10-14 16:52 UTC, Roman Kuznetsov
Details
MockUp. External Data w button Update (28.44 KB, image/png)
2018-10-15 14:10 UTC, Roman Kuznetsov
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2018-10-14 16:50:00 UTC
Description:
Improvement of dialogue External Data in Calc from menu Sheet->Link to external Data.
To get list of tables/ranges from external source we should enter source address in text field and push key Enter on keyboard. It's not obviousy for users.
I offer add new button "Show table/range" in to dialogue (see attach).

Steps to Reproduce:
1. I offer add new button "Show table/range" in to dialogue External Data in Calc (see attach).


Actual Results:
User should know, that he needs push key Enter for getting list of available table/range in source. It's not obvious

Expected Results:
Users will see button with "speaking" name and they will be know how get list of tables/ranges without Help


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Roman Kuznetsov 2018-10-14 16:51:41 UTC
Created attachment 145710 [details]
New dialogue External Data
Comment 2 Roman Kuznetsov 2018-10-14 16:52:21 UTC
Created attachment 145711 [details]
Source for mockup (Pencil)
Comment 3 m.a.riosv 2018-10-14 20:34:54 UTC
Agree.
Comment 4 Heiko Tietze 2018-10-15 10:35:24 UTC
Why don't we load the tables a source has been selected (dropdown closed or file selected)?

If there a refresh is needed sometimes we could also add a smaller button right of the caption.
Comment 5 Eike Rathke 2018-10-15 10:44:41 UTC
(In reply to Heiko Tietze from comment #4)
> Why don't we load the tables a source has been selected (dropdown closed or
> file selected)?
One can enter an arbitrary URL as source (in fact the most common use case), then no dropdown nor file selection is involved.
Comment 6 Heiko Tietze 2018-10-15 10:51:52 UTC
So my take is to add the button as Roman suggests but a little bit less obtrusive next to the label. The button could be labeled "Refresh". If possible, the contained tables should be loaded automatically.

That's likely an easyhack.
Comment 7 Roman Kuznetsov 2018-10-15 14:10:42 UTC
Created attachment 145726 [details]
MockUp. External Data w button Update
Comment 8 Roman Kuznetsov 2018-10-15 14:11:11 UTC
(In reply to Roman Kuznetsov from comment #7)
> Created attachment 145726 [details]
> MockUp. External Data w button Update

but I don't like this solution
Comment 9 Heiko Tietze 2018-10-16 14:49:34 UTC
(In reply to Roman Kuznetsov from comment #8)
> (In reply to Roman Kuznetsov from comment #7)

My suggestion results from the stack of button/label with the same caption. So the idea was to place the "Refresh" button right of the label (and disable it when not appropriate, ie. URL source, and trigger the click on spreadsheets or the like to not always need the click).