[Libreoffice-bugs] [Bug 136160] New: Chart displays incorrectly, but, if I double-click on it to edit, it then displays correctly (EDITING)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 136160
           Summary: Chart displays incorrectly, but, if I double-click on
                    it to edit, it then displays correctly (EDITING)
           Product: LibreOffice
           Version: 6.3.6.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: stuart.soloway at ieee.org

Description:
If you look at the chart titled "7-day average of %positive"at the bottom right
of the sheet named "Graphs" you will notice that the graph shows values
approximately equal from about date 8-06 to 8-25.  This is incorrect!  

To figure out what had gone wrong, I double-clicked on the chart to edit the
ranges.  Lo and behold, the chart changed and displayed the correct data!  Then
when I clicked somewhere else to get out of edit-mode, it went back to
displaying the wrong data.  This happens consistently and repeatedly.  I
finally fixed the problem by cutting and pasting the chart somewhere else,
deleting the original chart, and moving the new version back to where the
original chart was.
The data for the chart is on sheet "covidtracking.com data", the third sheet.  
The way I got into this mess was this:

1) I mucked up the data for 08-06 (more or less) to 08-25.  At that point the
chart was consistent and displayed exactly what it shows now.  
2) Then I corrected the data by dragging a formula down from about B300 to
populate the rest of the column.
3) At this point, I noticed that the chart hadn't changed, even though the data
had.
4) I double-clicked on the chart to edit it, and the chart changed to display
the correct data.  But as I said above, when I left edit-mode the chart somehow
remembered the old, bogus data and displayed that. 

Steps to Reproduce:
1.Just take my error.xlsx file and double-click on the "7-day average of
%positive" chart, the last one on the sheet named "graphs".
2.Then click somewhere else.


Actual Results:
The chart goes back and forth from displaying the correct data (when in
edit-mode) and displaying the incorrect data (when not in edit-mode)

Expected Results:
See above; the chart went back-and-forth between displaying the wrong data and
displaying the correct data.


Reproducible: Always


User Profile Reset: No



Additional Info:
It should have displayed the correct data consistently in the chart.

Info from "About LibreOffice":
Version: 6.3.6.2 (x64)
Build ID: 2196df99b074d8a661f4036fca8fa0cbfa33a497
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

-- 
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/20200826/76227795/attachment.htm>