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: Spreadsheet (show other bugs)
Version: 4.0.3.3 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-05-28 15:47 UTC by Jorendc
Modified: 2013-05-29 14:10 UTC (History)
3 users (show)

See Also:
i915 platform:
i915 features:


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

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.