https://bugs.documentfoundation.org/show_bug.cgi?id=167134
--- Comment #11 from Eike Rathke <[email protected]> --- (In reply to Regina Henschel from comment #9) > That is some time ago. Should we change it back nevertheless? I would say > yes, because Excel, gnumeric and AOO interpret it that way and because > different directions are interpreted without error for cell references. So > why not for inline arrays? Yes, it was probably an oversight there that the result array may have a different direction than the query array. > Is the proposed patch the correct way for fixing it? Looks good. > Should ODF TC add something to explicitly allow different directions? Maybe best. It is somewhat implied by "If it is a cell range, it gets automatically extended to the length of the searched vector, but in the direction of the result vector." (under "The lengths of the search vector and the result vector do not need to be identical.") though being extended is not applicable to arrays, but the directions aren't explicitly mentioned otherwise. -- You are receiving this mail because: You are the assignee for the bug.
