b***@bugs.documentfoundation.org
2018-11-13 15:58:16 UTC
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-***@lists.freedesktop.org
Reporter: ***@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
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-***@lists.freedesktop.org
Reporter: ***@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.
You are receiving this mail because:
You are the assignee for the bug.