LibreOffice Logo LibreOffice Logo Extensions, Documentation and Templates repository

logo256 LibrePythonista

LibrePythonista is an extension for LibreOffice Calc. The extension allows Interactive Python code to be run directly in a spreadsheet.

★ ★ ★ ★ ☆
Calc
Download latest

latest release: 2025-01-14 23:07:51

Description

Intro

LibrePythonista has its own PIP package manager to install additional Python packages.

LibrePythonista is currently in beta and is subject to change based on feedback.

LibrePythonista is free and open source software so there are no fees to start using it.

LibrePythonista bring the power of Pandas, Matplotlib and much more to LibreOffice Calc.

All python code is executes on your local computer. This can alleviate many concerns around data privacy as your data

Using LibrePythonista is it possible to create Data frame's, Series, custom Graphs an much more directly in a spreadsheet.

LibrePythonista is built using https://python-ooo-dev-tools.readthedocs.io/en/latest/index.html which removes many barriers when working with the LibreOffice API. When installing this extension it is not necessary to install OOO Development Tools ExtensionPandas Extension or Python Numpy Extension as the libraries are included with this extension.

Watch the Introduction Video

Watch Intro video on Youtube

Resources

FAQ

Q: How do I remove all the files when uninstalling LibrePyhtonista?
Answer

LibrePyhtonista is uninstalled as an extension it does not automatically uninstall Python files. This is a feature and not a bug. To remove the python files Open the extension manager. Choose options for LibrePyhtonista, go to the uninstall section and uninstall packages.
See Also: Readme - Uninstall

Q: How do I activate the experimential python editor?
Answer

The experimential python editor is not activated by default. To activate the experimential python editor Open the extension manager. Choose options for LibrePyhtonista, go to the LibrePyhtonista Options section and check the box for the Use experimential python Cell Editor. Click OK and restart LibreOffice.

Q: Does the experimential editor work on all platforms?
Answer

The experimential python editor should work fine on Windows and on Mac OS.
On Linux the experimential python editor may not work as expected.

Linux has different flavours of LibreOffice:

  • LibreOffice installed via the package manager: The editor should work fine.
  • LibreOffice installed via a snap package: The editor is not yet supported.
  • LibreOffice installed via Flatpak. The editor is supported when extra flatpak package is installed

To install the extra Flatpak package see LibrePythonista Flatpak Editor Wiki

Issues

Report any issues to Issues page.

Homepage: https://github.com/Amourspirit/python_libre_pythonista_ext

Repository: https://github.com/Amourspirit/python_libre_pythonista_ext

Release Description Compatibility Operating Systems License Release notes Updated  
0.7.0 0.7.0 Release 7.0 Linux, Windows, macOS MIT New experimental editor. Can be turned on in extension options.

Now it is possible to uninstall the extra python packages that are installed as support for the extension.
2025-01-14 21:34:53 Download
0.5.1 Version 0.5.1 Release 7.0 Linux, Windows, macOS AL Fixed import override issue on install. 2024-10-26 11:55:36 Download
0.5.0 Version 0.5.0 Release 7.0 Linux, Windows, macOS AL This release fixes the issue of non-LibrePythonista documents being modified. 2024-10-24 21:34:40 Download
0.4.2 Version 0.4.2 Release 7.0 Linux, Windows, macOS AL Fix for an import error 2024-10-16 18:14:27 Download
0.4.1 Version 0.4.1 Release 7.0 Linux, Windows, macOS AL Upgraded to OOO Development Tools version 0.48.0 adding new features. 2024-10-12 18:50:59 Download
0.4.0 Version 0.4.0 Release 7.0 Linux, Windows, macOS AL Better support for embedded python version that need linking for binary files. 2024-10-07 16:09:33 Download
0.3.2 Version 0.3.2 Release 7.0 Linux, Windows, macOS AL Improved installer and update language files. 2024-10-06 19:09:18 Download
0.3.1 Version 0.3.1 Release 7.0 Linux, Windows, macOS AL Updates for more robust installer. 2024-10-03 23:30:54 Download
0.3.0 Version 0.3.0 7.0 Linux, Windows, macOS AL Improved multi sheet support 2024-10-02 23:51:35 Download
0.2.0 Version 0.2.0 7.0 Linux, Windows, macOS AL Support for PIP Packages 2024-09-30 21:25:16 Download
0.1.5 Version 0.1.5 7.0 Linux, Windows, macOS AL Minor fixes 2024-09-22 20:10:13 Download
0.1.1 0.1.1 Initial release 7.0 Linux, Windows, macOS AL Initial Release 2024-09-04 00:30:35 Download
Show more

Related Extensions

calendrier annuel imprimable

Screenshot for calendrier annuel imprimable

modèle de document en plusieurs langues qui propose un caledrier multilangues

01-2025

136

Not rated yet

Ewiger Kalender, Calendar, Feiertage, Geburtstage, Termine, Urlaubsplanung, Schulferien

Logo for Ewiger Kalender, Calendar, Feiertage, Geburtstage, Termine, Urlaubsplanung, Schulferien

Kalenderjahr eingeben und Geburtstage, Feiertage, Schulferien und wiederkehrende Termine werden autom. eingetragen. Einmal-Termine werden direkt im Kalender vermerkt. Das Alter der Personen wird errechnet. Urlaubstage werden kumuliert.

01-2025

650

Not rated yet

おタカラツールズのフィル

Screenshot for おタカラツールズのフィル

Calc用の拡張機能です。
罫線のある表や塗りつぶしがある状態でテキストのみをフィルします。
 
 

12-2024

155

Not rated yet

try: import

Logo for try: import

Displays the result of trying to "import <Library>" in Python.(Calc Template)

11-2024

155

Not rated yet

PyPi Reader

Screenshot for PyPi Reader

Get release information from RSS in the PyPi-library.(Calc Template)

11-2024

48

Not rated yet

waterfall chart

Screenshot for waterfall chart

this template offers a simple solution for creating chart a waterfall or cascade chart

09-2024

340

Not rated yet

Feedback

★ ★ ★ ★ ☆

Post your review

You cannot post reviews until you have logged in. Login Here.

Reviews

  • Frank Nov 16, 2024, 5:08 AM (2 months ago)

    ★ ★ ★ ★ ★

    Very promising! I hope this finds more support.

  • gio art Nov 7, 2024, 8:08 AM (2 months ago)

    ☆ ☆ ☆ ☆ ☆

    Installed on Windows, but Sophos Antivirus find a problem with the extension and stop Libreoffice from working

    • :Barry-Thomas-Paul: Moss Nov 8, 2024, 4:23 AM (2 months ago)

      Please don't leave bad reviews here for issues that are no fault of LibrePythoista.

      Open a issue on https://github.com/Amourspirit/python_libre_pythonista_ext/issues where we can have a community discussion about such issues.

      • Frank Nov 16, 2024, 5:11 AM (2 months ago)

        Even though I agree, I'm afraid this user must be very frustrated since it seems LibreOffice as a whole became unusable. The following information might help: Is possible to uninstall the extension even if you cannot start LibreOffice?

  • Kamen Nedev Oct 19, 2024, 11:18 AM (3 months ago)

    ★ ★ ★ ★ ★

    Excellent.

  • Juan González Sep 9, 2024, 10:55 PM (4 months ago)

    ★ ★ ★ ★ ★

    Very useful extension

RSS feed for reviews on this page | RSS feed for all reviews