https://bugs.documentfoundation.org/show_bug.cgi?id=171928
Bug ID: 171928
Summary: EDITING: non-contiguous named range from Sheet X
throws Err:502 in Sheet Y for MEDIAN function, but not
AVERAGEIFS function
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 206892
--> https://bugs.documentfoundation.org/attachment.cgi?id=206892&action=edit
Calc ODS document
Basic Info:
Version: 26.2.1.2 (X86_64)
Build ID: 620(Build:2)
CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Vulkan;
VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: threaded
There seems to be a difference between the MEDIAN(IF)) function combination and
the AVERAGEIFS function in terms of how they deal with non-contiguous named
ranges defined globally. I want to use these functions in array formulas that
reference the exact same named ranges and database ranges, but the formula with
the MEDIAN function throws an "Err:502" error.
My document is attached for reference. The "Err:502" is cell J15 on the
Analysis sheet. Here are the contents:
=MEDIAN(IF((BPTimes>$B15)*(BPTimes<=$B16), BPSysAll))
The same ranges are used in cell J4 on the Analysis sheet:
=AVERAGEIFS(BPSysAll,BPTimes,">"&B3,BPTimes,"<="&B4)
I get the expected result with the J4 formula; but, the J15 formula throws the
"Err:502" error.
--
You are receiving this mail because:
You are the assignee for the bug.
