Apache OpenOffice Community Forum

I have a LibreOffice Basic script which i can start from within Calc with which i can select a zip file containing my CSV files and then load them into different sheets. This works well in Linux, but when i ported it to Windows it stopped working properly.

• Is it possible to create a multi-sheet ODS calc document with a python script?
• Is there perhaps an easy way to modify the ODS file of an empty calc document, so it will load my CSV files into separate sheets?
• I see that LibreOffice provides for python scripts (Tools|Macros|Organize Macros...|Python ...) but all the buttons (especially "Create...) are disabled.
  • Is it possible to enable the python macros?
  • if yes how?
  • If so, is there a documentation on how to manipulate calc files from python ?

This works well in Linux, but when i ported it to Windows it stopped working properly.

Please upload your macro code here.