https://bugs.documentfoundation.org/show_bug.cgi?id=161454
--- Comment #4 from m_a_riosv <[email protected]> --- Verified about the empty cell Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 5a75414d1772d1fd998f405e3b9bd80b1f10c51f CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded About the array, in your sample file the function looks like an explicit array, but in Excel if you delete the LET formula and introduce it only with enter, the array is also created but without being an explicit array ({}). Opening the last in LO it is an explicit array formula. Saving in LO and opening it in Excel, work with the explicit array. But I think the issue is LO importing the formula as an explicit array, what it is not in Excel. -- You are receiving this mail because: You are the assignee for the bug.
