Since I learned about these three formulas in Google Sheets I can’t do without them. They take a lambda and apply them to every cell in the row, column, or range respectively. E.g.
=BYROW(D1:D, LAMBDA(date, IF(date <> “”, “There is a date”, “”)))
Blockquote
This way complicated spreadsheets don’t require the user to drag formulas across all cells but only to put this one formula at the very top. Very maintainable, and a lot less error prone.
If ONLYOFFICe has their own way of solving this I’m happy to learn more about it. Else I would love to know if there’s a possibility of this ever making it into the software.
According to the provided syntax, LAMBDA, BYROW, BYCOL and MAP are basically different formulas. The suggestion to add LAMBDA has been registered a while ago, but the rest of the named formulas depend on it, so additional suggestion is required.
We’ll take a closer look at these formulas. I am keeping you posted.
Hi ya,
I love OnlyOffice, especially the spreadsheet. I can manage the bugs and things seem to be improving but it is really disappointing that Lambda doesn’t transfer over from excel. I suspect a lot of people aren’t aware of it in excel but it is so helpful and, once you are using it, it is sorely missed when moving to your software.
