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: Some Excel Spreadsheet Values Seem To Be Missing
Viewed 2242 times since Fri, Nov 9, 2007
CR: CR1.1 - Notes and Causes Problem
Viewed 2115 times since Fri, Nov 9, 2007
CR: Too many decimal places in the chart data grid for an Excel column that is calculated by a formula
Viewed 3760 times since Fri, Nov 9, 2007
CR: CR1.1 - Charts in the Chart Workspace do not print all of the charts
Viewed 2071 times since Fri, Nov 9, 2007
CR: Time Display
Viewed 2107 times since Fri, Nov 9, 2007
CR: Background on out-of-control test rules
Viewed 2325 times since Fri, Nov 9, 2007
CR: Charts not working on a new PC
Viewed 2049 times since Fri, Nov 9, 2007
CR: Installing CHARTrunner disables desktop wallpaper
Viewed 2099 times since Fri, Nov 9, 2007
CR: Show every date on the chart
Viewed 2244 times since Thu, Jan 31, 2008
CR: A custom query for Length of Stay data
Viewed 2581 times since Fri, Nov 9, 2007