openoffice.org

How to do a simple mail merge in OpenOffice

I need to do a simple mail merge in OpenOffice using C++, VBScript, VB.Net or C# via OLE or native API. Are there any good examples available? ...

Is it possible to do the Navision 5.0 export to Word/Excel to OpenOffice.org?

Navision 5.0 includes a feature to export to Word or Excel. Is it possible to make this work with OpenOffice.org Writer or Calc instead? If so, what has to be done to set it up? I have been told by my Navision reseller that the feature works best with Office 2007, and export to Excel 2003 works. No mention of Office 2000 (which is wh...

What is the location of OpenOffice.org templates in Linux?

I'd like to install some presentation templates, but don't know where to put them... Thanks a lot ...

How do you extract macros programmatically from OpenOffice.org Writer document using .NET?

How do you extract the Macro code from an OpenOffice.org Writer document using the .NET API? I got an answer to the "Office 2007" version of this question, but we are evaluating OpenOffice as an alternative -- if anyone has any experience with this, any tips or resources would be appreciated. ...

Good way to create PDF from Office documents in Java

I'm looking for a good way to convert Office (mostly Microsoft) documents to PDF in Java. I've been looking at using the OpenOffice SDK but from the samples I've looked at it looks like this requires having OpenOffice running in server mode to do the work. Does anyone know of a good way to do this? Good meaning the less external require...

Converting OOo macros to Excel macros

I have an OpenDocument spreadsheet with macros in StarBasic/OOoBasic that I want to convert into an Excel spreadsheet, with the StarBasic macros translated to VBA. While OpenOffice.org claims to have the ability to translate VBA macros to StarBasic and back, my attempts to have OOo convert these original StarBasic macros to VBA have all ...

List Comprehension in an Open Office Spreadsheet

List Comprehension is a very useful code mechanism that is found in several languages, such as Haskell, Python, and Ruby (just to name a few off the top of my head). I'm familiar with the construct. I find myself working on an Open Office Spreadsheet and I need to do something fairly common: I want to count all of the values in a range ...

exporting mysql data to ODF with php

Hello, I would like to know if someone triend exporting data from MySQL to an ODF format ? Any information / documentation would be very much appreciated. I am going to try to export a MySQL result set to ODF spreadsheet if possible. ...

Is it possible to create a custom distribution of OpenOffice, or a way to package it into my java application?

I've got simple java-based ppt->swf sub-project that basically works. The open source software out there, OpenOffice.org and JODConverter do the job great. The thing is, to do this I need to install OO.o and run it in server mode. And to do that I have to install OO.o, which is allot of software (~160MB) just to convert the source PPT...

Script to associate an extension to a program

My customer is replacing MS Office with OpenOffice in some workstations. My program export a file to Excel using the .xml extension (using open format) and opens it using the current associated program (using ShellExecute) The problem is that OpenOffice does not register the .xml extension associated with it. Manually association works...

A good Code snippet tool or plugin for Word documents?

Does anyone know of a good tool or plugin that enables Microsoft Word or OpenOffice Writer to add code snippets to a document in a clean manner? I'm not sure if such a plug-in even exists, so redirecting me to any other tool that can help me would be appreciated. ...

What are the major drawbacks to using OpenOffice DB vs. Microsoft Access?

I know that Open Office Database uses a java database backend. Does anyone have any insight on how this compares to the Jet Database Engine? Also is the query designer/reporting nearly as robust as MS Access? ...

How to create .odt files with C#.NET?

Note: I found this "Creating a Word Doc in C#.NET", but that is not what I want. Do you know how to create a .odt to create file from C# .NET? Is there a .NET component or wrapper for an OpenOffice.org library to do this? Thanks! ...

Migrating Java UNO code from OpenOffice 2.4 to 3.0

I had a nifty small tool written to convert spreadsheets to plain text. Since it was my private hacker tool, it relied on OpenOffice 2.x to read the files. But when I installed OpenOffice 3 and tried to get it get it to run, I failed miserably, because I'm either missing some JAR files or half the classes have been replaced. I'm includ...

How to read an Open Office spreadsheet?

How can I read an Open Office 3.0 spreadsheet (.ods) from Groovy? I'd like to select specific columns from a named worksheet. Ideally, it would be useful to add a 'where' clause, or other criteria clause. ...

Multipart text field in pdf form, using OpenOffice Writer

So, this might be a crazy idea, so bear with me. [warning: hackish] Using OpenOffice.org Writer, one can easily make simple pdf forms (since Writer does XForms, and can export to PDF, and embed the form using FDF). I'd like to make a text entry field with this property: if the field overflows, put the overflow on an additional pa...

getting pywin32 to work inside open office 2.4 built in python 2.3 interpreter

I need to update data to a mssql 2005 database so I have decided to use adodbapi, which is supposed to come built into the standard installation of python 2.1.1 and greater. It needs pywin32 to work correctly and the open office python 2.3 installation does not have pywin32 built into it. It also seems like this built int python install...

What is the (single) best online source for learning OpenOffice.org scripting API

I am using OpenOffice.org for most of my not so very frequent Office Suite needs and most of the time it is more than adequate replacement for it's commercial alternative. Where it falls short though is the scripting API. I am yet to find the documentation that would make sense of the API in a way that would let me concentrate on my tas...

using jython and open office 2.4 to convert docs to pdf

Hi guys I completed a python script using pyuno which successfully converted a document/ xls / rtf etc to a pdf. Then I needed to update a mssql database, due to open office currently supporting python 2.3, it's ancientness, lacks support for decent database libs. So I have resorted to using Jython, this way im not burdened down by runn...

OpenOffice spreadsheet import into HSQLDB

OpenOffice ships with HSQLDB. Is it possible to easily import the contents of an OO spreadsheet into the built in database? An added nice to have would be to include the formatting of the cell contents. ie. colors, line feeds, etc. This question has gone unanswered so I'm offering a bounty. Please provide the code to the solution. ...