https://bugs.documentfoundation.org/show_bug.cgi?id=159425
--- Comment #7 from Bernhard G <[email protected]> --- (In reply to Rafael Lima from comment #4) > This actually works in Calc. But for you to apply the formula as an array > formula you must press Ctrl+Shitf+Enter. Oh, right - good catch! > You'll know you did it right because the formula bar will show > {AND(ISBLANK(C5:M5))} to indicate this is an array formula. That's right. Though, I may add, the braces around the formula are easily overseen. > The reason for this ticket is that now Excel automatically understands that > this is an array formula. Interestingly, I am not sure how precisely E365 handles such a formula: The example XLSX spreadsheet above, opened in LibreOffice 7.6.4.1, does show the formula with braces, so indeed it seems that E365 did automatically convert it. However IIRC, opened again in E365, the formula was again presented as a regular formula without braces. Does this mean that E365 converts it back and forth, array from/to regular, whenever the user edits the formula cell? (I may have to get back to E365 to confirm.) This may make sense, if it causes less confusion to the user to see his formula exactly as entered. But the user may have an even harder time understanding the difference between both formula types. Maybe he no longer needs to? > Maybe LO should do the same. I myself do not know enough about array formula. If it is primarily a technical distinction, and not a feature to the user, then yes, I would welcome LO to take one more burden off the user's shoulder, and do the same. -- You are receiving this mail because: You are the assignee for the bug.
