[Libreoffice-bugs] [Bug 116918] New: Sum Total ignoring changes in client cells if they are formatted to hide decimals.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116918

            Bug ID: 116918
           Summary: Sum Total ignoring changes in client cells if they are
                    formatted to hide decimals.
           Product: LibreOffice
           Version: 5.4.5.1 release
          Hardware: Other
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: 2017gm at talo5.plus.com

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

-- 
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/20180410/b318a942/attachment.html>