Bug 65086

Summary:	Warn or do a suggestion when entering a function with trailing ';' in the cell range
Product:	LibreOffice	Reporter:	Jorendc <jorendc>
Component:	Spreadsheet	Assignee:	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.