[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
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1

--- Comment #2 from Mike Kaganski <mikekaganski at hotmail.com> ---
Repro with Version: 7.1.0.1 (x64)
Build ID: b585d7d90ab863bf29b2d110c174c0c2a98f3ee4
CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL

Affected are all functions that are described in ODF [1] to depend on
HOST-SEARCH-CRITERIA-MUST-APPLY-TO-WHOLE-CELL host-defined property, or to take
parameters of type Criterion or Criteria:

Database Functions
AVERAGEIF
AVERAGEIFS
COUNTIF
COUNTIFS
HLOOKUP
LOOKUP
MATCH
VLOOKUP
SUMIF
SUMIFS

Seems that Advanced Filter is affected, too.

[1]
http://docs.oasis-open.org/office/OpenDocument/v1.3/OpenDocument-v1.3-part4-formula.html

-- 
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/20210114/df6991a3/attachment-0001.htm>