⚗️ Lox365: Modern functions for LibreOffice

Lox365 is a LibreOffice Calc extension that adds modern spreadsheet functions like IMAGE, TEXTSPLIT, and TOCOL.

Do you like using Lox365? Let me know in the Discussions. Maybe buy me a coffee.

Install or update

Download the extension Lox365.oxt from Releases.
Start LibreOffice > Tools > Extension Manager > Add > Select the oxt file > restart LibreOffice.

Usage

Use the function like you would any other function in LibreOffice Calc.

Multiple outputs

To output results in multiple cells, enter your formula with Ctrl Shift Enter.

To edit the formula that is using multiple cells, select the entire cell range first.

This is because Lox365 functions are array functions. LibreOffice Calc does not support Excel's dynamic arrays.

Syntax

FILTER (Removed)

Filters an array.

Similar to Excel's FILTER.

=FILTER(array, include, [if_empty])

array: The array to filter.
include: An array of booleans where TRUE represents a row or column to retain.
[if_empty]: Returned if no items are retained. Optional.

IMAGE

Returns an image from a given source.

The source can be a local image file or a web URL. You can use a web URL of a third-party service to generate, for example, a QR code, equation, or diagram.

Similar to Excel's IMAGE.

=IMAGE(out_cell, source)

out_cell: Reference to the cell where the image is to be placed.
source: The path of the source that points to the image.

SORT (Removed)

Sorts an array.

Similar to Excel's SORT.

=SORT(array, [sort_index], [sort_order])

array: The array to sort.
[sort_index]: A number indicating the row or column to sort by. Optional.
[sort_order]: A number indicating the desired sort order; 1 for ascending order (default), -1 for descending order. Optional.
Not supported: by_col.

TEXTSPLIT

Splits text into columns using delimiters.

Similar to Excel's TEXTSPLIT.

=TEXTSPLIT(text, col_delimiter)

text: The text you want to split.
col_delimiter: The text that marks the point where to split the text across columns.
Not supported: row_delimiter, ignore_empty, match_mode, pad_with.

TOCOL

Returns the array as one column.

Similar to Excel's TOCOL.

=TOCOL(array)

array: The array to return as a column.
Not supported: ignore, scan_by_column.

UNIQUE (Removed)

Returns the unique values from a range or array.

Similar to Excel's UNIQUE.

=UNIQUE(array)

array: The array from which to return unique rows.
Not supported: by_col, exactly_once.

XLOOKUP (Removed)

Searches an array for a match and returns the corresponding item from a second array.

Similar to Excel's XLOOKUP.

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found])

lookup_value: The value to search for.
lookup_array: The array to search.
return_array: The array to return.
[if_not_found]: Where a valid match is not found, return the [if_not_found] text you supply. Optional.
Not supported: match_mode, search_mode.

Version notes

These functions have been removed in Lox365 version 6 because you can now use them in the latest LibreOffice (24.8):

FILTER
SORT
UNIQUE
XLOOKUP

Why

I use these functions quite often in Excel and wanted to use them in LibreOffice too, so I made this.

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

Dobre rozszerzenie, bardzo przydatne funkcje.

— Piotr Osada

Pues muchísimas gracias.

— Guille

Bravo!

— Shakir Mahmud Sumon

The IMAGE function is very useful for those of us that import Google Docs that contain remote (URL base) images.

— René Haché

Keep up the great work!👍

— LeighAnne Kenney

👍😀

A 1000 thanks.

— Mikael Arling

The idea is splendid because Microsoft's IMAGE function in Excel doesn't work with local pictures or with pictures from LAN shares.

— Gabriela Salvisberg

Compatibility

Lox365 is not compatible with Microsoft Excel.

Lox365 must be installed in order to read and write Lox365 functions. You can check whether it is installed using LibreOffice Extension Manager.

On a machine without Lox365 installed, you will not be able to view calculation results from Lox365 functions.

Availability of other functions

These functions are not in LibreOffice and not provided by Lox365 but are available in the latest Excel:

GROUPBY
LAMBDA
PIVOTBY
STOCKHISTORY
TOROW

These functions are available in the latest LibreOffice:

CONCAT
FILTER
IFS
LET
MAXIFS
MINIFS
RANDARRAY
SEQUENCE
SORT
SORTBY
SWITCH
TEXTJOIN
UNIQUE
XLOOKUP
XMATCH

References

Name		Name	Last commit message	Last commit date
Latest commit History 20 Commits
.github		.github
META-INF		META-INF
pythonpath		pythonpath
.gitignore		.gitignore
COPYING		COPYING
Containerfile		Containerfile
README.md		README.md
addin.xcu		addin.xcu
build.sh		build.sh
description.xml		description.xml
extension-description.txt		extension-description.txt
icon.png		icon.png
image1.png		image1.png
image10.png		image10.png
image2.png		image2.png
image3.png		image3.png
image4.png		image4.png
image5.png		image5.png
image6.png		image6.png
image7.png		image7.png
image8.png		image8.png
image9.png		image9.png
interface.idl		interface.idl
loader.py		loader.py

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

⚗️ Lox365: Modern functions for LibreOffice

Install or update