[Libreoffice-bugs] [Bug 139856] New: CALC CHART Trend Lines for moving average not being "smoothed" similarly to Polynomial Trend Lines

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139856

            Bug ID: 139856
           Summary: CALC CHART Trend Lines for moving average not being
                    "smoothed" similarly to Polynomial Trend Lines
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: trivial
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: that.man.colin at gmail.com

Description:
Moving Average Trend Line doesn't conform to any "smoothing" criteria imposed
on the underlying "smoothed" line chart.
As a comparison, the Polynomial line is "smoothed"
See attached .ods with the resulting chart line and two trend lines.

As a side line, is there a rationale for having version history extending all
the way back to 3.3.0 release?

Steps to Reproduce:
See attached sheet SmoothLine.ods
If desired, clear and recreate the green & red trend lines
Green is a 3 event moving average & red is a 6 Deg Polynomial
or simply right click and edit the parameters
There only exists a setting to "smooth" the base chart line
One might infer from the lack of setting for the trend lines that the waveform
for all the trend lines would correspond to the baseline. It appears that the
more complex formulaic trend lines follow the defined smoothness of the
baseline whereas that for the 3 event moving average trend line does not.

Actual Results:
3 event moving average trend line is not "smoothed"

Expected Results:
I would have assumed a smooth line


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 7.0.4.2 (x64)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210123/40f03c6d/attachment-0001.htm>