Description: See attached spreadsheet: input array {2,2,2,2} gives identical array as result. Steps to Reproduce: See attached spreadsheet. Actual Results: See attached spreadsheet Expected Results: See attached spreadsheet Reproducible: Always User Profile Reset: No Additional Info: Same results in safe mode.
Created attachment 200961 [details] Exhibits bug 166731
Thanks for reporting this issue. This is a problem related with dynamic arrays since they are not fully supported in Calc. Steps to fix it: 1. Select range F2:I2 2. Delete its content 3. Select cell F2 4. add formula =UNIQUE(A2:D2;1) -> This time the array is only one cell. *** This bug has been marked as a duplicate of bug 127808 ***
Thank you. Your work-around works only because you know the answer! ... There is only one unique value in my input array. In my use case, the whole point of using UNIQUE is to find out how many unique values in the input array. In all cases except when the values in my input array are identical, I can get the correct answer by counting the number of cells that are not #N/A in an output array from UNIQUE that is the same length are the input array. If I ensure that my input array contains at least 2 different values, with v1 and v2 the smallest, and make the output array the same length as the input, will the output be v1,v2,v3,...,vn,#N/A,#N/A,...,#N/A or are there other situations where I would get results different from the above? I can always ensure there are two different values on imput by including an impossible one: this is fine as a work-around. Is lack of full support for dynamic arrays temporary or longstanding?
it's a missing feature