https://bugs.documentfoundation.org/show_bug.cgi?id=144889
--- Comment #3 from Mike Kaganski <[email protected]> --- In addition to comment 2: Ref: relevant help page https://help.libreoffice.org/latest/en-US/text/scalc/01/func_sumifs.html?DbPAR=CALC > The logical relation between criteria can be defined as logical AND > (conjunction). > In other words, if and only if all given criteria are met, a value from the > corresponding cell of the given Func_Range is taken into calculation. There you may also find something to resolve your "additional" confusion: > Regex expressions should be like any other software, "*" alone doesn't mean > anything, it should have something before it, for example: > .* > a* > [1-9]* > etc What you see are *not* "regular expressions". By default, wildcards are enabled in Options/Calc/Caclulate. They have different simplified syntax. Ref: https://help.libreoffice.org/7.3/en-US/text/scalc/guide/wildcards.html?DbPAR=CALC -- You are receiving this mail because: You are the assignee for the bug.
