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 passing empty (omitted/missing) arguments as parameters, empty arguments calculate as 0 value. Not a bug.