Bug 101509 - Incorrect date category labels in line chart
Summary: Incorrect date category labels in line chart
Status: RESOLVED DUPLICATE of bug 85493
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
3.4.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Chart-Labels
  Show dependency treegraph
 
Reported: 2016-08-13 19:52 UTC by Mark_T2016
Modified: 2023-10-05 13:29 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example incorrect date category labels (20.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-08-13 19:52 UTC, Mark_T2016
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Mark_T2016 2016-08-13 19:52:44 UTC
Created attachment 126819 [details]
Example incorrect date category labels

If a line chart is created from data in columns where a date category column is in descending order then the category labels in the chart will be incorrectly assigned to the data points.

Same occurs even when category labels are not displayed, after double click in chart for edit mode, hovering over the data points shows incorrect category date and also shows incorrect data value.

Reverse direction of scale does not correct the problem.

Attached example of incorrect and correct date category labels.
Comment 1 m_a_riosv 2016-08-13 22:58:51 UTC Comment hidden (obsolete)
Comment 2 Mark_T2016 2016-08-14 01:56:40 UTC
Tested with LibreOffice_5.2.1.1_Win_x64.msi, still shows the problem reported.

I also tried re-creating the chart in a new spreadsheet, but with the same result as reported.
Comment 3 Mark_T2016 2016-08-14 01:59:28 UTC
I'm testing with Windows 8.1.
Comment 4 m_a_riosv 2016-08-14 13:05:53 UTC
You are right, sorry.

Seems inherited from OOo.
Reproducible with
LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
Comment 5 QA Administrators 2017-09-01 11:19:38 UTC Comment hidden (obsolete)
Comment 6 m_a_riosv 2020-04-09 11:14:27 UTC
Still
Version: 7.0.0.0.alpha0+ (x64)
Build ID: 95ec2e9b024ff12a3005777c902d7e0975460b1d
CPU threads: 4; OS: Windows 10.0 Build 19592; UI render: Skia/Raster; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US
Calc: CL
Comment 7 m_a_riosv 2020-04-09 11:15:15 UTC
Labels are not sorted like the x values.
Comment 8 QA Administrators 2022-04-10 03:35:57 UTC Comment hidden (obsolete)
Comment 9 Stéphane Guillou (stragu) 2023-10-05 13:29:52 UTC
(In reply to m.a.riosv from comment #4)
> Seems inherited from OOo.
> Reproducible with
> LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4

Not quite inherited as the Date option for the X axis was only available since 3.4. If you open the file in OOo 3.3 and enter edit mode, the X axis order changes.

Same issue as described in earlier bug 85493, so marking as duplicate.

Thank you all!

*** This bug has been marked as a duplicate of bug 85493 ***