https://bugs.documentfoundation.org/show_bug.cgi?id=143362
Bug ID: 143362
Summary: Different results between Calc and Excel for SUMIFS
formula
Product: LibreOffice
Version: 7.3.0.0 alpha0+ Master
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I received a spreadsheet from an excel user, which when I opened it in Calc did
not present same results.
Steps to Reproduce:
1.open xlsx
2.
3.
Actual Results:
see sheet Summary in Calc cp. to Excel
I have included screenshots for both
Expected Results:
should produce same results
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 7c1bad415ae48635dc67041c413bb7b76a530c22
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time:
2021-07-05_06:55:03
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
