Forcing gnumeric to load a virtual environment python3 instance
I'm on a Debian 12 distro, using gnumeric-1.12.55 and trying to use a python module which is not packaged in Debian system, namely CoolProp. At the end, the workaround of creating a pseudo-segregated environment with the scheme as suggested in /usr/share/doc/python3.11/README.venv:
e.g. instead of running: $ pip install --user foo
run:
$ mkdir -p ~/.venvs
$ python3 -m venv ~/.venvs/foo
$ ~/.venvs/foo/bin/python -m pip install foo
did the job of installing the wanted python module. The problem now is: how to tell gnumeric to spawn the virtual environment (venv) python instance while loading a gnumeric python plugin which relies on the above python module. I tried to navigate the relevant gnumeric plugin loader source code without being able to get off the sticky mud. I just noticed that once the Python_functions plugin is used, by calling one of the functions contained in, the combo selector in the Python console is giving a chance to choose the interpreter. I'm confused about the possibility I may have to solve this issue. I need some experienced programmer to suggest some path to go forward.
Thank you