A1: 1 A2: 2 B1: =N(A1:A2) => 1 ok B2: =N(A1:A2) => 1 wrong, expected 2 Regression of change for bug 33705.
Also, it ignores inline errors like =N(1/0) and converts them to 0 instead of propagating.
Additionally array context doesn't work, e.g. {=N(A1:A2)} always displays evaluation of A1, but that never did so no regression there.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d822c6afe6c1a676e9b86d67e599dbcf75512a7c resolved fdo#51442 N() inconsistent argument handling
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/help/commit/?id=b6956a9dfce0057a1af539d3142bacf52c6bc31a fdo#51442 adapted help content of N(), errors are propagated
Created attachment 63495 [details] testcases
Additionally needed for dependency: http://cgit.freedesktop.org/libreoffice/core/commit/?id=5f86b4be3c40180031aa723f5fa44a19595bffa8
@Eike: If you want to cherry-pick this to libreoffice-3-6, please do it before the beta3 tag (2012-07-02, Monday), because that is the string freeze date and you patched the help. No review is required until rc1. Thanks!
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=94f6289eb012aa69da25800b42eaa6e4c566168d&g=libreoffice-3-6 added mnStringNoValueError handling to ConvertStringToValue() (fdo#51442 dependency) It will be available in LibreOffice 3.6.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1cd5ceb0a9e3c4b31e2c68295a2e9fc3fc080749&g=libreoffice-3-6 resolved fdo#51442 N() inconsistent argument handling It will be available in LibreOffice 3.6.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/help/commit/?id=34e1ed8e3794b5f9b83c061a726b1d810df3265c&g=libreoffice-3-6 fdo#51442 adapted help content of N(), errors are propagated It will be available in LibreOffice 3.6.