PythonInLibreOffice

Running PythonLanguage in a FreeSoftware SpreadSheet like LibreOffice should be super powerful.

And therefore, exactly the kind of thing you'd think would be easily available and well developed.

Unfortunately, it's an incredible faff.

I've found some good recent tutorials here : https://tutolibro.tech/2019/07/26/libreoffice-calc-python-programming-part-1-requirements/

https://tutolibro.tech/tutolibro/

Well worth checking out because if you want to do this, this is the best intro I've found.

https://tutolibro.tech/2020/03/11/libreoffice-calc-python-programming-annex-1-assign-a-python-macro-to-a-key/

https://stackoverflow.com/questions/7591656/how-can-i-call-a-python-macro-in-a-cell-formula-in-openoffice-org-calc

https://extensions.libreoffice.org/en/extensions/show/apso-alternative-script-organizer-for-python

See also :

• Resolver Systems was an attempt to make a Pythonic spreadsheet. It's long gone, but there's an open-source remnant as DirigibleSpreadsheet