<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 - Sum Total ignoring changes in client cells if they are formatted to hide decimals."
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=116918">116918</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>Sum Total ignoring changes in client cells if they are formatted to hide decimals.
          </td>
        </tr>

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

        <tr>
          <th>Version</th>
          <td>5.4.5.1 release
          </td>
        </tr>

        <tr>
          <th>Hardware</th>
          <td>Other
          </td>
        </tr>

        <tr>
          <th>OS</th>
          <td>Mac OS X (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>2017gm@talo5.plus.com
          </td>
        </tr></table>
      <p>
        <div>
        <pre>I have a number of sub totals and a grand total on my spreadsheet - each
containing Sterling currency. If all are set to show 2 decimal places all works
OK but if I hide the decimals in the sub totals and then add or subtract
figures the grand total only responds to whole pounds i.e. the pence value only
alters if the sub totals display pence. I am not using roundup or rounddown</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>