<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><table border="1" cellspacing="0" cellpadding="8">
        <tr>
          <th>Bug ID</th>
          <td><a class="bz_bug_link 
          bz_status_UNCONFIRMED "
   title="UNCONFIRMED - calc: calculation: roundup: rounddown: fail in 7.1 alpha"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=138220">138220</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>calc: calculation: roundup: rounddown: fail in 7.1 alpha
          </td>
        </tr>

        <tr>
          <th>Product</th>
          <td>LibreOffice
          </td>
        </tr>

        <tr>
          <th>Version</th>
          <td>7.1.0.0.alpha0+ Master
          </td>
        </tr>

        <tr>
          <th>Hardware</th>
          <td>All
          </td>
        </tr>

        <tr>
          <th>OS</th>
          <td>All
          </td>
        </tr>

        <tr>
          <th>Status</th>
          <td>UNCONFIRMED
          </td>
        </tr>

        <tr>
          <th>Severity</th>
          <td>normal
          </td>
        </tr>

        <tr>
          <th>Priority</th>
          <td>medium
          </td>
        </tr>

        <tr>
          <th>Component</th>
          <td>Calc
          </td>
        </tr>

        <tr>
          <th>Assignee</th>
          <td>libreoffice-bugs@lists.freedesktop.org
          </td>
        </tr>

        <tr>
          <th>Reporter</th>
          <td>newbie-02@gmx.de
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Description:
a 'deflowering'? based on 'search' no bugs have been reported for 'roundup' and
'roundown' yet? 

i stumbled over one: 

=ROUNDUP(-999,12999999999994;11) results in -999,130000000010 instead of the
expected -999,130000000000, 

=ROUNDDOWN(-999,12999999999994;11) results in -999,130000000000
instead of the expected -999.12999999999990

same fail - mirrored - for positive values, 

for those not familiar with it: roundup should round 'away from zero',
rounddown 'towards zero', 

plenty other values affected as well, even shorter ones like '888,1299999999'
which need no change for a round to 11 decimals ... 

'round' looks working correctly on a quick first look, 

no repro in 6.1.6.3, hence 'regression', 

imho critical, data corruption ... 

Steps to Reproduce:
see above description

Actual Results:
see above description

Expected Results:
see above description


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.0.0.alpha1+ (x64)
Build ID: b61bf7c7cfcf97a5ade6d130873af146670bc2ee
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: CL

'unparallelized' (without openCL and threading) same effect,</pre>
        </div>
      </p>


      <hr>
      <span>You are receiving this mail because:</span>

      <ul>
          <li>You are the assignee for the bug.</li>
      </ul>
    </body>
</html>