Ask Your Question

User uses LO Calc Macro to save draft data in LO Base and export to database server

asked 2018-12-12 11:30:17 +0100

lonk gravatar image

updated 2018-12-12 11:32:18 +0100

I would like to write codes in LO Calc Macro for accounting job.

My plan is every Lubuntu user saves her draft data in LO Base using LO Calc Macro. After she rechecks, the draft data will be exported from LO Base to database server.

May I ask 3 questions? 1. Can LO Calc macro connect LO Base to save data? 2. Where can I find connection string for question no.1? 3. What is the best database for database server in doing this (Firebird/PostgreSQL/MariaDB)?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-12-12 16:52:12 +0100

Ratslinger gravatar image

updated 2018-12-12 16:56:06 +0100


Yes you can, using macros, connect to Base from Calc or Writer and save data. Much information on connection methods can be found in a document by Andrew Pitonyak found here -> see AndrewBase document.

As for best database, this entirely depends upon what you may be doing. Each DB has its own strengths and weaknesses and only a study by you can determine which is best for your needs. It is certainly beyond the scope of a question in this forum.

Do not see any reason to save in one database then pass it to another database - Base is already connected to a database.

edit flag offensive delete link more


Thank you so much.

lonk gravatar imagelonk ( 2018-12-14 11:50:17 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-12 11:30:17 +0100

Seen: 31 times

Last updated: Dec 12 '18