Description: I created a xlsx file by MS office 365 and when I open it by LibreOffice Viewer, I get #NAME? error for the formula entered. Enhancement request: I find that BYROW and LAMBDA functions are not available in LibreOffice Calc. These functions are very useful for writing a single cell formula for a spill range, and one doesn't need to fill down formulas in the entire range like old versions of Excel. Also, to insert rows within the range becomes easier and one doesn't need to re- fill down formulas for the inserted rows. Google Sheets have already provided these functions. Steps to Reproduce: 1. A1=1 A2=2 A3=3 B1=2 B2=3 B3=5 2. Formula in C1 =BYROW(A1:B3,LAMBDA(a,SUM(a))) 3. This formula creates a spill range of C1:C3. Actual Results: C1=#NAME? C2=#NAME? C3=#NAME? Expected Results: C1=3 C2=5 C3=8 (row-wise sum of the range A1:B3) Reproducible: Always User Profile Reset: No Additional Info: "BYROW" function changes how you write formulas. It is a versatile tool that allows you to apply a specified function to each row of an array or range.
Created attachment 204986 [details] Screenshot of LibreOffice Viewer when opened xlsx file of office 365.
https://bugs.documentfoundation.org/show_bug.cgi?id=138749 https://bugs.documentfoundation.org/show_bug.cgi?id=164509 *** This bug has been marked as a duplicate of bug 164509 ***