Hi Ben, On Fri, May 22, 2026 at 10:03 AM Benjamin Urban <[email protected]> wrote: > 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?
Maybe just set the text as you already do in cellform.cxx, but just return "ScGlobal::GetErrorString(FormulaError::NotAvailable);". I would just go with #N/A! because adding new errors is complicated when you want to write that to OOXML. I didn't check if there is some kind of extension to OOXML, but in the case of #SPILL! it is converted to #VALUE! when saving to an OOXML document, because you can't extend it with #SPILL! without breaking backwards compatibility. One question: if I understand correctly, if you do this then you can use the LAMBDA by referencing the cell -> like A1: =LAMBDA(a,b, a+b) and then in B1: =A1(1,2) ? I tried this with MSO and GSheets but that didn't work. Tomaž
