Au3LibreOffice

Description

This AutoIt UDF for LibreOffice API/SDK provides tools for the automation of tasks in LibreOffice using the AutoIt Scripting language.

Currently Supported

Au3LibreOffice UDF currently provides support for the following LibreOffice components:

• Writer
• Calc Development Nearing Completion
• Base Development Pending
• Impress Development Pending

Support for other components will be provided as time permits.

Release

https://github.com/mlipok/Au3LibreOffice/releases/latest

Changes

Please see the Changelog

License

Distributed under the MIT License. See the LICENSE for more information.

Notes

• This UDF currently works only with the INSTALLED version of LibreOffice. The Portable version will Not work.
• For those using AutoIt versions older than 3.3.16.1, one internal function used for “Saving as” and “Exporting” documents uses Maps, which will Not be recognized as proper syntax in AutoIt. In Calc, all Fields related functions use Maps.
• LibreOffice uses Micrometers for sizing internally, all functions in this UDF, unless otherwise stated, use Micrometers. A converter has been created for converting to/from Inches, Centimeters, Printer’s Points, and Millimeters to/from Micrometers, for all sizing needs. _ConvertFromMicrometer, and _ConvertToMicrometer. Either for Writer (LOWriter) or Calc (LOCalc).
• LibreOffice uses the Long color format for all color settings, A converter has also been created for converting from/to Hex; (R)ed, (G)reen, (Blue); (H)ue, (S)aturation, and (B)rightness; and (C)yan, (M)agenta, (Y)ellow, Blac(K); to/from long color format. _ConvertColorFromLong, and _ConvertColorToLong. Either for Writer (LOWriter) or Calc (LOCalc).
• This UDF was first made public here: https://www.autoitscript.com/forum/index.php?showtopic=210514

Acknowledgements

• Opportunity by GitHub
• Scripting ability by AutoIt
• Thanks to the authors of the Third-Party UDFs:
  • OOo/LibOCalcUDF by @GMK, @Leagnus, @Andy G, @mLipok. OOo/LibOCalcUDF
  • “WriterDemo.au3” by @mLipok. WriterDemo
  • Printers Management UDF by @jguinch. Printers Management UDF
  • Word UDF supplied with AutoIt by @water.
• Thanks to Andrew Pitonyak for his invaluable book on writing Open Office/ Libre Office Macros, and his Macro collection document.
  • OpenOffice.org Macros Explained — OOME Third Edition
  • OpenOffice.org Macros Explained — OOME Fourth Edition
  • Useful Macro Information For OpenOffice.org
  • Andrew Pitonyak's website: https://www.pitonyak.org/oo.php
• Thanks to the maintainers
  • Thanks to @mLipok for hosting this project on his GitHub. As well as his tireless energy during the long hours of development, code review and clean-up.
  • Thanks to @donnyh13 for the initial project creation and development.
  • Big thanks to all the hard-working contributors.

Links

License
AutoIt
AutoIt Forum Post