Bug 65086

Summary: Warn or do a suggestion when entering a function with trailing ';' in the cell range
Product: LibreOffice Reporter: Jorendc <jorendc>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: enhancement    
Priority: medium CC: erack, gerard.fargeot, markus.mohrhard
Version: 4.0.3.3 release   
Hardware: Other   
OS: All   
Whiteboard:
i915 platform: i915 features:
Attachments: Sample spreadsheet

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

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.