Bug 153433 - Standard Deviation, Average formula error counts semicolons
Summary: Standard Deviation, Average formula error counts semicolons
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-02-07 10:53 UTC by wojtek kalas
Modified: 2023-02-07 11:28 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description wojtek kalas 2023-02-07 10:53:12 UTC
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
Comment 1 Eike Rathke 2023-02-07 11:28:48 UTC
You are passing empty (omitted/missing) arguments as parameters, empty arguments calculate as 0 value.
Not a bug.