https://bugs.documentfoundation.org/show_bug.cgi?id=168414
Bug ID: 168414
Summary: Several function (COUNTIF, SUMIF, INDEX, XLOOKUP) not
working, when range is constructed over multiple
sheets
Product: LibreOffice
Version: 25.8.1.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When using one of the mentioned functions with a range, that is constructed
over multiple sheets (e.g. ```=SUMIF(Sheet1.A1:Sheet2.A1,">0" )``` ) there is
an error in the parameter. In the case of SUMIF, the same syntax is working
when the range is on a single sheet (e.g. A1:B1) or when using SUM instead.
Steps to Reproduce:
1.Creat new Document with 2 Sheets
2.Fill Cell with: =SUMIF(Sheet1.A1:Sheet2.A1,">0" )
Actual Results:
Err:504
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 25.8.1.1 (X86_64) / LibreOffice Community
Build ID: 580(Build:1)
CPU threads: 6; OS: Linux 6.16; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
25.8.1-2
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
