Home » Categories » CHARTrunner

CR: CHARTrunner and Open Office

Revision Date: 2006-03-01

Problem:

Can CHARTrunner be used with Open Office?

Solution:

Open Office is "free" software that positions itself as a replacment for Microsoft Office. Open Office can be dowloaded from:

http://about.openoffice.org/index.html

Calc is the spreadsheet program within Open Office. By default, Calc stores a spreadsheet file with the .ODS file extension.

CHARTrunner cannot directly link to Open Office Calc since (as far as we know) it has no way to read .ODS files. If you know of an OLE DB or ODBC driver that can directly read a .ODS file please let us know about it. However, Open Office allows you to save a Calc worksheet in Microsoft Excel format with the .XLS file extension. When you save an Open Office Calc spreadsheet file with the .XLS extension CHARTrunner treats it just like a Microsoft Excel spreadsheet. You can chart from the spreadsheet just as if you were using Excel simply by telling CHARTrunner to open the file as a Microsoft Excel worksheet file.

Writer is the word processor program within Open Office. You can imbed a CHARTrunner chart image into an Open Office Writer document. The Writer application is similar to Microsoft Word. CHARTrunner allows you to save charts as PNG, JPG, and Bitmap images, and any of these image types may be pasted into Writer

Base is the database program within Open Office. Base uses the HSQL database engine from http://hsqldb.org, and as far as we know there is no ODBC driver or OLE DB provider that will allow CHARTrunner to fetch data from an HSQL database. If you know of an OLE DB or ODBC driver that can fetch data from HSQL please let us know about it. However, when you create a new HSQL database you have the option to link it to an external database such as Microsoft Access, dBase, Text file, ODBC or ADO (OLE DB). Since CHARTrunner can fetch data from all these data sources, it should be possible to use Base to enter or modify data and use CHARTrunner to chart the data. We successfully tested this scenario using a Microsoft Access database.

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
CR: SQL Server Stored Procedures Returns No Records
Viewed 2235 times since Fri, Nov 9, 2007
CR: Error “External table is not in the expected format” using Excel 2007 workbook
Viewed 3953 times since Wed, Oct 14, 2009
CR: Making a chart transportable
Viewed 2072 times since Fri, Nov 9, 2007
CR: A custom query for Length of Stay data
Viewed 2451 times since Fri, Nov 9, 2007
CR: Charts with large amounts of data
Viewed 1870 times since Fri, Nov 9, 2007
CR: Making an X-bar chart with a single data column
Viewed 2028 times since Fri, Nov 9, 2007
CR: Time Display
Viewed 2038 times since Fri, Nov 9, 2007
CR: Charting pass-fail data as a p-chart
Viewed 4354 times since Fri, Feb 29, 2008
CR: Why is my first row of data not included when I get my chart from Excel
Viewed 2076 times since Fri, Nov 9, 2007
CR: CR1.1 - Charts in the Chart Workspace do not print all of the charts
Viewed 2008 times since Fri, Nov 9, 2007