[Solved] Load module when calling python in macro

[luofeiyu]

In my python console:

Code: Select all

import os
print(os.__file__)
/usr/lib/python3.11/os.py
import lxml
print(lxml.__file__)
/usr/lib/python3/dist-packages/lxml/__init__.py

Write python function for macro to call.

Code: Select all

cd  .config/libreoffice/4/user/Scripts/python
vim  hello.py
import uno
def HelloWorldPythonCalc():
    import os
    import lxml
    return None

It encounter error:

call.png (53.85 KiB) Viewed 8900 times

Why can't import the module "lxml" in basic macro?Does it means that openoffice basic macro can only support part of python libraries ?So,can't fix it?

[karolus]

Work with the Libreoffice mentioned in your signature: LibreOffice 7.4.7.2 on Debian 12

[luofeiyu]

Install package into /opt/libreoffice24.8/program with argument target:

Code: Select all

sudo python3 -m pip install  lxml  --target=/opt/libreoffice24.8/program