[Libreoffice-bugs] [Bug 118040] New: Inadequate error handling in pie charts UI: EDITING the data range can cause the diagram to disappear

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 118040
           Summary: Inadequate error handling in pie charts UI: EDITING
                    the data range can cause the diagram to disappear
           Product: LibreOffice
           Version: 5.4.3.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: albrecht.mueller at astrail.de

Description:
Innocent looking changes in the data range of a pie chart can make the diagram
to disappear. This is pretty surprising, cannot be undone and can lead to data
loss.

Steps to Reproduce:
Open a new spreadsheet in Calc. Fill cells A1:A7 with letters A ... G and cells
B1:B7 with the numbers 1 ... 7. Using CTRL+Click select cells A1, B1, A3, B3
and A5, B5. Use Insert -> Chart to start the chart wizard. Choose the chart
type "Pie".  You should see a pie chart with a legend showing the letters A, C,
E. Press "Finish" to close the wizard. Click somewhere outside the newly
generated chart. 

Edit the chart - e.g. select the chart again, get the context menu and choose
"Edit".  Choose Format -> Data Ranges. Click at the button right to the "Data
range" input field. A dialogue box titled "Data Range: Area" appears that
allows you to define the data range. Click on Cell B7. The intention is to add
an additional entry to the chart. Actually this reduces the range to the single
cell B7.

Actual Results:  
The content of the Chart disappears. Press ok. The chart is now a single white
rectangle. Click outside this rectangle: The chart is gone. Look at Edit ->
Undo: You cannot undo the change that caused the problem, the undo action is
"Undo: Insert embedded object (OLE)".

This behaviour caused data loss. I had a speadsheet containing this kind of
charts. While entering new data into this document I wanted to include the
contents of an additional cell in the chart. After changing the data range
accordingly the diagram changed to a white rectangle. Undo did not work. I saw
only two options: Save the document in its current state. The diagram is lost.
Or: Reload the document without saving. This saves the diagram but discards the
data I entered.

Expected Results:
It should be possible to undo the change in the data range to restore old state
of the diagram.

The UI should either 
- refuse the change and give a clear reason why it does not accept the change.
It also should inform the user about acceptable options for changing data
ranges. E.g. it is not possible to change compound data ranges using the mouse
selection mechanism? This kind of change requires entering the range in text
form.

or

- show some reasonable chart, e.g. one consisting of a single piece for the
selected cell in order to allow the user to examine the unintended change.



Reproducible: Always


User Profile Reset: No



Additional Info:
Observed with

Version: 5.4.3.2 (x64) Build ID: 92a7159f7e4af62137622921e809f8546db437e5 CPU
threads: 4; OS: Windows 6.1; UI render: default;  Locale: de-DE (de_DE); Calc:
group

and

Version: 6.0.4.2 (x64) Build ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf CPU
threads: 4; OS: Windows 6.1; UI render: default;  Locale: de-DE (de_DE); Calc:
group

BTW: The form I used to submit the bug contains a check box asking if OpenGL is
enabled. In the "Options" dialogue I did not find such an option, but there are
 OpenCL options. According to my knowledge these are different things. Is this
a typo or did I miss LibreOffice's OpenGL options?



User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:60.0) Gecko/20100101
Firefox/60.0

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180606/2024316b/attachment.html>