LibreOffice macros

Need help with C, C++, perl, python, etc?

LibreOffice macros

Postby enigma158an201 » 2019-01-12 13:30


I have written some macros on LibreOffice v6 under Windows version (i'm not very proud of that), and i would need some help to import these macros module in a Linux debian or mint version of libre Office

Does someone Can lead me to a good tutorial or give some support for a good way to import some modules?
i already found some .xba files in my libreoffice user data that leads to C:\Users\<my user>\AppData\Roaming\LibreOffice\4\user\basic\Standard
there is one file for each module i wrote, and one extra script.xlb that was saved in the same time

t thought that it would be enough to make a copy of these files in the corresponding folder in a linux version /home/<my user>/.config/libreoffice/4/user
-> it did not work

not to have more suprises, i made a backup of the user folder, and it seems there is also .pack files
i wil try import all .xba and .pack files
-> it did not work

i hope there is a easier way than copy and paste the script text code by creating new modules? like importing .bas files?

Nota: i'm not sure to have post this in the right subject, please be kind cause i'm a new user
Nota2: i did not succeed in consulting LibreOffice forum (seems an https problem?)
Nota3: these macros are "translated" macros from vba Excel 2007 that means i wont use this ms script again under Windows
Thx in advance
there's no smoke without fire
asus ROG GL553VD with dual debian stretch / testing (4.19)
User avatar
Posts: 19
Joined: 2018-09-21 17:48
Location: Angers, France

Re: LibreOffice macros

Postby ruwolf » 2019-02-02 01:46

Does this official documentation not help you?

What does it write during your trying of importing? And how is your “it did not work” manifested/demonstrated?

What does “translated” macros mean exactly? How were they “translated”? And from what to which?
User avatar
Posts: 392
Joined: 2008-02-18 05:04
Location: Slovakia, Banovce nad Bebravou, Matice slovenskej 1260/4-7

Return to Programming

Who is online

Users browsing this forum: No registered users and 5 guests