[Libreoffice-bugs] [Bug 121396] New: Function FORECAST.ETS.PI.ADD() produces different results with identical data.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 121396
           Summary: Function FORECAST.ETS.PI.ADD() produces different
                    results with identical data.
           Product: LibreOffice
           Version: 5.2.7.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikehaag314 at gmail.com

Description:
Using common timeline dates argument, a common target date argument, and
several rows of identical values arguments, several cells with the
FORECAST.ETS.PI.ADD() function produce different results. See Steps to
Reproduce and the Actual Results.

Steps to Reproduce:
1. Open a new Calc spreadsheet.
2. In cells A1:E1 enter dates 05/10/18 through 05/14/18. These will be the
Timeline argument.
3. In cell F1, enter the date 05/20/18. This will be the Target argument.
4. In cells A2:E2, enter 45, 10, 20, 55, and 65. These will be the Values
argument.
5. I don't know if it's related to the problem, but on my computer, the
Function Wizard crashes Calc if I try to use it for the FORECAST.ETS.PI.ADD
function. So, in cell F2, manually enter the function:
=FORECAST.ETS.PI.ADD($F$1,A2:E2,$A$1:$E$1,0.95,1,1)
6. Select cells A2:F10, then Control-D to fill several rows.
7. Inspect function output cells F2:F10. The common timeline ($A$1:$E$1) cells
and common target cell ($F$1) should be the same, while the values cells should
have been automatically adjusted. As a check, cell F10 should be:
=FORECAST.ETS.PI.ADD($F$1,A10:E10,$A$1:$E$1,0.95,1,1)
8. Observe that the output is different in cells F2:F10.

Actual Results:
The Steps to Reproduce produce the following output, copied and pasted from my
spreadsheet. Dates 05/10/18 through 05/14/18 (Cells $A$1:$E$1) is the common
timeline argument, date 05/20/18 ($F$1) is the common target argument, the
values arguments are cells A2:E10. and the outputs are cells F2:F10:

05/10/18        05/11/18        05/12/18        05/13/18        05/14/18       
05/20/18
45      10      20      55      65      61.2437482284469
45      10      20      55      65      57.4837267613985
45      10      20      55      65      56.8951291510018
45      10      20      55      65      60.7092724189456
45      10      20      55      65      56.5521954423025
45      10      20      55      65      51.0461378492329
45      10      20      55      65      59.3321872557923
45      10      20      55      65      54.4217599183968
45      10      20      55      65      53.2928985999517



Expected Results:
Output in Cells F2:F10 should be identical.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 5.2.7.2
Build ID: 1:5.2.7-1+deb9u4
CPU Threads: 4; OS Version: Linux 4.9; UI Render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); Calc: group

[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes

-- 
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/20181113/b36ddad8/attachment-0001.html>