Summary: | VAR and STDEV functions do not handle non-numeric values correctly (aggregate too) | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Winfried Donkers <winfrieddonkers> |
Component: | Calc | Assignee: | Winfried Donkers <winfrieddonkers> |
Status: | RESOLVED FIXED | ||
Severity: | normal | CC: | erack, h3734236, raal |
Priority: | medium | ||
Version: | unspecified | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | target:5.3.0 target:5.2.1 target:5.1.5 | ||
Crash report or crash signature: | Regression By: |
Description
Winfried Donkers
2016-07-04 10:15:48 UTC
note: affect also aggregate function (In reply to raal from comment #1) > note: affect also aggregate function That is correct; AGGREGATE is a shell function (like SUBTOTAL) which calls the applicable functions like VAR and STDEV. Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b9c9bf666b4eb7ee4568fe155a2c8b50a02c4ad5 tdf#100753 propagate error with VAR and STDEV functions. It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Winfried Donkers committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=aec23208241c951e1d20515e6f8cf8ee2213cb16&h=libreoffice-5-2 tdf#100753 propagate error with VAR and STDEV functions. It will be available in 5.2.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Winfried Donkers committed a patch related to this issue. It has been pushed to "libreoffice-5-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=88065eebdf9bc557b2c5d982b0beacb19ef2ad36&h=libreoffice-5-1 tdf#100753 propagate error with VAR and STDEV functions. It will be available in 5.1.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. |