[Libreoffice-bugs] [Bug 49245] New: : Formula using SUM does work

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Sat Apr 28 11:42:45 CEST 2012


https://bugs.freedesktop.org/show_bug.cgi?id=49245

             Bug #: 49245
           Summary: : Formula using SUM does work
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.4.4 release
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: simon.bagley at ntlworld.com


Created attachment 60721
  --> https://bugs.freedesktop.org/attachment.cgi?id=60721
Spreadsheet attached with error. See cell G32, and H32.

Problem description: 

Steps to reproduce:
1. Open Microsoft Excel spreadsheet
2. Save as .ods document
3. Insert SUM formula in cell at bottom of column of numbers
4. Cell containing SUM formula calculates to zero, which is wrong.

Current behavior:
Cell calculates to £0.00

Expected behavior:
Cell should calculate to the correct figure, which is the sum of the cells
above.

Platform (if different from the browser): 

Browser: Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20100101 Firefox/12.0

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.


More information about the Libreoffice-bugs mailing list