[Libreoffice-bugs] [Bug 54255] MATCH does not find empty cells

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #8 from himajin100000 at gmail.com ---
the only line that changes mbMatchEmpty is...

https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/queryparam.cxx?r=db808563#295

FillInExcelSyntax is called by these functions.

https://opengrok.libreoffice.org/s?refs=FillInExcelSyntax&project=core

so matching empty string is currently available only in

SumIf
AverageIf
CountIf
SumIfs
AverageIfs
CountIfs
MinIfs
MaxIfs

Where IterateParametersIf or IterateParametersIfs is called or in DB-related
functions, and it does not work with Match.

https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/interpr1.cxx?r=ceabe204#4667

-- 
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/20180702/e713c8ff/attachment-0001.html>