Lox365 is a LibreOffice extension that adds modern spreadsheet functions like XLOOKUP to LibreOffice.
- Download the extension
Lox365.oxtfrom Releases. - Start LibreOffice > Tools > Extension Manager > Add > Select the oxt file > restart LibreOffice.
Once Lox365 is installed, just use them like you would in Excel.
| Excel | Lox365 | Lox365 completeness | Note |
|---|---|---|---|
| FILTER | FILTER | Full | |
| SORT | SORT | Partial | 1 |
| TEXTSPLIT | TEXTSPLIT | Partial | 2 |
| TOCOL | TOCOL | Partial | 3 |
| UNIQUE | UNIQUE | Partial | 4 |
| XLOOKUP | XLOOKUP | Partial | 5 |
Notes:
- Not supported:
by_col. - Not supported:
row_delimiter,ignore_empty,match_mode,pad_with. - Not supported:
ignore,scan_by_column. - Not supported:
by_col,exactly_once. - Not supported:
match_mode,search_mode.
Note that since LibreOffice Calc does not support dynamic arrays, many of the functions provided here are standard array formulas (also known as CSE formulas).
I use these functions quite often in Excel and wanted to use them in LibreOffice too, so I made this. Contributions are welcome.
Here are what others are saying about this project:
Thanks for this; great idea!
— u/timespreader
Great work, goose! 😊
— Mike Saunders
Really nice idea.
— Behzat Yildirim
Very well done to the creator of the extension.
— Jimmy
Oh, wonderful!
😀 Thanks for implementing this!
— Arne
The support of XLOOKUP is a great addition.
— Marius Spix
Pues muchísimas gracias.
— Guille
These functions are not in LibreOffice and not provided by Lox365 but are available in the latest Excel:
- RANDARRAY
- SEQUENCE
- SORTBY
- STOCKHISTORY
- TOROW
- XMATCH
These functions are not in LibreOffice but are planned to be added to Calc:
- XLOOKUP
These functions are already available in LibreOffice:
- CONCAT
- IFS
- MAXIFS
- MINIFS
- SWITCH
- TEXTJOIN
Usage
https://wiki.documentfoundation.org/Documentation/HowTo/install_extension
https://wiki.documentfoundation.org/Feature_Comparison:_LibreOffice_-_Microsoft_Office
Media
https://www.reddit.com/r/libreoffice/comments/x98nqt/lox365_xlookup_for_libreoffice/
https://www.reddit.com/r/opensource/comments/xfdmml/lox365_xlookup_for_libreoffice/
https://twitter.com/LibreOffice/status/1573232603351879682
https://fosstodon.org/@libreoffice/109046849962893237
https://es.blog.documentfoundation.org/extension-lox365-xlookup-y-mas-para-libreoffice-calc/ (es)
https://forest.watch.impress.co.jp/docs/news/1442776.html (jp)
https://www.zaikei.co.jp/article/20220928/691186.html (jp)
https://www.matsuura.com.br/2022/09/extensao-lox365-xlookup-e-mais-para.html (pt)
https://blog.libreoffice.org.tr/2022/09/23/libreoffice-calc-icin-yeni-bir-eklenti-goosepirate/ (tr)
Development
https://bugs.documentfoundation.org/show_bug.cgi?id=126573
https://bugs.documentfoundation.org/show_bug.cgi?id=127293
https://gerrit.libreoffice.org/c/core/+/131905
https://flywire.github.io/lo-p/
https://wiki.openoffice.org/wiki/Calc/Add-In/Python_How-To
https://wiki.openoffice.org/wiki/Python/Python_Language_Binding
https://wiki.documentfoundation.org/Documentation/DevGuide/Spreadsheet_Documents
https://help.libreoffice.org/latest/en-US/text/sbasic/python/main0000.html
https://api.libreoffice.org/docs/idl/ref/namespaces.html
https://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star_1_1sheet.html
https://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star_1_1uno.html
https://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/module-ix.html
https://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/AddIn.html