Bug 96230

Summary: Data points on charts show wrong value when x-axis is reversed
Product: LibreOffice Reporter: justreportingabug <2bife7+78jkcxy0kit8g>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: miguelangelrv, tidy.year3335
Priority: medium    
Version: 5.0.3.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 90486    
Attachments: odt document with a chart that has date data with newest at top shows data points in wrong order

Description justreportingabug 2015-12-03 15:16:54 UTC 
If the X-Axis option "Reverse direction" is checked OR the X-Axis data type happens to cause the chart x-axis data set to be resorted THEN the Y-point data displayed while hovering the mouse over a data point shows the wrong value. 

It appears it to show a while value based on the original sorting of the the x-axis data set.

STEPS TO REPRODUCE
1. Create a chart based of any x-y data set.
2. Format the X-Axis and select "Reverse direction" click OK.
3. Hover the mouse over a data point.

OR  

1. Create a data set based on dates that are sorted newest at top.
2. Create a chart based on the date data set as the x-axis. 
2. Format the X-Axis and set the Type to Date.
3. Hover the mouse over a data point.
Comment 1 justreportingabug 2015-12-03 15:22:57 UTC 
Created attachment 120996 [details]
odt document with a chart that has date data with newest at top shows data points in wrong order
Comment 2 m_a_riosv 2015-12-03 23:28:31 UTC 
Reproducible.
Win10x64
Version: 5.0.4.1 (x64) Build ID: 2def61bcbb29a7a8611b833682fe1291910b11ad

Changing the interpretation for X-axis from Date to Text then works fine.
When as Date it take the same order of the data not the Date order.
Comment 3 QA Administrators 2017-01-03 19:41:30 UTC Comment hidden (obsolete)
Comment 4 Roman Kuznetsov 2019-02-26 17:33:50 UTC 
still repro in

Version: 6.3.0.0.alpha0+
Build ID: b45289e48e0f354b9996e2846dd041db4a9947ce
CPU threads: 4; OS: Linux 4.18; UI render: default; VCL: kde5; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-02-08_12:51:03
Locale: ru-RU (ru_RU.UTF-8); UI-Language: en-US
Calc: threaded
Comment 5 QA Administrators 2021-02-26 04:11:22 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2023-02-27 03:20:06 UTC Comment hidden (obsolete)
Comment 7 Stéphane Guillou (stragu) 2023-05-15 16:29:12 UTC 
*** Bug 155290 has been marked as a duplicate of this bug. ***