what language do I need to write macros in LIbre Office Calc?

python macros libreoffice calc
dwstein picture dwstein · Jul 24, 2012 · Viewed 29.3k times · Source

I've written a bunch of VBA code for various things in Excel. I'm looking at migrating to libreOffice. Under Tool->Macros->Organize Macros: the two choices are LibreOffice Basic and Python.

Should I learn one of those, both, or something else. Am I wasting my time altogether? Any suggestions appreciated.

Answer

pat34515 picture pat34515 · Jul 24, 2012

Python is the way to go.

Start here: http://wiki.python.org/moin/BeginnersGuide

And no, you're not wasting time. You'll look back and say, why didn't I do it sooner.

Related questions

How to run python macros in LibreOffice?

When I go to Tools -> Macros -> Organize Macros -> Python I get this dialog: It is not possible to create new Python macros. Apparently LibreOffice has no Python editor so I have to write the …

Read More
Jinja2 inline comments

How can I put comments inside Jinja2 argument list declaration ? Everything I have tried gives an error: jinja2.exceptions.TemplateSyntaxError: unexpected char u'#' {{ Switch('var', [('1', 'foo'), # comment 1 ('2', 'bar'), ## comment 2 ('3', 'rum'), {# comment 3 #} ]) }} {% macro Switch(…

Read More
Python-like C++ decorators

Are there ways to decorate functions or methods in C++ like in python style? @decorator def decorated(self, *args, **kwargs): pass Using macros for example: DECORATE(decorator_method) int decorated(int a, float b = 0) { return 0; } or DECORATOR_MACRO void decorated(…

Read More