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: RESOLVED DUPLICATE of bug 114994
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 tree / graph
 
Reported: 2018-10-14 16:50 UTC by Roman Kuznetsov
Modified: 2023-03-30 21:47 UTC (History)
6 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
View All Add an attachment (proposed patch, testcase, etc.)

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).
Comment 10 Roman Kuznetsov 2021-08-25 10:23:29 UTC 

*** This bug has been marked as a duplicate of bug 114994 ***