[Libreoffice-bugs] [Bug 126481] New: An option for Rounding mode in ScInterpreter::ScRound

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: himajin100000 at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190719/a620c544/attachment-0001.html>