https://bugs.documentfoundation.org/show_bug.cgi?id=124454
Bug ID: 124454
Summary: Formula with SUMPRODUCT & MOD returns wrong value!
Product: LibreOffice
Version: 6.2.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: dursoj...@gmail.com
Description:
Calc produces a different (Incorrect) result than Excel or Google Sheets in a
formula that contains SUMPRODUCT and MOD.
Steps to Reproduce:
1.Enter a 14 length text field of numbers in cell E5 (69765050007777)
2.Enter Formula
"=MOD(10-MOD(SUMPRODUCT(--(MID(E5,{2,4,6,8,10,12,14},1)))*3+SUMPRODUCT(--(MID(E5,{1,3,5,7,9,11,13},1))),10),10)"
in cell F5
3.
Actual Results:
Result 2
Expected Results:
Result in Excel & G Sheets 6
Reproducible: Always
User Profile Reset: No
Additional Info:
Calculate correctly. This is my first time loading a bug, I do not see a
method of attaching a spreadsheet with formulas in it.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs