[Libreoffice-bugs] [Bug 42990] New: EDITING: Inconsistencies in Calculations; No error for SUM function as it skips text fields.

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Wed Nov 16 15:09:41 CET 2011


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

             Bug #: 42990
           Summary: EDITING: Inconsistencies in Calculations; No error for
                    SUM function as it skips text fields.
    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: webmeister at axteleats.com


Created attachment 53601
  --> https://bugs.freedesktop.org/attachment.cgi?id=53601
ODS File with calculations with numbers as 'Text' but skipped for SUM function

Problem description: Numbers which the user may not know are formatted as
'Text' can be used in calculations.  Yet, the SUM function skips them without
any warnings or error messages.  This could lead to miscalculations without the
user's knowledge.

Steps to reproduce:
1. In the attached file, you see in cell A19 a SUM of 8.  This is supposed to
be a sum of the cells above and is clearly wrong.
2. If you look to the right, in column H, all the fields from column A are used
in calculations without any issues, though some of them in column A are
formatted as 'Text.'  This is inconsistent.
3. How do we know when the SUM function is working properly?

Current behavior: Inconsistency in dealing with numbers as text.

Expected behavior: Warnings/errors

Platform (if different from the browser): 

Browser: Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10.4; fr; rv:1.9.0.19)
Gecko/2011091218 Camino/2.0.9 (MultiLang) (like Firefox/3.0.19)

-- 
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