On Sat, May 23, 2026 at 3:30 AM Tomaž Vajngerl <[email protected]> wrote:
> > > On Sat, 23 May 2026, 03:35 Benjamin Urban, <[email protected]> wrote: > >> >> In fact, I already had to add a new error code, for when a call is >> attempted with a value that is not a function. >> > > oh I see now. This might be a problem when exporting to OOXML (xlsx). I'll > check an example document to see > how that is handled in this case. > >> >> Yes, that works fine. I actually didn't realize it doesn't work in MSO >> and GSheets. On further investigation, it seems GSheets only allows that >> sort of syntax if you refer to it using a name, rather than a cell >> reference. I wonder why they decided to do that, as I don't see a way that >> it wouldn't be extra effort. >> > > Yes, you need to add the lambda into the name manager and choose a name. > Then you can use it in formulas. Too bad as I also like that you could just > use a cell with the lambda instead going into name manager for this. We > probably can't allow this or will be bitten by compatibility issues. > > Tomaž > > While I'm not thrilled about adding complication to the code to reduce the potential utility, it is definitely necessary here to be compatible. I think I'll add a preprocessor directive (off by default) that allows someone to build without the complication, if they have a use for it. Of course I'll add comments describing the differences in behavior. Ben
