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

Mike Kaganski <mikekagan...@hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |er...@redhat.com,
                   |                            |michael.me...@collabora.com

--- Comment #8 from Mike Kaganski <mikekagan...@hotmail.com> ---
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
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to