Description: The array formula don't get extended when adding unique values. Steps to Reproduce: 1. In named range "values0" $unique.$A$2:$A$11 I added 4 strings in cells A2 to A5. 2. Then I created the array formula {=UNIQUE(values0)} in cell B2. The resulting array formula covers the cells B2:B6. 3. Adding unique string values to the empty cells of the named range only updates cell B6, but don't extend the range of the array formula. Actual Results: array formula stays in range B2:B6. Expected Results: array formula should be extended as needed for new unique values. Reproducible: Always User Profile Reset: No Additional Info: Version: 25.2.6.2 (X86_64) / LibreOffice Community Build ID: 729c5bfe710f5eb71ed3bbde9e06a6065e9c6c5d CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: de-AT (de_AT); UI: en-US Calc: CL threaded
Created attachment 203816 [details] array formula example
You are looking for a feature that is called "dynamic array" in Excel. Such does not exist yet in LibreOffice. Implementing such feature requires an extension to the file format. It is a known problem and already tracked in bug 127808. *** This bug has been marked as a duplicate of bug 127808 ***