Bug 65878 - FORMATTING: date points in chart don't match gridlines
Summary: FORMATTING: date points in chart don't match gridlines
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA target:7.0.0
Depends on:
Blocks: Chart-Enhancements
  Show dependency treegraph
Reported: 2013-06-18 02:16 UTC by bugquestcontri
Modified: 2023-10-05 09:33 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

test file with charts and explanations (23.08 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-06-18 02:16 UTC, bugquestcontri
excel chart (49.46 KB, image/png)
2014-11-22 09:44 UTC, raal
screenshot made in Libo (36.58 KB, image/png)
2014-11-24 13:06 UTC, bugquestcontri
Screenshot comparing OOo 3.3 and LO 7.1 (198.15 KB, image/png)
2023-10-05 09:32 UTC, Stéphane Guillou (stragu)

Note You need to log in before you can comment on or make changes to this bug.
Description bugquestcontri 2013-06-18 02:16:41 UTC
Created attachment 80976 [details]
test file with charts and explanations

Problem description: 
Position of data points in charts don't match position
Identification of single data points very difficult.
Chart is not correct.

Steps to reproduce:
1. Create a new chart
2. click x-axis
3. select Insert Major Grid
4 compare position of data points and major grid lines

Current behavior:
Data points are off of he major grid lines

Expected behavior:
Data points position should be on the grid lines 
Operating System: Windows XP
Version: release
Comment 1 bugquestcontri 2013-06-18 02:17:33 UTC
I observed the same in LibO
Comment 2 m_a_riosv 2013-06-18 21:59:50 UTC
Hi bugquestcontri,

data point coincides midpoint of the label, for all dates.

You can change the Scale type to text for x-axis to see like you want.

I think it is not a bug, if you are  not agree, please REOPEN it.
Comment 3 bugquestcontri 2013-06-19 02:40:34 UTC
I agree that with TEXT the lines match with the data points. 

However, in my real file I need start my x-axis with 01-Jan-2012 and need to set scale to DATE. (I forgot to make this setting in the sample file thus it was on AUTOMATIC) Therefore I still regard it as a bug. 

Actually in all charts the data point need to match with the grid line and this independent of the setting AUTOMATIC, TEXT or DATE. This has to do with the fact that in 2-dimensional chart a data point has an x and y coordinate.

Also this means we unfortunately have a bug.

I only did not observe this bug for year (usage of LibO) because I never needed to identify a certain point but only see a trend. Once one needs to identify a certain point(s) to understand e.g. seasonal trends, one needs to able to clearly see data point on the grid lines.

I hope that the settting WONTFIX is the correct one to REOPEN a bug.

Comment 4 bugquestcontri 2013-06-19 02:45:08 UTC
I just found the left status field and changed it to REOPEN. See my comment above for details
Comment 5 Joel Madero 2014-11-06 22:03:31 UTC
Need independent confirmation from QA - moving to UNCONFIRMED.
Comment 6 bugquestcontri 2014-11-08 14:08:39 UTC
I made the same in v and observed he same off-set of a data point from the vertical grid line.
Comment 7 raal 2014-11-22 09:44:17 UTC
Created attachment 109841 [details]
excel chart
Comment 8 raal 2014-11-22 09:45:03 UTC
Setting as enhancement.
Comment 9 bugquestcontri 2014-11-24 13:06:38 UTC
Created attachment 109939 [details]
screenshot made in Libo

raal`s comment made me doing a test again in v4.3.4.1. The red lines are showing where I expect the grid line to be. 

Comment 10 Regina Henschel 2017-10-14 16:30:01 UTC
In LibreOffice the labels are always between the ticks. Excel lets the user decide, whether the label is on the tick or between the ticks. Such feature is missing in LibreOffice.
Comment 11 Regina Henschel 2023-07-10 15:18:58 UTC
The feature is implemented in the meantime and will be available in LibreOffice version 7.6. You can already test a pre-release from https://dev-builds.libreoffice.org/daily/libreoffice-7-6/
The release will be end of August.
Comment 12 Stéphane Guillou (stragu) 2023-10-05 09:32:30 UTC
Created attachment 190037 [details]
Screenshot comparing OOo 3.3 and LO 7.1

The original issue described by bugquestcontri (the apparent misalignment because labels are aligned with data points rather than the tick marks grids) is resolved since LO 7.0. See attached screenshot comparing OOo 3.3 (left) and LO (right).

Bibisected the fix with linux-64-7.0 repo to:

commit ed2c880a691a0b179bbc92a8ce4ee49eac004035
author	Tünde Tóth <tundeth@gmail.com>	Thu May 21 10:20:43 2020 +0200
committer	László Németh <nemeth@numbertext.org>	Mon May 25 13:41:49 2020 +0200
tdf#133005 Chart: fix ODF import of date axis position
Chart with date axis setting "On tick marks" wasn't
imported correctly.
See commit 40d83914d43f60a196dfabddea0b52e2046b333a
(tdf#127792 implement UNO chart attribute MajorOrigin)
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/94621

Thanks Tünde!