https://bugs.freedesktop.org/show_bug.cgi?id=60345
--- Comment #8 from Tim Richardson <[email protected]> --- God, how I wished I had never mentioned regex. [I'm a H1-average Computer Science graduate and I know what a regex is. Not Software Engineering, but Computer Science. We did the 1930s theory of regular exprssion language. I love that OO/LO uses regex. I also appreciate that for compatability, I can turn it off. However, this is an instance when it is in my opinion broken] Excel does not do regex,we all know that. But for the database functions, it supports wildcard matching. In the OpenFormula standards, you will see that the database functions, such as SUMIF, accept a "criteria". https://www.oasis-open.org/committees/download.php/16826/openformula-spec-20060221.html#Criteria Unfortunately, exactly what a "criteria" is is not well defined. As comments to the standard show me, there are two families of "criteria". One is regex, and one, which 95% of the world uses, is the Excel family, referred to as the "wildcard" family. see https://lists.oasis-open.org/archives/office/201003/msg00434.html which quotes someone as saying "Need to clearly note that table:use-regular-expressions and table:use-wildcards are mutually exclusive (at most one can be true)." Now, if regex is turned off in Libre Office preferences, you may think that use-wildcards is activated. This at least is my expectation. So why does it not work in SUMIF? I've done "regression testing" and this is not a new problem in OO/LO. However, I still think it is a bug since for all intents and purposes Excel is a reference implementation of the definition of "criteria". I'd love for someone to answer my question without referring to regular expressions (god bless them). -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
