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ž
