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

2021-07-19 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=143362 Buovjaga changed: What|Removed |Added CC||ilmari.lauhakangas@libreoff

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

2021-07-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=143362 --- Comment #11 from Eike Rathke --- The document is not an original Excel document but was stored using a LibreOfficeDev/7.2.0.0.alpha1 version. The stored values don't match the actual calculation, hence the (wrong) cached values are

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

2021-07-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=143362 --- Comment #10 from Eike Rathke --- Fwiw, the results are the same as in Excel if the document is recalculated, hit Shift+Ctrl+F9 -- You are receiving this mail because: You are the assignee for the

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

2021-07-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=143362 --- Comment #9 from Eike Rathke --- (In reply to Eike Rathke from comment #6) > Your screenshots show different data content, make at least sure you are > comparing the same documents. So that's actually because the value in B1 is

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

2021-07-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=143362 --- Comment #8 from Eike Rathke --- (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

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

2021-07-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=143362 --- Comment #7 from Elmar --- Created attachment 173579 --> https://bugs.documentfoundation.org/attachment.cgi?id=173579=edit updated sspreadhseet to include an excample from MS -- You are receiving this mail because: You are the

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

2021-07-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=143362 --- Comment #6 from Eike Rathke --- Your screenshots show different data content, make at least sure you are comparing the same documents. -- You are receiving this mail because: You are the assignee for the

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

2021-07-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=143362 --- Comment #5 from Elmar --- Created attachment 173578 --> https://bugs.documentfoundation.org/attachment.cgi?id=173578=edit compared to example on internet This is a simple example, but it actually gives the same result as excel.

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

2021-07-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=143362 --- Comment #4 from Elmar --- Note: I a using the Office 365 version of excel -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list

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

2021-07-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=143362 --- Comment #3 from Elmar --- Created attachment 173577 --> https://bugs.documentfoundation.org/attachment.cgi?id=173577=edit calc result screenshot -- You are receiving this mail because: You are the assignee for the

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

2021-07-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=143362 --- Comment #2 from Elmar --- Created attachment 173576 --> https://bugs.documentfoundation.org/attachment.cgi?id=173576=edit excel result screenshot -- You are receiving this mail because: You are the assignee for the

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

2021-07-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=143362 --- Comment #1 from Elmar --- Created attachment 173575 --> https://bugs.documentfoundation.org/attachment.cgi?id=173575=edit the excel doc -- You are receiving this mail because: You are the assignee for the