Bug 96230 - Data points on charts show wrong value when x-axis is reversed
Summary: Data points on charts show wrong value when x-axis is reversed
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 155290 (view as bug list)
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2015-12-03 15:16 UTC by justreportingabug
Modified: 2023-05-15 16:29 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
odt document with a chart that has date data with newest at top shows data points in wrong order (19.98 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-12-03 15:22 UTC, justreportingabug
Details

Note You need to log in before you can comment on or make changes to this bug.
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. ***