Writing Makros with StarBasic with XRay or MRI vs. Python in PyCharm

English
, ,
#1

Hallo everybody,

first of all i really like that there are free solutions like LibreOffice, this is very valuable for NGOs and nonprofits.

In our NGO we want to get rid of microsoft and google and so we want to implement future tasks in LibreCalc Makros. Even if I wrote some Makros in MS VBA, javascript and even some small stuff in StarBasic i think it is very hard to write scripts in StarBasic because of the IDE.

There is no codecompletion or intellisense in the normal installation and I wonder now which would be the best solution to start new Projects?

To all the experienced Developers here or those who wrote some bigger functionalities - maybee even in StarBasic and Python could you give me some advice?

1.) Would you prefer starting of with python in Pycharm (or Visual Code or Visual Studio or else) and why?

2.) Would you prefer MRI or XRay or using both and why?

3.) Do you have any proposals in general?

Thanks in advance
Richarde

#2

Abstain from all macro coding. Provide your users with well made document templates, data sources and well administered networking. LibreOffice is more about configuration rather than programming. VBA people who start the Basic IDE immediately after loading a new blank document end up disappointed and frustrated. The LO API is by far more complicated than MS Office.

2 Likes
#3

That was the answer to

  1. Xray is to MRI what OpenOffice is to LibreOffice. Some users stick to OpenOffice because it offers all they need in a way they are accustomed to. OpenOffice does not offer anything that is not in LibreOffice.
  2. I know nothing about your programming background. If you have some productive experience with Python, you will love to write office macros in Python which takes me back to point 3): you will hate this API.
1 Like
#4

Thanks for the response.

well as from language aspects the best Approach would surely python…

So I´ll try that.

Any further Answers to my initial questions are welcome.

#5

Regarding “intellisense”: Request: an easy object reference for people coming from office VBA - #14 by vib

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.