https://bugs.documentfoundation.org/show_bug.cgi?id=139612
Mike Kaganski <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected],
| |[email protected]
--- Comment #8 from Mike Kaganski <[email protected]> ---
Michael,
the commit identified in comment 7 looks strange, directly contradicting ODF
standard [1]. Could you please describe what was the rationale? (The commit
message does not explain whys, only what was done.) Also the commit doesn't
tell it intends to affect Advanced Filter - is it an unwanted regression?
OTOH, the standard only says "The values returned *may* vary depending upon the
... HOST-SEARCH-CRITERIA-MUST-APPLY-TO-WHOLE-CELL" (emphasis on "may"). Also
VLOOKUP is not documented to take "Criterion", only "Any" (which means that
Criterion and Criteria are among possible values?). And I don't see a
description of the filter in the standard (it might be there though, because
filtering allows to store the criteria in the file; I just didn't spend time on
investigating it). Eike: do you have an opinion on this?
[1]
http://docs.oasis-open.org/office/OpenDocument/v1.3/OpenDocument-v1.3-part4-formula.html#__RefHeading__1018436_715980110
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs