https://github.com/Amourspirit/python_libre_pythonista_ext Skip to content Navigation Menu Toggle navigation Sign in * Product + Actions Automate any workflow + Packages Host and manage packages + Security Find and fix vulnerabilities + Codespaces Instant dev environments + GitHub Copilot Write better code with AI + Code review Manage code changes + Issues Plan and track work + Discussions Collaborate outside of code Explore + All features + Documentation + GitHub Skills + Blog * Solutions By size + Enterprise + Teams + Startups By industry + Healthcare + Financial services + Manufacturing By use case + CI/CD & Automation + DevOps + DevSecOps * Resources Topics + AI + DevOps + Security + Software Development + View all Explore + Learning Pathways + White papers, Ebooks, Webinars + Customer Stories + Partners * Open Source + GitHub Sponsors Fund open source developers + The ReadME Project GitHub community articles Repositories + Topics + Trending + Collections * Enterprise + Enterprise platform AI-powered developer platform Available add-ons + Advanced Security Enterprise-grade security features + GitHub Copilot Enterprise-grade AI features + Premium Support Enterprise-grade 24/7 support * Pricing Search or jump to... Search code, repositories, users, issues, pull requests... Search [ ] Clear Search syntax tips Provide feedback We read every piece of feedback, and take your input very seriously. [ ] [ ] Include my email address so I can be contacted Cancel Submit feedback Saved searches Use saved searches to filter your results more quickly Name [ ] Query [ ] To see all available qualifiers, see our documentation. Cancel Create saved search Sign in Sign up Reseting focus You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert {{ message }} Amourspirit / python_libre_pythonista_ext Public generated from Amourspirit/python-libreoffice-pip * Notifications You must be signed in to change notification settings * Fork 1 * Star 53 License Apache-2.0 license 53 stars 1 fork Branches Tags Activity Star Notifications You must be signed in to change notification settings * Code * Issues 1 * Pull requests 0 * Actions * Projects 0 * Security * Insights Additional navigation options * Code * Issues * Pull requests * Actions * Projects * Security * Insights Amourspirit/python_libre_pythonista_ext This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository. main BranchesTags Go to file Code Folders and files Name Name Last commit message Last commit date Latest commit History 3 Commits .devcontainer .devcontainer .vscode .vscode Documents Documents app app dist dist examples examples images images macro macro oxt oxt src src tests tests .gitattributes .gitattributes .gitignore .gitignore LICENSE LICENSE README.md README.md conftest.py conftest.py cspell.json cspell.json make.py make.py poetry.lock poetry.lock poetry.toml poetry.toml pyproject.toml pyproject.toml View all files Repository files navigation * README * Apache-2.0 license logo LibrePythonista License LibrePythonista is an extension for LibreOffice Calc. The extension allows Interactive Python code to be run directly in a spreadsheet. 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 OOO Development Tools which removes many barriers when working with the LibreOffice API. What is LibrePythonista? LibrePythonista brings the power of Python analytics into LibreOffice Calc. Use it to process data in Calc with Python code. You type Python directly into a cell via the code edit window, the Python calculations runs locally, and your results are displayed in the sheet. 500 LibrePythonista comes with a core set of Python libraries. Use Python libraries to simplify your data analysis, find patterns and hidden insights, and visualize your data with plots. Start using Python To begin using LibrePythonista, select a cell and on the LibrePy menu, Insert Python. This tells Calc that you want to write a Python formula in the selected cell. menu_001 Alternatively insert using shortcut Shift+Ctl+Alt+L or by clicking on the toolbar button. toolbar_py_c LibrePythonista uses the custom Python function lp() to interface between Calc and Python. The lp() function accepts Calc objects like ranges, named ranges, and data ranges. You can also directly type references into a Python cell with the lp() function. For example, to reference cell A1 use lp("A1") and for the range B1:C5 use lp ("B1:C5"). For a named range with headers named MyRange, use lp ("MyRange", headers=True). If the range or named range has empty rows at the end of the range then collapse=True can be used. The collapse parameter instructs the Data frame to exclude empty rows at the end of the named range. This way when new data is added to the end of the range the Data frame will automatically recalculate to include the new rows. Example named df = lp("A2:D81", headers=True, collapse=True) The following image shows a Python in Calc calculation adding the values of cell A1 and B1, with the Python result returned in cell C1. image Code Editing When a cell contains Python code It can be edit by clicking the control and choosing Edit Code. image Or Python cells and charts can right click and choose Pythonista --> Edit Code image Image for the code editor for the example above. tri_code Other Resources * LibrePythonista Channel About No description, website, or topics provided. Resources Readme License Apache-2.0 license Activity Stars 53 stars Watchers 1 watching Forks 1 fork Report repository Releases No releases published Packages 0 No packages published Languages * Python 98.5% * Other 1.5% Footer (c) 2024 GitHub, Inc. Footer navigation * Terms * Privacy * Security * Status * Docs * Contact * Manage cookies * Do not share my personal information You can't perform that action at this time.