Apache OpenOffice Logo - Code Builders, LLC
Great Software

Why Apache OpenOffice

Apache OpenOffice is the leading open-source office software suite for word processing, spreadsheets, presentations, graphics, databases and more. It is available in over 100 languages and works on all common computers. It stores all your data in an international open standard format and can also read and write files from other common office software packages. It can be downloaded and used completely free of charge for any purpose.

Open Architecture

Extensible Framework

OpenOffice offers a complete framework allowing it to be enriched. OpenOffice allows for both "extensions" and "templates". An extension is a third party tool that brings AOO new functions. This can be done through addons, addins, deployed by UNO packages. Templates are document setups designed for specific uses.

We can provide extensions to add functionality or customize OpenOffice to suit individual needs. Some previous projects include:

Project 1

A large chain restaurant owner wanted to use MS Office documents with OpenOffice instead of MS Office in approximately 2000 restaurants.

Problem 1
Filesystem access need to be limited. Save, Save As, and Open commands could only be from "C:MyDocuments" directory or below and limited to "Word", Excel", and "Powerpoint" file types.
We created an extension to replace the standard Save, Save As, and Open commands with commands to only allow saving to "C:\My Documents" directory or below.
Problem 2
OpenOffice and custom extensions needed remotely installed to all stores.
We created a complex solution that included:
  • Creating a custom silent-installer that included the "bundled" extensions that are not removable by a user.
  • Modifying the OpenOffice installation's configuration files.
  • Included a batch file to create the "My Documents" directory and run msiexec with options for setting OpenOffice as default for the MS file formats and copy extensions into the proper location.
  • Included an extension to disable the "first start wizard" that prompts users for things like user name, company, etc during the first app launch.
Problem 3
Issues with import of CSV files exported from Microsoft Office into OpenOffice due to non-standard use of quotes and commas.
Replace Open command to intercept the opening of CSV files and parse into XLS format bypassing OpenOffice import dialog box and settings.

Project 2

An equipment manufacturer used a spreadsheet application to display current part and repair pricing to service companies...

Problem 1
Update an outdated OpenOffice.org 2 addin written in C to Apache OpenOffice 3 for use in all supported operating systems.
We recreated the addin in Java using the AOO plugin for NetBeans to create an new addin usable by all operating systems.
Problem 2
Improve database query performance of a Calc addin written in C.
The previous application opened one database connection per spreadsheet row. We used Java JDBC connection pooling to create a solution resulting in a 10x increase in performance over the previous application.
Commitment to Open Source

OpenOffice Involvement

Carl Marcum, owner of Code Builders, has been an active Apache OpenOffice committer. former Podling Project Management Committee member during incubation, and current Project Management Committe member at the Apache Software Foundation. This makes us one of a few companies that are uniquely qualified to provide quality extensions for OpenOffice.

Apache OpenOffice, OpenOffice.org, and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.

Copyright © 2011-2022 Code Builders, LLC All Rights Reserved.
Web Application by Code Builders, LLC
Powered by MyBusiness ™ v.3.3