https://bugs.documentfoundation.org/show_bug.cgi?id=163592
Bug ID: 163592
Summary: Sort function breaks and shows err504 with a single
row as a result
Product: LibreOffice
Version: 24.8.2.1 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have this function on my sheet:
SORT(FILTER(CHOOSE({1.2};$'Master log of records'.$B$5:$B$10033;$'Master log of
records'.$A$5:$A$10033);$'Master log of
records'.$B$5:$B$10033=B29;"NULL");2;-1)
It works fine, when FILTER results in at least two and more rows, but when that
underlying FILTER table results in only 1 entry, it returns err504. I tested
that with excel and it works fine there. It is really strange. It works
normally if I use:
=CONCATENATE("QF-004-002"; " / ";
RIGHT(IFNA(VLOOKUP(B30;SORT(FILTER(CHOOSE({1.2};$'Master log of
records'.$B$5:$B$10045;$'Master log of records'.$A$5:$A$10045);$'Master log of
records'.$B$5:$B$10045=B30;{"NULL";"NULL"});2;-1);2;FALSE());" ");3))
i.e. two-dimensional array for "result if empty" parameter.
version 24.8.2.1
Thanks a lot.
Steps to Reproduce:
Please, use the complex function described in description section. See attached
file.
Actual Results:
err504 with that function. I will attach file for ease of testing as it is
difficult to describe input and results.
Expected Results:
I expect not err504, but correctly formatted string.
Reproducible: Always
User Profile Reset: No
Additional Info:
I have attached the file. First sheet, first column, you can see variable
results of this evaluation.
Regarding attached file: Idea is to display on first sheet, first column:
document_number / last_number_used, i.e. like QF-004-001 / 002. That simply
means that QF-004-001 is just a number of template and all derivatives are
numbered with suffix like QF-004-001-001, QF-004-001-002 etc. Second sheet has
all them (derivatives) listed. So I would like to have last no used on the
first sheet next to the base document name. I do that by concatenating multiple
strings of document number itself and then doing filtered (with swapped
columns), sorted vlookup. This result is used with right function to get
required symbols, i.e. end number of document.
Forum suggested answer here:
https://ask.libreoffice.org/t/sort-function-breaks-and-shows-err504-with-a-single-row-as-a-result/112713
--
You are receiving this mail because:
You are the assignee for the bug.
