https://bugs.documentfoundation.org/show_bug.cgi?id=164377
Bug ID: 164377
Summary: Match() returns Err:504 for discrete Ranges (a3, a6,
a10)
Product: LibreOffice
Version: 24.8.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
while specifying contiguous ranges works, documentation suggests that I should
be able to use a discrete range, (e.g. MATCH((E4~J4~N4~R4~V4~Z4),
MAX(E4~J4~N4~R4~V4~Z4),1) should work; in real life it is returning an Err:504
Steps to Reproduce:
1.create a discrete (e.g. non-contiguous) range, horizontal or vertical.
2. use a constant or a function with a non-sorted array specified
Actual Results:
Match fails with an Err:504 error
Expected Results:
expecting a numerical value (position of the matching constant)
Match() performs as expected with the discrete cells copied to a contiguous
range
(both horizontal & vertical) but fails (h & V) if the range is not contiguous.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 24.8.3.2 (X86_64) / LibreOffice Community
Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
CPU threads: 22; OS: Windows 10 X86_64 (10.0 build 19045); UI render:
Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
