OASIS Open Document Format for Office Applications (OpenDocument) TC

 View Only
Back to discussions
Expand all | Collapse all

Cell value for cell content '=Reference' in case Reference points to an empty cell

  • 1.  Cell value for cell content '=Reference' in case Reference points to an empty cell

    Posted 04-30-2024 14:40

    Hi all,

    open the attached spreadsheet (rename .zip to .ods). It contains examples of functions INDIRECT and OFFSET and of the new function XLOOKUP. The functions INDIRECT and OFFSET return a reference, same as the new function XLOOKUP will do. If this reference points to an empty cell, this is evaluated as number 0 for the cell value. I see this behavior in LibreOffice and in Excel.

    Where is it specified that the result in cell A6, A8 and A10 is the number 0?

    Kind regards,

    Regina



    ------------------------------
    Regina Henschel
    The Document Foundation
    Dortmund
    ------------------------------


Related Content