https://bugs.documentfoundation.org/show_bug.cgi?id=162303
Bug ID: 162303
Summary: SUMIFS fails if criteria field contains brackets
Product: LibreOffice
Version: 24.2.5.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
SUMIFS dosen't correctly identify criteria that has brackets in them. For
example, if I'm trying to do a SUMIFS on a table:
Description,Amount
Gain (Loss),1.00
Interest,1.00
Dividend,1.00
Gain (Loss),1.00
And my function reads =SUMIFS(B2:B5,A2:A5,Q1) where Q1 refers to a cell that
reads "Gain (Loss)", the result will return 0, not 2.
Steps to Reproduce:
1. Create a table that can be used as input to a SUMIFS function
2. Make sure that a field that'll be used as criteria contains values that have
brackets in them
3. Create a SUMIFS expression referencing the cells that have the criteria
containing brackets
Actual Results:
The SUMIFS expression returns 0. Removing the brackets from the input and
criteria expression yields the correct result
Expected Results:
The SUMIFS function can handle input that contains brackets and correctly total
the results
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 4; OS: Linux 6.9; UI render: default; VCL: kf5 (cairo+wayland)
Locale: en-CA (en_CA.UTF-8); UI: en-US
Debian package version: 4:24.2.5-1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
