https://bugs.freedesktop.org/show_bug.cgi?id=60345
--- Comment #4 from mariosv <[email protected]> --- Created attachment 74313 --> https://bugs.freedesktop.org/attachment.cgi?id=74313&action=edit Modified sample file. Hi Tim, regular expressions in calc are not the same wildcard than excel. They are more complex and powerful but not so simple as in excel. Look up in the help for regular expressions. Also remember that by default open an xls file by default disable regular expressions option. If you want your formula working, enable regular expressions and substitute "*" with ".*" =sumif(d1:d9999,"paypal.*",e1:e9999) One trick, that I have used time ago is enter the wildcard in a cell and reference this cell in the expression. B3: .* (* in excel) =sumif(d1:d9999,"paypal"&$B$3,e1:e9999) Attached your file with a little modification. It is not a bug, is how it works. -- 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
