Bug 65086 - Warn or do a suggestion when entering a function with trailing ';' in the cell range
Summary: Warn or do a suggestion when entering a function with trailing ';' in the cel...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
Reported: 2013-05-28 15:47 UTC by Jorendc
Modified: 2019-01-27 23:44 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Sample spreadsheet (7.83 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-05-28 15:47 UTC, Jorendc

Note You need to log in before you can comment on or make changes to this bug.
Description Jorendc 2013-05-28 15:47:31 UTC
Created attachment 79906 [details]
Sample spreadsheet


How to reproduce:
* Download attachment


* Open Calc
* Enter the following numbers from B1 to B8:
2, 4, 4, 4, 5, 5, 7, 9 (by example of https://en.wikipedia.org/wiki/Stdev#Basic_examples)
* Select A1
* formula in A1: =STDEVP(B1;B2;B3;B4;B5;B6;B7;B8;)
* Enter

Result: 2,454524<bla bla bla>

Expected result: 2 (see https://en.wikipedia.org/wiki/Stdev#Basic_examples)

Doing the same in Excel for Mac result in a 2 (which is correct).

Also other Standard Deviation functions are affected.

Kind regards,
Comment 1 ign_christian 2013-05-29 02:06:22 UTC
Tested on LO (Win7 32bit)

=STDEVP(B1;B2;B3;B4;B5;B6;B7;B8;) -> 2,4545247
=STDEVP(B1;B2;B3;B4;B5;B6;B7;B8) -> 2

I think ; followed with no value should trigger error message & suggest correction
Comment 2 GerardF 2013-05-29 06:55:17 UTC
Empty argument is considered as 0.
Not specific to statistical functions.

With 1 in A1, 2 in A2,
=AVERAGE(A1;A2;) gives result 1
Comment 3 Jorendc 2013-05-29 14:10:35 UTC
Thanks for all replies and testing! You both are right! Deleting the trailing ';' fix this, I agree a warning/suggestion would be very welcome in this cases. 

Therefore I'll change this bug to an enhancement request.

Kind regards,