[Libreoffice-bugs] [Bug 139612] Option "Search criteria = and <> must apply to whole cells" doesn't affect to calculation as must.

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com,
                   |                            |michael.meeks at collabora.com

--- Comment #8 from Mike Kaganski <mikekaganski at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210115/7a55c1d5/attachment.htm>