https://bugs.documentfoundation.org/show_bug.cgi?id=149832
Mike Kaganski <mikekagan...@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution|--- |NOTABUG --- Comment #4 from Mike Kaganski <mikekagan...@hotmail.com> --- Any ideas how it would be better are irrelevant. The function is defined in the ODF standard [1]; and the definition there was not arbitrary, but it followed the long-established rules (coming from Lotus 1-2-3, or maybe even VisiCalc). Every spreadsheet software implements VLOOKUP that way; and doing otherwise would break infinite number of existing documents. So this is NOTABUG, and this must not change. [1] https://docs.oasis-open.org/office/OpenDocument/v1.3/OpenDocument-v1.3-part4-formula.html#VLOOKUP -- You are receiving this mail because: You are the assignee for the bug.