https://bugs.freedesktop.org/show_bug.cgi?id=60345
Tim Richardson <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|WORKSFORME |--- Ever confirmed|0 |1 --- Comment #6 from Tim Richardson <[email protected]> --- I reopened this report because it was closed based on a Regular Expression work around. However, this is not the bug I am reporting: my bug is based on Excel compatability, and if Excel is the reference implementation of the SUMIF formula, then possibly this issue is a standards compliance bug. (Comments of mine referring to Regular Expressions were misleading. RE solutions are irrelevant because they don't work in Excel). Is the "Search Criteria = and <> must apply to whole cells" supposed to affect the use of Excel-style wildcards in SUMIF. And if so, how can users be better informed of this? This issue can cause big differences when the same spreadsheet is opened in Excel and Libreoffice, which I think is undesirable behaviour. -- 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
