https://bugs.documentfoundation.org/show_bug.cgi?id=146067
Bug ID: 146067
Summary: MA trend lines are displayed with inconsistent X
offset, depending on the label values
Product: LibreOffice
Version: 7.2.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
For some cases of column labels (dates) the trend lines are displayed wrong,
with a displacement in the X direction, equal to half of the X interval.
Steps to Reproduce:
1. On a blank Calc sheet, create a first column (A1:A7) with dates (I've used
2021-05-15, 2021-06-15 ... ), format as MM-AA
2. Create a second column (B1:B7) with the numbers (20, 10, 20, 30, 20, 20, 40)
3. Select filled cells, insert graph: select line type
4. In the second step of the wizard, select defaults: "Data series in columns /
First column as label" . Click Finish.
5. If the graph is cropped (bug 146066), you may fix the Y axis range to 0-45.
6. Right click over the data series, insert Trend line, select Moving average,
Period=2, Type=Prior
Actual Results:
The trend line is wrong, it's displaced to the right by a distance equal to
half-interval. That's especially noticiable on the rightmost point (its MA
value should be 30, it's seen as 25), and also is noticiable in the inflection
points not being aligned with the main graph.
Expected Results:
The trend line should be shifted to the left, with its inflection points
aligned with the main graph.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
The problem persists for the "Central" MA variant
The problem disappears if the values of the label column are deleted, or set to
numeric or string values.
If the "Averaged abcisas" is selected, the offset is still inconsistent
(dependent on the label column type), but I'm not sure which is the right one.
(I'd say that here we'd indeed expect the inflection points to be located
between the graph values - again, this assumption is violated when the label
column contain dates).
--
You are receiving this mail because:
You are the assignee for the bug.
