Bug 166220 - Arrays don't behave as they do in MS 365 or in Google Sheets.
Summary: Arrays don't behave as they do in MS 365 or in Google Sheets.
Status: RESOLVED DUPLICATE of bug 127808
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.2.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-04-17 09:18 UTC by hasanseu
Modified: 2025-04-17 10:06 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Testing array resulted from a filter function (6.37 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2025-04-17 09:18 UTC, hasanseu 		Details
View All 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 hasanseu 2025-04-17 09:18:55 UTC 
Created attachment 200372 [details]
Testing array resulted from a filter function

If I use a filter function I may get an array. 
Then if I want to edit the function, I've to select the entire range instead of the cell I've written the function in. 
Moreover the result is not not dynamic. It doesn't accurately update always when I change the data. I've attached an excel file.

Thanks
Comment 1 nobu 2025-04-17 10:06:24 UTC 

*** This bug has been marked as a duplicate of bug 127808 ***