Bug 165065 - function UNIQUE() doesn't expand the result range when you added a new item into initial range
Summary: function UNIQUE() doesn't expand the result range when you added a new item i...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
24.8.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 164957 (view as bug list)
Depends on: 127808
Blocks:
  Show dependency tree / graph
 
Reported: 2025-02-05 19:17 UTC by Gianvincenzo
Modified: 2025-02-06 07:49 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Gianvincenzo 2025-02-05 19:17:46 UTC 
Description:
Using the UNICI() function, adding a new item, it is not displayed at all

Steps to Reproduce:
1.write a list of items
2.use the  unici() function
3.add a NEW item not yet included

Actual Results:
the new item doesn't appear

Expected Results:
if we add a NEW item it should be shown in the list 


Reproducible: Always


User Profile Reset: No

Additional Info:
the correct result should be to diplay all new items not yet typed
Comment 1 Xisco Faulí 2025-02-05 20:22:57 UTC 
Thanks for reporting this issue.
The problem is that dynamic arrays are not implemented in LibreOffice yet
Comment 2 Xisco Faulí 2025-02-05 21:32:42 UTC 
*** Bug 164957 has been marked as a duplicate of this bug. ***