https://bugs.documentfoundation.org/show_bug.cgi?id=94796
--- Comment #5 from Eike Rathke <er...@redhat.com> ---
The error already stems from the LINEST() function and is only propagated
through INDEX().
With LINEST(B1:B7,A1:A7^{1,2}) in non-array mode the arrays passed to LINEST
currently are:
knownX: 1 column * 7 rows
knownY: 2 columns * 1 row
This does not meet the constraints of LINEST:
(COLUMNS(knownY) = COLUMNS(knownX) and ROWS(knownY) = ROWS(knownX)) or
(COLUMNS(knownY) = 1 and ROWS(knownY) = ROWS(knownX)) or (COLUMNS(knownY) =
COLUMNS(knownX) and ROWS(knownY) = 1)
See
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#LINEST
In array mode the arrays passed are:
knownX: 1 column * 7 rows
knownY: 2 columns * 7 rows
which meets the constraints.
If Excel does not yield an error in the non-array case, my understanding is
that LINEST and LOGEST in ODF OpenFormula (ODFF) should have ForceArray types
instead of Array.
--
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
