https://bugs.documentfoundation.org/show_bug.cgi?id=53300

--- Comment #20 from Gavin D <sirgawai...@yahoo.com> ---
This problem appears to be unresolved after four and a half years since it was
first reported! I have tested LibreOffice Calc v5.1.3.2 on Linux Mint 17.3
64-bit, and v5.2.0.1 on Windows 7 Professional 64-bit. At the risk of
redundancy, allow me to detail the steps to reproduce the condition:

1.) Double-click a chart to edit it.
2.) Right-click the chart and select Data Ranges...
3.) On the Data Series tab, click the minimize icon next to the Categories
field.
4.) Select any cell, and the "Select Range for Categories: Area" dialogue
automatically expands to the main "Data Ranges" dialogue, preventing any
further selection.

In order to add more cells to the range, the minimize button must be clicked
again, the cursor moved to the end of the line to deselect its current content,
a semi-colon added (or a comma, in my case), and the next desired cell
selected. Rinse and repeat...

Is it difficult to remove the line of code that forces the selection dialogue
to expand on lifting the mouse button? Manually adding a delimiter on
selection, instead of its automatic addition, as performed by other spreadsheet
programs, is not a major issue, but navigating the entire multi-click process
for every cell required is extremely laborious on large spreadsheets.

Finally (this should probably be submitted on it's own bug report), there is no
way to exit the chart editing dialogue without the chart being updated with the
new selection. It doesn't matter whether the OK, Cancel or Close (X) button is
clicked, or the dialogue is closed by means of the Escape key, the newly
selected, potentially erroneous data range appears on the chart. And, there is
no undo function that reverses the mess!

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to