https://bugs.freedesktop.org/show_bug.cgi?id=60345
--- Comment #9 from k...@cox.net --- Created attachment 112133 --> https://bugs.freedesktop.org/attachment.cgi?id=112133&action=edit Shows improper interpretation of wildcard in SUMIF criteria. This attachment is an expansion of Marco A's example spreadsheet submitted for 35636. HOWEVER, based on this: https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Using_regular_expressions_in_functions I cannot yet say whether this is a bug or not, because it appears that LibreOffice Calc uses wildcards in SUMIF, COUNTIF, MATCH, SEARCH, LOOKUP, HLOOKUP, VLOOKUP, DCOUNT, DCOUNTA, DSUM, DPRODUCT, DMAX, DMIN, DAVERAGE, DSTDEV, DSTDEVP, DVAR, DVARP, DGET in a way that is so cumbersome that it will take me time I don't have right now to figure it out. What I do note is that the wildcard "*" doesn't appear to do anything in SUMIF unless Tools > Options > LibreOffice Calc > Calculate > Search criteria = and <> must apply to whole cells ...AND... Enable regular expressions in formulas ...are checked; and if both are checked, the wildcard is not interpreted properly (as illustrated in the attached spreadsheet. When I get time to play with this in a daily build of LO Calc, I'll post more. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs