[Issue 127720] New: DSUM function : character string as selection criteria not correctly handled (eg "EM" counted as "M")

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127720

          Issue ID: 127720
        Issue Type: DEFECT
           Summary: DSUM function : character string as selection criteria
                    not correctly handled (eg "EM" counted as "M")
           Product: Calc
           Version: 4.1.5
          Hardware: PC
                OS: Windows 10
            Status: UNCONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: programming
          Assignee: issues@openoffice.apache.org
          Reporter: richard.watremez@free.fr
  Target Milestone: ---

I want to signal a bug in OpenOffice Calc v4.1.5 (running on Windows 10)
related to the DSUM function :

        A       B       C
1       Debits          Type
2       100             M
3       200             EM 
4       300             M
5       400             EM
6       150             D
7       260             D
8               Type    
9       1000    M       

With A9 : DSUM(A1:A7;"Debits";B8:B9) :

The formula gives 1000 instead of 800 (sum of « M » lines) ! 
The « EM » lines are also faulty selected (because « M » string is included in
« EM » ?).
So, M + EM lines give 1000, while M lines should only give 400 …

I know that a correct result can be obtained with function SUM, like in A9 : 
SUM( (C2 :C7 = B9) * A2:A7 ) entered by pressing Ctrl-Shift-Enter
But I have a large set of data files coded with the DSUM …

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127720] DSUM function : character string as selection criteria not correctly handled (eg "EM" counted as "M")

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127720

oooforum (fr) <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOT_AN_OOO_ISSUE
                 CC|                            |oooforum@free.fr

--- Comment #1 from oooforum (fr) <oo...@free.fr> ---
If I test your example
With AOO 4.1.5, I got Err504
With Excel, I got 0

Please provide directly an ODS file. More easy to reproduce.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127720] DSUM function : character string as selection criteria not correctly handled (eg "EM" counted as "M")

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127720

Marcus <ma...@apache.org> changed:

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

-- 
You are receiving this mail because:
You are the assignee for the issue.