Description: Add ARRAY_CONSTRAIN function. Steps to Reproduce: Interoperability with Google Sheets Actual Results: Error if ARRAY_CONSTRAIN() function is used Expected Results: Work if ARRAY_CONSTRAIN() function is used Reproducible: Always User Profile Reset: No Additional Info: This is useful when there are cells that should not be destroyed in the right or bottom direction, since the range to be filled by the formula is specified in advance. And if the range does not reach the specified value, nothing is displayed, so the look and feel is the same as a dynamic array formula. One could argue that this is unnecessary since it can be replaced by an existing formula. https://support.google.com/docs/answer/3267036?sjid=16672828875549345965-AP https://bugs.documentfoundation.org/show_bug.cgi?id=161841#c0 https://bugs.documentfoundation.org/show_bug.cgi?id=161841#c2
Related Topics. How to deal with #N/A caused by FILTER() on a selected range? https://ask.libreoffice.org/t/how-to-deal-with-n-a-caused-by-filter-on-a-selected-range/116478
Related Topics. Font transparency resetting back to 0% https://ask.libreoffice.org/t/font-transparency-resetting-back-to-0/116484