| Summary: | Calc sum function ignores NA() function -- EDITING | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Peter Beurle <peter.beurle> |
| Component: | Calc | Assignee: | Kohei Yoshida <kohei> |
| Status: | RESOLVED FIXED | ||
| Severity: | major | CC: | gerard.fargeot |
| Priority: | medium | Keywords: | regression |
| Version: | 4.2.1.1 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=118843 | ||
| Whiteboard: | target:4.3.0 target:4.2.3 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | sum error example | ||
Reproducible with 4.3.0 alpha. Errors are ignored by the SUM function, not only #N/A (#DIV/0, #REF!, #VALUE!, etc). Very interesting corner case. I wasn't aware of this behavior. Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=78e6b7a94265507e43dd80182706970f49cdb303 fdo#75628: Write unit test for this. 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. Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d658c092f488fc0d4cb924fe3e34cab997db76e2 fdo#75628: SUM should inherit error if one is present in its references. 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. 4.2 backport request: https://gerrit.libreoffice.org/8504 Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e26f0c815cbb3ca2c912b9ed85470d7666564027&h=libreoffice-4-2 fdo#75628: SUM should inherit error if one is present in its references. It will be available in LibreOffice 4.2.3. 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. Fixed. |
Created attachment 94922 [details] sum error example When I have a list of numbers in calc and in the sum range I have the NA() function the total should be #N/A. This works correctly in V4.1 but in V4.2 I get the total of the list. Sample attached with internal comment.