Q: LO 2026.02 / pip / Python Macros

Hi,

I have some difficulty (on Debian 12 ARM64) with switching from LibreOffice 25.2.3.2 (stock debs from distro) to 26.2 (debs from libreoffice.org).
There will be no 26.2 version of LO for Debian 12 even in backports. Upgrading to higher version to Debian is quite cumbersome since its Raspberry Pi used to control machinery, and LO is integral part of this system.
In general, LO 26.2 (debs from libreoffice.org) works as expected on Debian 12 ARM64 except Python macros called from within Calc spreadsheet.

New LO 2026.2 uses built-in Python interpreter instead of default provided by host OS.

I installed modules with pip (as root, since everything inside /opt/libreoffice26.2/program/ is owned by root):

/opt/libreoffice26.2/program/python -m pip install pyfirmata paho-mqtt distro bitstring tendo schedule jsonpickle tqdm

Installation went fine, yet none of these modules could be loaded by Python script (invoked from within Calc spreadsheet) located in ~./config/libreoffice/4/user/Scripts/python.
This is quite strange since everything installed with pip should be in default Python search path.

Anyone have any idea what went wrong?
Thanks in advance.
Andrei

Debian 13 (trixie) is »stable« since August 2025!

DONT pip as root!…NEVER!
but now you have to uninstall the mentioned packages as root and then (as normal user):

/opt/libreoffice26.2/program/python -m pip install pyfirmata paho-mqtt distro bitstring tendo schedule jsonpickle tqdm