You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/02/25 19:19:25 UTC

DO NOT REPLY [Bug 118975] New: sum function error

https://issues.apache.org/ooo/show_bug.cgi?id=118975

             Bug #: 118975
        Issue Type: DEFECT
           Summary: sum function error
    Classification: Application
           Product: Spreadsheet
           Version: OOO330m20
          Platform: PC
        OS/Version: Windows XP
            Status: UNCONFIRMED
          Severity: critical
          Priority: P3
         Component: editing
        AssignedTo: ooo-issues@incubator.apache.org
        ReportedBy: hannu.puhakka@vetokonsultit.fi


Created attachment 77252
  --> https://issues.apache.org/ooo/attachment.cgi?id=77252
example file of the error

if you calculate a SUM function from the first row, you get nonsense

example:
E
1
1
1
1
1
2 =SUM(E1;E5)

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

DO NOT REPLY [Bug 118975] sum function error

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118975

Regina Henschel <rb...@t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

--- Comment #2 from Regina Henschel <rb...@t-online.de> 2012-02-25 18:50:50 UTC ---
Not a bug.

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

DO NOT REPLY [Bug 118975] sum function error

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118975

Regina Henschel <rb...@t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |rb.henschel@t-online.de
         Resolution|                            |INVALID

--- Comment #1 from Regina Henschel <rb...@t-online.de> 2012-02-25 18:50:29 UTC ---
You are adding content of E1 and content of E5. Notice, that you use a
semicolon and therefore add two single cells, not a range.

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