Data Formatting Expression Currency

Data Formatting Expression Currency

Data Formatting Expression Currency

Macros are incredibly powerful - especially when it comes to automating tasks such as producing a financial report in OpenOffice.org Calc; with such a report it is possible to program the macro to:

  • open a blank OpenOffice.org Calc document
  • add any required information
  • format cells in the document
  • save the document

and it can do all of this completely invisibly - just showing the end result to the user.

Initialising the Macro

As always start by ensuring that all variables have to be declared: