Summary: | N() does not work with position dependent range intersection | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Eike Rathke <erack> |
Component: | Calc | Assignee: | Eike Rathke <erack> |
Status: | RESOLVED FIXED | ||
Severity: | major | Keywords: | regression |
Priority: | medium | ||
Version: | 3.4.1 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | target:3.7.0 target:3.6.0.0.beta3 | ||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 108827 | ||
Attachments: | testcases |
Description
Eike Rathke
2012-06-26 04:27:53 UTC
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. |