https://bugs.documentfoundation.org/show_bug.cgi?id=127808
JF <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #21 from JF <[email protected]> --- Created attachment 207959 --> https://bugs.documentfoundation.org/attachment.cgi?id=207959&action=edit Impact for not supporting Dynamic Array.ods As a simple user of LibreOffice, I would like to add my 2 dents on this topic. Many comments above refers to the need of supporting Dynamic Array to be compatible with Excel or Sheet. I can appreciate adding or not Dynamic Array functionality to LO is a business decision based on scarce development resources and the value of being compatible with Excel and Sheet. I would suggest that there are even greater issues for not supporting Dynamic Array in LO regardless of Excel or Sheet compatibility. In the current implementation of functions such as SEQUENCE(), UNIQUE() and FILTER(), Calc has lost its integrity in producing dependable results. I have attached a simple spreadsheet (Impact for not supporting Dynamic Array.ods) that illustrate the issue. In my examples there are no warning that the spreadsheet result is wrong when it was correct before. Consequently, I think it is of the upmost importance that Dynamic Array gets the development resources allocated in priority, even at the potential expense of deferring the release of new functionalities that would improve Excel or Sheet interoperability. My 2ยข -- You are receiving this mail because: You are the assignee for the bug.
