openoffice.org

Grab entire document tree with OpenOffice API

I would like to grab the entire tree for a Writer document in OpenOffice 3.1. I need to collect data on all the elements in the tree, not only the Text elements. By loading the XTextDocument and doing getText() will give the XText element. More specifically, using an XEnumerationAccess from the XText will only iterate over the TextRange...

[OpenOffice & C#] Mailmerge using OpenOffice

Hello all. I'm currently trying to do a mailmerge, using C# and OpenOffice. I have a list of destanatary in my DB. I would like this to be possible : the user edit an OO document, put fields like "name" "adresse" "city" and some standard text (e.g. : "Hello Name how are you ?", edit the style, etc etc, then go to my application, cli...

Using OpenOffice from C# to convert File Formats.

Has anyone used the CLI libraries from OpenOffice that allow to use it from a .NET application? I'm trying to save a document in HTML format in the following way. You define a property that is passed as parameter to the save method. In this case I found the example to save the document as Microsoft Word 97, and it is done giving the pro...

How to convert OpenOffice ODF files to HTML

I have some ODF files with math formulas and I need to render them...or else the boss will fire me (lol). Please, is there any way to do this ? or they can only be rendered in OpenOffice ? ...

How can I set up a JDBC connection to an OpenOffice Database odb file?

For instructional purposes, I want to set up a database in a Linux environment, then conenct to it using JDBC. OpenOffice looks a lot simpler thatn MySQL, but I'm not sure how to get the connection to it set up. ...

OpenOffice::OODoc stylize text within a paragraph

I have a simple task of adding a paragraph that has some formatted text within it. I cannot figure out how to stylize the text. Example output: John Smith 200 Main Street single my $doc = odfDocument(file=> 'outputfile.odt',create=> 'text'); $doc->appendParagraph(text => "John Smith 200 Main Street single", style => "optionalParag...

Open Office org Calc (spreadsheet): limit of 64k rows?

I was using a not-so-up-to-date version of OOo.calc (Open Office Spreasheet component, version 2.04, default for RHEL 5), and bumped into a nasty surprise. When trying to import a csv file (with about 100k row), it said that there is a limitation of max 64k rows, and that remaining rows would just be discarded. I was planning to have use...

OpenOffice syntax highlighting

I have some big documentation to do that will contain pieces of code I'd like to give the conventional "coding language" syntax highlighting. I've searched the styles feature to do such a thing, but there is no way to do that (in fact I could only found a forum where people were fighting about adding this feature or not, but this is not ...

How programatically access a checkbox in .doc document in OpenOffice?

I have a strange question: in OpenOffice when opening a .doc file with checkboxes in it, I get a grey (meaning field) flat checkbox. It is different than the checkbox I can insert with the form components. I access this document with my program with the OOo UNO system, the problem is that this field doesn't appear in getTextFields so I ...

merging document with openoffice from flex (air)

Hello, i'm searching a method to merge some data from an air application to a template made with word (.doc). I've search on the web for exemple, look at the open office API, but did'nt find anything. 1- do you think it's possible from air to make a document (pdf as possible) from a existing template in .doc ? If not, i read that livecyc...

Using PyUNO on Windows and CentOS

Is there any way to use OpenOffice's PyUNO without using the version of Python that comes with OpenOffice? I mean, can I install a package (on Windows and CentOS) that uses the version of Python that's already on the server? I'm trying to use OpenOffice in headless mode so that I can do document conversion with a script (ultimately...

openoffice calc macro for CSV saving

Given: I recorded a simple macro in Openoffice to save my worksheet as a CSV file. Here it is. sub toCSV dim document as object dim dispatcher as object document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") dim args1(2) as new com.sun.star.beans.PropertyValue args1(0).N...

What dummy X server should I use with openoffice on debian?

Hi, I need to run openoffice in batch mode to turn .doc files into pdf, but openoffice won't start because it needs an X server. My linux box doesn't have one. Is there some dummy blackhole X server around I can use? I'm using debian etch. ...

Programmatically convert *.odt file to MS Word *.doc file using an OpenOffice.org basic macro

I am trying to build a reStructuredText to MS Word document tool-chain, so I will be able to save only the rst sources in version control. So far I -- Have rst2odt.py to convert reStructuredText to OpenOffice.org Writer format. Next I want to use the most recent OpenOffice.org (currently 3.1) that do a pretty decent work of generating...

How to use the OpenOffice spell checker in PB Application with OLE Object?

I am using OpenOffice in my system and already I tried about it, also i got the solution from the CodeExchange examples but i couldn't get the spell checker. ...

OpenOffice API - OptimalWidth option for table(all columns)

I am working on Java API which interacts with OpenOffice(swriter) through UNO. For TextTable, I am having hard time setting TableColumn's "OptimalWidth" property. I have tried the following code and it seems that getColumns() method cannot take me to TableColumn's property and let you only insert and remove columns. XTableColumns xCol...

Library that takes Microsoft Office files (word/excel/ppt) and renders images of them?

I'm building a webapp, and I need the ability for users to view Word/Excel/PPT files in the browser (these files are stored server-side). This is to offer them a quick way to preview the document without needing to download it and launch Microsoft Office. Pretty much looking for the "View" feature for email attachments in GMail. I'm a...

UUID in OpenOffice.org Base

How would one go about using a UUID as a primary key in an OpenOffice.org Base database? I have a need to gather data on multiple, unnetworked PCs that I can't install software on (I am using OpenOffice.org Portable). After gathering data, it will be merged into a single database. I believe that a UUID/GUID is the ideal solution, but f...

How can I tell which application of openoffice is running?

I want to look in the list of processes to determine if OpenOffice Calc is running or if OpenOffice Writer is running. With QuickStart off, I get a scalc.exe and an swriter.exe so its simple. However when the quick start is on I just get soffice.bin and soffice.exe Is there a way of asking those processes which application is running?...

How to map an XML schema to an OpenCalc spreadsheet cell and export cell data as an XML data file

I have created an XML schema for storing data. I want to provide a simple user interface with OpenCalc spreadsheet for data entry. Things which I wanted to do. Map my XML schema elements to cells of a spreadsheet. Provide this spreadsheet as an user interface for data entry. Export the entered data as an XML data file. (The exported ...