https://bugs.documentfoundation.org/show_bug.cgi?id=164957
Bug ID: 164957
Summary: UNIQUE function - notes on how this function works
Product: LibreOffice
Version: 24.8.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 198889
--> https://bugs.documentfoundation.org/attachment.cgi?id=198889&action=edit
Example of incorrect operation
Incorrect operation.
If the function is to find unique occurrences in a range or matrix, and the
range or matrix contain identical entries, the function returns the entire
matrix or range of these entries instead of a single occurrence.
Example in the attached file:
Incorrect result construction.
A function validated in a single cell creates a result area or result matrix
adjusted to present the result that concerns the current state of the data.
If the source data changes and the number of unique elements changes as well,
the already created result range does not change. If there are fewer unique
elements, the unused cells of the result range contain #N/A, and if there are
more of these elements, only as many results will be shown as can be entered
into the created result area.
Hence, I postulate the following:
If the author of the formula does not first select the range in which the
function is to return results, the function should generate the dimension of
the output area consistent with the dimension of the area of the analyzed
data.
Unused cells of this area should contain a string of characters given as an
additional (optional) argument to the function and #N/A should be returned if
this argument is omitted (as e.g. in the XLOOKUP() function).
--
You are receiving this mail because:
You are the assignee for the bug.
