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
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 Empty argument is considered as 0. Not specific to statistical functions. With 1 in A1, 2 in A2, =AVERAGE(A1;A2;) gives result 1 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.