Description: Libreoffice Programming Resources and Snippets for LOFFICE Calc Spreadhseet

Descrição: Recursos de programação e esqueletos de código para a planilha Libreoffice Calc

Files:

• Algorithms.js : Libreoffice calc algorightms of Financial Functions ported to Javascript

Convert html to pdf

$ libreoffice --headless --invisible --nologo --convert-to pdf *.html

Convert Doc to Text

libreoffice --headless --convert-to txt:text --outdir "/tmp/outdir" "/path/to/file.doc"

$ Convert to pdf in command line (put it in .bashrc)

cpdf () { libreoffice --headless --convert-to pdf "$1" }

• It is not possible to edit/debug a Python macro within OpenOffice, it has to be edited with an external editor and can only be executed in OpenOffice. Debugging can be a little bit difficult

Baisc

• http://www.openoffice.org/documentation/manuals/

• Writing a Macro in LibreOffice Calc

• Calc Macros Automating repetitive tasks

• Programming OpenOffice.org with Visual Basic

• Convert VBA to OpenOffice Basic

• Programação de Macros com LibreOffice Basic

Python

• Open Office Wiki Documentation

• Libreoffice API

  • XScriptContext.html

• Writing Calc Functions in Python

Examples:

• LO Programming Documentation
• Examples of Macros, in Japanese: http://openoffice3.web.fc2.com/Python_Macro_Calc.html
• A simple Python Macro in LibreOffice 4.0
• Tutorial de macros em Python no OpenOffice.org
• Python Macros para o Openoffice

Python Macro Directory: /usr/lib/libreoffice/share/Scripts/python

User Script Directories:

Linux:

~/.config/libreoffice/3/user (since LibreOffice 3.5.0)
~/.libreoffice/3/user (prior to LibreOffice 3.5.0)

Darwin/MAC/OSx:

/Users/<user name>/Library/Application Support/libreoffice/3/user

Windows:

	Before Vista: \Documents and Setting\<user name>\Application Data\libreoffice\3\user
    From Vista: \Users\<user name>\AppData\Roaming\libreoffice\3\user

$ sudo apt-get install libreoffice-script-provider-python

$ sudo apt-get install python-uno