[Libreoffice-bugs] [Bug 143362] Different results between Calc and Excel for SUMIFS formula

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=143362

--- Comment #8 from Eike Rathke <erack at redhat.com> ---
(In reply to Elmar from comment #7)
> Created attachment 173579 [details]
> updated sspreadhseet to include an excample from MS
That document has regular expressions enabled, which calculates the criterion
"=A*" differently. Switch to Excel compatible wildcards instead and you'll get
the same 20 result, Tools -> Options -> Calc -> Calculate, Formulas Wildcards,
Enable wildcards in formulas.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210714/78e9ee36/attachment-0001.htm>