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 20 days ago

    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