Profile

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 ...

"5. 'add XLOOKUP function' issues.oasis-open.org/browse/OFFICE-4154 (cont)" If have added a new version to the proposal. If have started to create separate files for the examples. But there is a principle question: Do you want the examples as kind of primer that explains the parameters, or do ...

Hi Bal??zs, and another one: It seems to me that XLOOKUP always returns a reference. At least =ISREF(XLOOKUP(...)) returns TRUE. If that is correct, the return value should be specified as reference. Kind regards, Regina

Rename extension .txt to .odt ------------------------------ Regina Henschel The Document Foundation Dortmund ------------------------------