https://bugs.documentfoundation.org/show_bug.cgi?id=153433
Bug ID: 153433
Summary: Standard Deviation, Average formula error counts
semicolons
Product: LibreOffice
Version: 6.4.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
STDEV (A1; ; ; ; ; ) with any number in A1 returns the result that is related
to number of semicolons.
Any semicolon on the end of formula, e.g. STDEV (A1; B1;) change the result
(vs, STDEV (A1;B1)
In this case, is easy to spot, but in complicated formulas when lonely
semicolons would appear e.g. stedv(A1;B2;K8; F7;;H4;) it can harm badly the
calculations
To my knowledge, lonely semicolons cause the miscalculations in any formula
containing a list of arguments separated by semicolons.
Steps to Reproduce:
1. enter 10 in A1 and 20 in B2
2. use =STDEV(A1; ; ; ; ; ) or =ODCH.STANDARDOWE(A1;;;;;)
3. =ODCH.STANDARDOWE(A1;)
4. =ODCH.STANDARDOWE(;A1)
5. =ŚREDNIA(A1;B1;)
5.
Actual Results:
2: 7,07106781186548
3&4: 4,08248290463863
5: 10
Expected Results:
2-4: There should be error report #DZIEL/0!
5: 15
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: pl
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Wersja: 6.4.7.2
Identyfikator kompilacji: 1:6.4.7-0ubuntu0.20.04.4
Wątki CPU: 4; System operacyjny: Linux 5.13; Render UI: domyślny; VCL: gtk3;
Ustawienia regionalne: pl-PL (pl_PL.UTF-8); Język UI: pl-PL
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
