https://bugs.documentfoundation.org/show_bug.cgi?id=170743
Bug ID: 170743
Summary: SUMIF SUMIFS CONCAT INDEX not working with Named Range
defined with tilda concatenation.
Product: LibreOffice
Version: 25.8.4.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Will attach a demonstration ODS. Some functions do not always correctly handle
Named Ranges that are defined with tilda concatenated ranges. Errors include
wrong results, Err:504, and #REF!. Examples are SUMIF, SUMIFS CONCAT and INDEX.
But some functions, as far as I've experimented, seem to handle them
appropriately, such as SUM.
Steps to Reproduce:
1. open attached ODS
2. review sheets 1-3
3. sheet4 shows results with CONCAT, SUM, SUMIF, SUMIFS, and INDEX.
Actual Results:
either wrong results, or Err:504, or #REF!
Expected Results:
should behave as if the Named Range was a single contiguous column
Reproducible: Always
User Profile Reset: No
Additional Info:
Will attach a demonstration ODS.
There is not much documentation available that explains tilda-cat. Well, I
couldn't find much. My only source is the explanation in a single paragraph in
Calc Guide 26.2 > Chapter 15 > Named Ranges. That paragraph also appears in
several Guide versions preceding 26.2. My only experience with tilda-cat is
with LO 25.8.4.2. So I don't know if it every worked properly. It's possible
the failings due to
incorrect syntax by me.
Calc Guide 26.2 > chapter 15 > Named Ranges
Technically a named range is a named formula expression and its content is
always set as a string. A commonly used type of expression is an absolute cell
range like “$Sheet1.$A$1:$E$15”. However, other expression types are possible.
For example, the expression “$Sheet1.$A$1:$A$4~$Sheet1.$B$1:$B$4” encompasses
two separate cell ranges (the tilde character is a reference concatenation
operator). Alternatively a formula expression such as “PI()*B1*B1” might be
defined to calculate the area of a circle, given the radius. In the remainder
of this section we will be concerned only with named ranges defined as a single
matrix-like cell range.
--
You are receiving this mail because:
You are the assignee for the bug.
