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).
User should know, that he needs push key Enter for getting list of available table/range in source. It's not obvious
Users will see button with "speaking" name and they will be know how get list of tables/ranges without Help
User Profile Reset: No
Created attachment 145710 [details]
New dialogue External Data
Created attachment 145711 [details]
Source for mockup (Pencil)
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.
(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.
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.
Created attachment 145726 [details]
MockUp. External Data w button Update
(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
(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).