Tagged: LibreOffice

4

How to create Sparklines in LibreOffice Calc

I love using sparklines. I use them everywhere from Google Sheets to web pages. Popularized by Edward Tufte. It’s usually a small line chart without axes or coordinates. Like this . I like them because they go very well with text, without disturbing the flow but significantly adding to the information display. Sparklines...

Screenshot of Python Cosole 3

Python in LibreOffice Macros

Table of Contents1 Macros and Security2 Install3 Create python directory4 APSO – Alternative Script Organizer for Python5 Write your script live6 Save your script and debug7 What next? Are macros still useful? I think yes. Macros give the users ability to programmatically script the content. This can be really useful in many situations...

3

Using SQLite with Libreoffice Base on Linux

Table of Contents1 System2 Install SQLite3 and Libreoffice Base3 Install UnixODBC4 Install SQLIte ODBC Driver5 Configure ODBC – Driver6 Configure databases to be used by ODBC – Data Source Name (DSN)7 Use your SQLite in Libreoffice Base7.1 Setup7.2 Create a Report8 Remember9 Footnotes I love SQLIte for its simplicity, portability and stability. Most...