O'Reilly logo

Learn OpenOffice.org Spreadsheet Macro Programming by Dr. Mark Alexander Bain

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Starting to Work with UNOs

I'm sure you'll agree that the first step towards complete automation is the opening and closing of a spreadsheet, so let's start by seeing how OOo's UNOs can help us do that.

Opening and Closing Spreadsheets Automatically

There are a couple of things that you need to know before you can use a service:

  • Each service is stored in a module.

  • All modules are stored within a central module—com.sun.star.

  • A service is created by using the createUnoService function.

  • We're going to be using the Desktop service, and this can be found in the frame module:

So, let's look at using a UNO in a very simple subroutine that ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required