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: [email protected]
Reporter: [email protected]
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.
