https://bugs.documentfoundation.org/show_bug.cgi?id=126481
Bug ID: 126481
Summary: An option for Rounding mode in ScInterpreter::ScRound
Product: LibreOffice
Version: 6.4.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
see steps to reproduce
Steps to Reproduce:
1. Open Calc
2. Enter =ROUND((105 x 1.75 + 50) / 1.1) to A1
3. Do the same thing in Excel
4. Compare the result
Actual Results:
Excel: 213
Calc : 212
I doubt
Excel is doing calculation with RoundingMode_Corrected
https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/interpr2.cxx?r=edcbe8c4#1010
Expected Results:
Calc should have an option in "Detailed Calculation Settings" for choosing
rounding modes for the compatibility with Excel and for the compatibility with
older version of Calc
Reproducible: Always
User Profile Reset: No
Additional Info:
--
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
