[Libreoffice-bugs] [Bug 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)
https://bugs.documentfoundation.org/show_bug.cgi?id=91502 Wolfgang Jäger changed: What|Removed |Added Summary|The functions FORMULA and |The functions FORMULA and |ISFORMULA do not return the |ISFORMULA do not return the |correctan array under |correct array under |"iterative evaluation" |"iterative evaluation" |condition |condition |(array-evaluation) |(array-evaluation) -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)
https://bugs.documentfoundation.org/show_bug.cgi?id=91502 raal changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||r...@post.cz, ||winfrieddonkers@libreoffice ||.org Ever confirmed|0 |1 --- Comment #3 from raal --- Reproducible with Version: 5.1.0.0.alpha1+ Build ID: e929194317a7debb1c5467282230cbbabe61a710 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-05-22_06:33:18 Setting to NEW and adding Winfried to CC. http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#ISFORMULA Passing a non-reference, or a reference to more than one cell, is implementation-defined. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)
https://bugs.documentfoundation.org/show_bug.cgi?id=91502 --- Comment #9 from Wolfgang Jäger --- Created attachment 126957 --> https://bugs.documentfoundation.org/attachment.cgi?id=126957&action=edit Reworked demo containing additional proof for a claim. The demo was rework adding columns K through N to the otherwise unchanged sheet. This is done to prove the claim that also the FORMULA function is not correctly working in array-context under specific conditions despite the fact that FORMULA is returning the correct array if directly entered for array evaluation using (Ctrl+Shift+Enter). The one "specific condition" demonstrated is the occurrence of FORMULA(A2:A5) as a subformula on the ForceArray parameter position of SUMPRODUCT in cell M1 of the reworked sheet. Cases where FORMULA and ISFORMULA are used for array evaluation may not be very frequent. However, if used without success, the exploration of the cause of the error may be difficult. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)
https://bugs.documentfoundation.org/show_bug.cgi?id=91502 --- Comment #4 from s...@koppen.org --- Please consider allowing ISFORMULA within Matrix evaluations. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)
https://bugs.documentfoundation.org/show_bug.cgi?id=91502 --- Comment #5 from s...@koppen.org --- Created attachment 122814 --> https://bugs.documentfoundation.org/attachment.cgi?id=122814&action=edit Comparison of matrix evaluation of ISEVEN and ISFORMULA -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)
https://bugs.documentfoundation.org/show_bug.cgi?id=91502 --- Comment #6 from Wolfgang Jäger --- Created attachment 122817 --> https://bugs.documentfoundation.org/attachment.cgi?id=122817&action=edit Demo by user "s...@koppen.org" reworked as descibed in comment #6 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)
https://bugs.documentfoundation.org/show_bug.cgi?id=91502 --- Comment #7 from Wolfgang Jäger --- Just tested with LibO V5.1.0.3 first using the original attachment to comment #1. The behaviour of FORMULA changed. It now retiurns the expected array of formulas applied under array evaluation. The behaviour of ISFORMULA is unchanged. (Cf comments #4,#5 by user "s...@koppen.org". I also reworked his example and added a (temporary) workaround concerning his request based on the new behaviour of the FORMULA function. As I still not am fully familiar with this bugzilla software I quoted a wrong number of comment for it. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)
https://bugs.documentfoundation.org/show_bug.cgi?id=91502 --- Comment #8 from Christian Koppen --- Wolfgang, I tried your new testcase with LibreOffice 5.0 (don't know the exact version), but unfortunately it didn't work. Then I updated to LibreOffice 5.1.0.3 and now I can confirm your workaround. This will probably help me, thanks a lot. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)
https://bugs.documentfoundation.org/show_bug.cgi?id=91502 Christian Koppen changed: What|Removed |Added Attachment #122817|Demo by user|Demo by user Christian description|"s...@koppen.org" reworked |reworked as descibed in |as descibed in comment #6 |comment #7 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)
https://bugs.documentfoundation.org/show_bug.cgi?id=91502 --- Comment #10 from Wolfgang Jäger --- FORMULA is returning the correct array in my tests under array evaluation since V5.1.1.3 (latest). Insofar: fixed - worksforme. ISFORMULA is showing the bug as demonstrated earlier still in V5.3.0.0 beta1. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs