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

Linux 4.16-rc2

It's been a quiet week, and rc2 is out. I take the fairly quiet rc be a good sign for 4.16, but honestly, rc2 is often fairly calm. That's probably because people are taking a breather after the merge window, but also simply because it might take a while to find any issues. But let's be optimistic, and just assume - at least for now - that it's because all is well. The diffstat is fairly odd, but that often happens with small rc's just because then just a couple of pulls will skew things easily in one or two directions. This time the patch is about one third architecture updates (arm64, x86, powerpc), one third tooling (mostly 'perf') and one third "rest". And yes, the bulk of that rest is drivers (gpu, nvme, sound, misc), but those drivers are still distinctly *not* the bulk of the whole patch. Go out and test, it all looks fine. Read more Also: Linux 4.16-rc2 Kernel Released

OpenStreetMap in IkiWiki and Why OpenStreetMap is in Serious Trouble

  • OSM in IkiWiki
    Since about 15 years ago, I have been thinking of creating a geo-referenced wiki of pubs, with loads of structured data to help searching. I don't know if that would be useful for anybody else, but I know I would use it! Sadly, the many times I started coding something towards that goal, I ended blocked by something, and I keep postponing my dream project.
  • Why OpenStreetMap is in Serious Trouble
    That said, while I still believe in the goals of OpenStreetMap, I feel the OpenStreetMap project is currently unable to fulfill that mission due to poor technical decisions, poor political decisions, and a general malaise in the project. I'm going to outline in this article what I think OpenStreetMap has gotten wrong. It's entirely possible that OSM will reform and address the impediments to its success- and I hope it does. We need a Free as in Freedom geographic dataset.

Linux KPI-Based DRM Modules Now Working On FreeBSD 11

Thanks to work done by Hans Petter Selasky and others, this drm-next-kmod port is working on FreeBSD 11 stable. What's different with this package from the ports collection versus the ported-from-Linux Direct Rendering Modules found within the FreeBSD 11 kernel is that these DRM modules are using the linuxkpi interface. Read more

Fedora and Red Hat's Finances