Language Selection

English French German Italian Portuguese Spanish

Writing a Program to Control OpenOffice.org

Filed under
OOo

In Part 1, we studied the fundamental concepts of OpenOffice.org's software development kit (SDK) and how the SDK can be used to communicate with the OOo programs. We now are ready to write an application. As previously stated, we are going to develop a program that is able to interact with OpenOffice.org's spreadsheet application, Calc. Two reasons are behind this choice. First, solving the problems raised in creating this program will acquaint us with many of the most important aspects of UNO (Universal Network Objects) programming. Second, spreadsheets allow users to build nice reports easily. If we are able to control a spreadsheet application, it can be turned into our personal report generator.

The code that will allow our application to work with Calc can be divided into six sections, each one with its own task:

  1. Connecting to OpenOffice.org

  2. Opening the document
  3. Choosing a worksheet
  4. Modifying the chosen worksheet
  5. Printing the worksheet
  6. Closing the connection

Part 1

Part 2.

More in Tux Machines

HandyLinux 2.0 Beta Now Available for Download, Based on Debian 8 Jessie - Screenshot Tour

The availability of the Beta version of the upcoming HandyLinux 2.0 computer operating system has been announced today, March 30, on the distribution’s website, which has been redesigned to match the look and feel of the OS. Read more

DebEX Barebone Is the First Debian 8 Jessie Live CD with Xfce 4.12

Arne Exton had the pleasure of informing Softpedia earlier today, March 29, about the immediate availability for download of a new build (150329) of his DebEX Barebone computer operating system derived from the upcoming Debian GNU/Linux 8 Jessie distribution and built around the recently released Xfce 4.12 desktop environment. Read more

Linus Torvalds Announces Linux Kernel 4.0 RC6, Final Version to Be Released Soon

Linus Torvalds had the pleasure of announcing today, March 29, the immediate availability for download and testing of the sixth Release Candidate (RC) version of forthcoming Linux 4.0 kernel. Apparently, some important bugs have been squashed, which means that the final Linux kernel 4.0 will be released sooner than expected. Read more

Mesa's Android Support Is Currently In Bad Shape

While Mesa is talked about as being able to be built for Google's Android operating system to run these open-source graphics drivers on Android devices with OpenGL ES support, in reality there's a lot left to be desired. Over the years there's been a handful of developers working on Android Mesa support to let the popular open-source graphics drivers run over there -- from the Intel driver now that they're using HD Graphics within their low-power SoCs (rather than PowerVR), AMD has made a few steps toward Android netbook/laptop devices with Radeon graphics, and we're starting to see Gallium3D drivers for Qualcomm Adreno (Freedreno) and the Raspberry Pi (VC4) where there's interest from Android users. This year as part of Google Summer of Code we also might see a student focused on Freedreno Android support. Read more