I would advise to write most of your code logic outside the interface-orientated architecture, following a standard code architecture, with your common NodeJS dependencies or Python libraries.īut, Javascript could be not precise enough to work nicely in your spreadsheets (even though there exists very nice libraries for numeric computation) and could be disconcerting for your Office users due to rounding errors ( 0.1 + 0.2 does not equals 0.3 in Javascript). Many other tools are using Python as well, such as AWS CLI for example. Many tools have been built for task automation on Javascript, such as Cordova (the multi-platform mobile app framework) or Grunt. Both are very present in script development world wide and are standards de facto. Java and C/C++ require compilation, are much more complex and verbose.įor a scripting need, I would advise Javascript or Python. Visual Basic is not multi-platform and would require significant changes from one plateform to another (Visual Basic, Real Basic, AppleScript…).
#Openoffice vs libreoffice file extensions mac os
Many other Python libraries are not interface-oriented, creating directly the file in the Open Document format and saving it to disk with the correct extensionįor the choice of the language, I would first insist on the multi-platform requirement, which means it’s better if the macro / script can be executed on different platforms such as Windows, Mac OS or Linux, because LibreOffice is also multi-platform and documents will be shared between users from which we cannot expect a particular platform. The API is interface-oriented, meaning your code communicate with the controller of the interface and the document has to be open. Among them are : Visual Basic, Java, C/C++, Javascript, Python. Many languages are accepted by the LibreOffice API, thanks to the Universal Network Objects (UNO). Macros are scripting for the office suite.
Which language choice for writing your LibreOffice macros ? I would recommend you to set Macro security to Medium which will not block nor allow macros but alert you to choose if you trust the editor of the document : I’ll speak about LibreOffice now, but the same is true for OpenOffice.Īnd in the menu bar LibreOffice > Preferences, enable macros LibreOffice was a fork of (when OpenOffice went under Oracle’s umbrella) and is built on the original code base.īoth are equivalent, but the usual advise is to use LibreOffice ( see the differences) since it is the project of the volunteers from the open-source community and has been developping more quickly. OpenOffice and LibreOffice are the main open-source office suites, the opensource equivalent to Microsoft Office, to create text document, spreadsheets, presentations and drawings. Interface-oriented programming in OpenOffice / LibreOffice : automate your office tasks with Python Macros
0 kommentar(er)
