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

Ubuntu Touch OTA-14 Officially Released with Revamped Unity 8 Interface, Fixes

A few moments ago, we've been informed by Canonical's Lukasz Zemczak about the general availability of the long-anticipated Ubuntu Touch OTA-14 software update for Ubuntu Phone and Ubuntu Tablet devices. Read more Also: Ubuntu OTA-14 Released, Fixes A Number Of Bugs

Cloud convenience is killing the open source database

Open source has never been more important or, ironically, irrelevant. As developers increasingly embrace the cloud to shorten time to market, they're speeding past open source, making it even harder to build an open source business. After all, if open source were largely a way for developers to skirt legal and purchasing departments to get the software they needed when they needed it, the cloud ups that convenience to the nth degree. In Accel's annual business review, the vaunted venture capital firm writes: "'Product' is no longer just the bits of software, it's also how the software is sold, supported, and made successful." The cloud is changing the way all software is consumed, including open source. Read more

Why the operating system matters even more in 2017

Operating systems don't quite date back to the beginning of computing, but they go back far enough. Mainframe customers wrote the first ones in the late 1950s, with operating systems that we'd more clearly recognize as such today—including OS/360 from IBM and Unix from Bell Labs—following over the next couple of decades. Read more

OpenGov Partnership members mull open source policy

The Open Government Partnership (OGP) will suggest to its member governments to create a policy on open source. This week, a draft proposal is to be finalised at the OGP Global Summit in Paris. Read more