[Libreoffice-bugs] [Bug 94796] LINEST and INDEX problem

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=94796

--- Comment #5 from Eike Rathke  ---
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

[Libreoffice-bugs] [Bug 94796] LINEST and INDEX problem

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=94796

Eike Rathke  changed:

   What|Removed |Added

   Hardware|Other   |All
Version|5.0.2.2 release |Inherited From OOo
 OS|Windows (All)   |All

-- 
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 94796] LINEST and INDEX problem

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=94796

--- Comment #3 from m...@mschaffer.net ---
If the formula is entered as an array INDEX result is an array, not a value.
I would think that this is not the expected behavior.  Also, for what it is
worth, this works as expected in Excel.

-- 
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 94796] LINEST and INDEX problem

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=94796

--- Comment #1 from m...@mschaffer.net ---
Created attachment 119347
  --> https://bugs.documentfoundation.org/attachment.cgi?id=119347=edit
calc file showing the unexpected behavior of Index and Linest

-- 
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 94796] LINEST and INDEX problem

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=94796

GerardF  changed:

   What|Removed |Added

 CC||gerard.farg...@orange.fr

--- Comment #2 from GerardF  ---
Hi,

In the second case, you need to enter the formula as an array formula
(validation with Ctrl+Shift+Enter) to force array calculation of this part of
the formula A1:A7^{1,2}

INDEX expect an array in his 1st parameter and force array calculation of
LINEST in the 1st case but not in the second.

I don't know if this is really a bug or not...
I let this UNCONFIRMED waiting for other opinion.

-- 
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 94796] LINEST and INDEX problem

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=94796

GerardF  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||er...@redhat.com
 Ever confirmed|0   |1

--- Comment #4 from GerardF  ---
(In reply to mas from comment #3)
> If the formula is entered as an array INDEX result is an array, not a value.
> I would think that this is not the expected behavior.

No. INDEX(Linest_array,1,1) returns a singleton, not an array.

> Also, for what it is worth, this works as expected in Excel.

As per this, set it to NEW.
Even if ODF1.2 norms do no provide a "forcearray" in first arg of INDEX.

Add a dev to this bug.
@ Eike,
Sorry if I add you in CC as this is not how bugreport should work, but I need
your opinion about this.

-- 
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