The LibreOffice documentation contains the following information.
If you want a data range of multiple cell areas that are not next to each other, enter the first range, then manually add a semicolon at the end of the text box, then enter the other ranges. Use a semicolon as delimiter between ranges.
I imagine that it can become challenging (or even unsafe) to edit a growing list of cell areas in the text field “Data range”.
* Would you like to present a better overview for a detailed selection?
* How do you think about to extend the graphical user interface for this purpose?
Thanks for reporting this issue. It seems like a dupe of bug 53300
*** This bug has been marked as a duplicate of bug 53300 ***
(In reply to Xisco Faulí from comment #1)
How do you think about safer graphical user interface adjustments (as suggested) since software difficulties were reported around an expand button on 2012-08-09?
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone
else confirms it.
Moving to NEW
(In reply to Markus Elfring from comment #0)
> * Would you like to present a better overview for a detailed selection?
> * How do you think about to extend the graphical user interface for this
If you are unable to answer your own questions, we have to ask the design team.
A1;B2 is an invalid range. When you talk about how to specify cells in general (for example =SUM($A1:$B2;C4;X46) ), there is a colored feedback when you press F2 (edit). And we decided on a similar suggestion to color the parts of the formula as WORKSFORME (bug 124102). Or do you are talk about just the chart wizard?
(In reply to Heiko Tietze from comment #6)
I came along usability concerns for the specification of distributed data ranges while fiddling with the chart wizard.
Further user interface extensions might become helpful also for other application areas.
Let's close this for now as duplicate of the issue the is WFM. If you have a concrete proposal feel free to reopen.
*** This bug has been marked as a duplicate of bug 124102 ***
(In reply to Heiko Tietze from comment #8)
How do you think about to manage multiple cell areas by a list widget for data ranges?
(In reply to Markus Elfring from comment #9)
> (In reply to Heiko Tietze from comment #8)
As you are referring to c8, I closed the ticket as duplicate to the request of coloring the formula bar where we decided to not do it.
> How do you think about to manage multiple cell areas by a list widget for
> data ranges?
I cannot follow you, "multiple cells" might be a data range or not, which in turn is activated per list, yes.
(In reply to Heiko Tietze from comment #10)
> I cannot follow you, "multiple cells" might be a data range or not, which in
> turn is activated per list, yes.
Can you imagine that a short input field can become insufficient for editing a growing list of cell areas in the text field “Data range”?
* Would you be looking for a bigger text input area?
* Will a list (or table) widget be occasionally safer for the management of entries (instead of separation by semicolons)?
I ignore these questions over questions and focus on the core of the issue: It's possible to define more than one region in a spreadsheet in the chart data ranges dialogs as described in the help. But this is only possible 'by hand' using a semicolon. It's not possible in the GUI with a button.
Adding a + and - button at the right end of the text field.
When clicking on + then a new row with a next text field will be showed where the user can define a new region. There is also a + and - button.
Clicking at one of these + adds a new text field directly below.
Clicking at one of these - deletes this whole text field row; if only the first text field exists then only the defined range will be deleted (the text field will be emptied).
We had this topic on the agenda of the weekly design meeting. Adding buttons would be effective at all cases with multi-selections not only charts. It wouldnt be clear how these +/- buttons work, in particular what is removed. And since manual editing is common I recommend again to close this ticket as WFM.
(In reply to Heiko Tietze from comment #13)
I hope that the corresponding user interface can be improved further.
(In reply to Heiko Tietze from comment #13)
> We had this topic on the agenda of the weekly design meeting. Adding buttons
> would be effective at all cases with multi-selections not only charts. It
> wouldnt be clear how these +/- buttons work, in particular what is removed.
> And since manual editing is common I recommend again to close this ticket as
I don't believe that it's so unclear. Tooltips will also help. I don't remember a similar implementation in another UI element but in the custom file properties dialog.
*** Bug 73226 has been marked as a duplicate of this bug. ***
As this is not only a new request, if anybody has new info or ideas to share, please reopen as Unconfirmed.