Interestingly enough, Libre Office (and OpenOffice before that) allow you to use Python internally for Macros through PyUNO, which is a pain to use given the lack of documentation, but amazingly powerful.

It was one of my first usages of Python, and used that to create quite complex Spreadsheets