<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: SUM fails to give sum without any indication of the failure cause"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=119524">119524</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>Calc: SUM fails to give sum without any indication of the failure cause
          </td>
        </tr>

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

        <tr>
          <th>Version</th>
          <td>6.0.6.2 release
          </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>kittykat3756@gmail.com
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Description:
The SUM function works on some rows in the document and not on others, I cannot
find the reason for it not working (row formatting is identical as far as I can
see and I've tried copy/pasting the formatting). There is no other indication
for why it may not be working that I can see.

In the end, I fixed it by copy/pasting the content of the working SUM cell in
the H column into one that was broken. When I tried to undo the copy/paste, it
still kept working after the change was undone.

Steps to Reproduce:
Not sure how I triggered the bug. I copy pasted the first row with the
calculation into all the subsequent rows and filled in the numbers for adding
up manually. First few rows add up correctly, but later ones do not. (See
screenshot.)

I have tried applying the formatting from the working rows to the broken rows
with no change.

Actual Results:
SUM of D31:G31 shown as Â£700.00 in H31 (see screenshot)

Expected Results:
SUM of D31:G31 shown as Â£858.10 in H31 (see screenshot)


Reproducible: Couldn't Reproduce


User Profile Reset: No



Additional Info:
Version: 6.0.6.2
Build ID: 6.0.6-1
CPU threads: 4; OS: Linux 4.17; UI render: default; VCL: gtk3; 
Locale: en-GB (en_GB.UTF-8); Calc: group</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>