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.
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.