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)
Version:
(earliest affected)
4.0.3.3 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency tree / graph
 
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:

Attachments
Sample spreadsheet (7.83 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-05-28 15:47 UTC, Jorendc 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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

Hi,

How to reproduce:
* Download attachment

or:

* 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,
Joren
Comment 1 ign_christian 2013-05-29 02:06:22 UTC 
Tested on LO 4.0.3.3 (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,
Joren