On Thu, May 21, 2026 at 5:07 AM Tomaž Vajngerl <[email protected]> wrote:
> Hi Benjamin! > > On Thu, May 21, 2026 at 4:17 AM Benjamin Urban <[email protected]> > wrote: > > That wasn't what I was asking. My question is referring to a spreadsheet > "function" called LAMBDA, which was introduced in Excel in the 2020 > version. When entered into a formula, it builds a callable function that > can be used by other spreadsheet cells (or called within the same formula). > As a function has no natural representation as text, my question was what > to display in the cell if the result is such a function. > > In MSO the result is an "error" #CALC! - similar to Sheets. Maybe just > add a new error #CALC! just like I did add #SPILL! at [1]. You > probably don't need a lot of knowledge about how cells are rendered > with this. > > [1] https://gerrit.collaboraoffice.com/c/online/+/1727 > > > Ben > > Regards, Tomaž > I guess my question, then, would be: How can I make the cell appear to be an error, while still storing a valid (non-error) value?
