23 Sep 2022

Lox365 extension: XLOOKUP (and more) for LibreOffice Calc

Posted in Development, Extensions, LibreOffice By Mike Saunders On September 23, 2022

More news from the LibreOffice subreddit! User goose_pirate posted about an extension:

Hi everyone, I made this little extension for LibreOffice Calc which adds a few functions, currently FILTER, SORT, and XLOOKUP. I hope others will find this as useful as I do.

XLOOKUP is a function for finding things in a table by range or row. We asked goose_pirate for a bit of background on the extension:

I’ve been using both Excel and LibreOffice for many years and found the new(er) Excel functions like XLOOKUP to be really nice compared to the old VLOOKUP or INDEX MATCH. I wanted to use it in LibreOffice too, so I wrote this extension.

How I made it: I researched information about LibreOffice extensions, dissected a few such extensions made by others, and finally started my own. It wasn’t too bad, I was surprised no one has made something similar yet.

Great work, goose! 😊

Learn more and download here (in the “build” folder)

Comments

  2. By Mighty_Word

    Hello. This should be implemented into the core version of LO.

  3. By Pete

    That’s great news that Calc now supports FILTER, SORT, and XLOOKUP via an extension. Actually, there is an effort by Winfried Donkers to support XLOOKUP as a core functionality of Calc, but it is not finished yet: https://gerrit.libreoffice.org/c/core/+/131905
    Maybe you could join forces to finally have the functions in core Calc.

  4. By Jimmy

    I don’t use these functions but the question should be asked why isn’t this functionality in the main application compared to an extension? if it is development resources well now you have the ‘template’ how it is done.
    Very well done to the creator of the extension.

  5. By Arne

    Oh, wonderful! Bug #127293 has been open way too long! 😀 Thanks for implementing this!