https://bugs.documentfoundation.org/show_bug.cgi?id=167917
Xisco Faulí <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |127808 CC| |[email protected] --- Comment #3 from Xisco Faulí <[email protected]> --- (In reply to Regina Henschel from comment #2) > These functions are designed to be compatible with Excel. Save the document > as xlsx, open the xlsx file in Excel. Now delete content of B1 in Excel. The > output cell range is filled with 1 in Excel as well. > > Thus for me it is a "wontfix". Yes, that's true, because LibreOffice exports the formulas as array formulas. However, it can't be reproduced in Excel if you insert the formula manually. I believe the root cause is the lack of support for dynamic arrays at the moment Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=127808 [Bug 127808] Add dynamic arrays in to Calc -- You are receiving this mail because: You are the assignee for the bug.
