https://bugs.documentfoundation.org/show_bug.cgi?id=89207
--- Comment #7 from Bertrand <[email protected]> --- This issue was first reported ten years ago, yet it still persists. Array functions cannot be edited once they have been validated in a cell. Attempting to do so results in the error “Cannot change only part of an array.” Furthermore, if these functions are supposed to return arrays of dynamic size (size configurable by one of the function arguments), the size of the array is always equal to the size generated the first time. In short, this makes array functions completely unusable in LibreOffice! And I am very, very perplexed by the fact that this fundamental problem has not been addressed in 10 years! We are currently on version 25.2 and the problem was first reported in version 3.3... That's the only reason I still have to use Excel... I naively ask the question: do the LibreOffice development teams use LibreOffice themselves? Please make solving this problem a top priority! Many thanks in advance. -- You are receiving this mail because: You are the assignee for the bug.
