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

--- Comment #6 from Regina Henschel <[email protected]> ---
Gnumeric as well, calculates the values as expected by me.

(In reply to m_a_riosv from comment #3)
> I can't find where explicitly say so, [...] in ODF definition
> https://docs.oasis-open.org/office/OpenDocument/v1.4/OpenDocument-v1.4-part4-
> formula.
> pdf#%5B%7B%22num%22%3A361%2C%22gen%22%3A0%7D%2C%7B%22name%22%3A%22XYZ%22%7D%2
> C133.05%2C261.741%2C0%5D

That is the problem; I currently work on that. The ODF description needs
improvement. https://issues.oasis-open.org/projects/OFFICE/issues/OFFICE-4164 

(In reply to nobu from comment #4)
[..]
> But in Google spreadsheet, all of the above formulas will be "Helium".
> And I can't find any mention of inline arrays getting special treatment in
> the help.

That means, that Google spreadsheet accepts different directions of search and
result vector. That supports my opinion, that LibreOffice has a bug.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to