Bug 161755 - LibreOffice Writer line-chart graph produces erroneous horizontal data-point positions for date-based x-axis values.
Summary: LibreOffice Writer line-chart graph produces erroneous horizontal data-point ...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
7.6.7.2 release
Hardware: Other macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-06-24 03:45 UTC by Ron Abbott
Modified: 2024-06-24 04:24 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
.odt file exhibits bug (42.48 KB, application/vnd.oasis.opendocument.text)
2024-06-24 03:50 UTC, Ron Abbott
Details
.pdf file shows bug in case .odt file doesn't on different machine (46.36 KB, application/pdf)
2024-06-24 03:53 UTC, Ron Abbott
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Ron Abbott 2024-06-24 03:45:29 UTC
Description:
It appeared obvious that a line-chart with date-based values produced a bad graph.
Tried installing v24.2.4, same result.
Tried changing the date of one data point by one day (with six weeks between data points).  This produced a large change in the plot, but also erroneous.
See charts in attached .ODT and .PDF documents with further description. 

Steps to Reproduce:
1.Examine attached .odt and .pdf files that exhibit problem.
2.
3.

Actual Results:
Line-chart data points grapheded at wrong horizontal positions.

Expected Results:
Produce correct line-chart graph.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 7.6.7.2 (AARCH64) / LibreOffice Community
Build ID: dd47e4b30cb7dab30588d6c79c651f218165e3c5
CPU threads: 12; OS: Mac OS X 14.4.1; UI render: Skia/Metal; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 1 Ron Abbott 2024-06-24 03:50:31 UTC
Created attachment 194920 [details]
.odt file exhibits bug
Comment 2 Ron Abbott 2024-06-24 03:53:25 UTC
Created attachment 194921 [details]
.pdf file shows bug in case .odt file doesn't on different machine
Comment 3 Mike Kaganski 2024-06-24 04:24:19 UTC
You are using line chart, with the major X units of years, and minor units of months. As with any chart type other than XY, this chart type divides the axis into months, and puts the points into these divisions evenly. Compare with histogram built on the same data.

Use XY chart to treat the X axis as true numeric value. This is not a bug.