https://bugs.documentfoundation.org/show_bug.cgi?id=91502
--- Comment #9 from Wolfgang Jäger <[email protected]> ---
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
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
