How to Use OpenOffice.org Spell Checker in My App (VB6)
It is possible to use Microsoft Word to spell chek an arbitrary document. What I want is to use OpenOffice.org to do the same. Is it possible? How? ...
openoffice.org
How do I reconnect to OpenOffice.org once it has been closed?
Here is a sample application that creates a Window with a single Button inside. When clicked, it connects to OOo (if not already connected) and creates a text document. This works fine unless all the documents created in OOo are closed. Then, I get a DisposedException when trying to create the next chart. This is understandable, but OO...
Generate ODT/DOC(X) and convert to PDF, without OO.o/MS
I have a WSGI application that generates invoices and stores them as PDF. So far I have solved similar problems with FPDF (or equivalents), generating the PDF from scratch like a GUI. Sadly this means the entire formatting logic (positioning headers, footers and content, styling) is in the application, where it really shouldn't be. As ...
Open Office Spreadsheet (Calc) - Concatenate text cells with delimiters
I am using Open Office's spreadsheet program and am trying to concatenate several text cells together with delimeters. For example, suppose I have the cells below: +--------+ | cell 1 | +--------+ | cell 2 | +--------+ | cell 3 | +--------+ | cell 4 | +--------+ | cell 5 | +--------+ I would like to concatenate them with delimiters s...
Delphi OpenOffice automation scalc center cell text
Hello could someone please help me with the following: I want to center the text in a scalc open office spreadsheet cell via Delphi and the OOoTools toolkit. The following code does not work: sRange := '$A$3:$A$3'; ooParams := CreateUnoStruct('com.sun.star.beans.PropertyValue', 1); ooParams[0].Name := 'ToPoint'; ooParams[0].Value := s...
OpenOffice UNO time-out?
I'm using OpenOffice (headless) to analyse (page count, title, etc.) some files from a Java application using the UNO API. However, OpenOffice file loading can last more than 1 minute, and that's not acceptable in my case. Is there any way to set a short time-out either at the UNO level or (even better) at the OpenOffice level? ...
JODConverter 3.0, OpenOffice, and JNI
I'm using JODConverter 3.0 to handle communicating with OpenOffice to convert documents. Everything is working fine except that JODConverter uses a Java library from OpenOffice that uses JNI to grab certain library files from the system. This throws an exception if I don't set the java.library.path method using -D when running java. The...
Bash environment variables and finding installation directories
I have a Bash script that basically initializes an application and sets parameters. One of these parameters is the location to OpenOffice. Now OpenOffice doesn't set an environment variable when you install it. What is the best method of finding the location of an application installed and caching that information so you don't have to d...
Extract last two words in a cell using openoffice
I need a formula to extract the last two words in a cell using openoffice. For example a cell contains the words: "enjoy the rest of your day" I would like to extract "your day" using a formula. I know how to extract the last word: =RIGHT(A1;LEN(A1)-FIND("*";SUBSTITUTE(A1;" ";"*";LEN(A1)-LEN(SUBSTITUTE(A1;" ";""))))) which results in ...
OpenOffice PDF Export Library
I am looking for a library which will allow me to render text and graphics output onto a PDF document. (Cairo is certainly an option.) I would like to know how OpenOffice writes PDF files to see if I could use the same library. What library is being used by OpenOffice for PDF export? Edit: I am looking for a C or C++ library. ...
create word doc file from linux command line
I have some HTML files that I need to distribute in MS Word doc format (don't ask!). I can manually open each in OpenOffice and then save as a doc file. But I have quite a few files so I want to automate this. Do you know a way? ...
Adobe Livecycle performance
I have installed Adobe Livecycle in order to convert MSWORD files to PDF from a web-app. Specifically, I use the DocConverter tool. Previously I have used OpenOffice UNO SDK, but I have found some problems with particular documents. Now, the conversion is ok, but the conversion time is huge. These are the times to convert documents of d...
Changing a spreadsheet formula so it works with PHP
Hello, for years now I have used a math formula to determine relative activity levels for message boards. Now I would like to use that formula in a php search engine to replace the non-functioning Google Page Ranking system. The data items used are: Members (B2), Posts (D2), Topics (C2), and the Boards creation date (E2). In the spreads...
Open Office Database Error(Shows Exception While running)
## This is the code i m runnig in linux ubuntu.. ## import java.sql.*; /** * * @author spk */ public class Connectionsetting { private static Connection con; private static java.sql.Statement sm; private static ResultSet rs; public void close() { try { sm.close(); con.clo...
combine master and detail information in query result
Using openoffice.org Base 3.1.1 Given the database below with three tables, I would like to create a query with the following output. How can this be achieved with queries or views? output book.title, tags title 1, tagdescription1 tagdescription2 tagdescription3 title 2, tagdescription2 database BOOK id - primary key,title 1, title...
How do I programmatically save a document in OpenOffice.org?
I'd like to save a TextDocument created through OpenOffice.org UNO to a file on the disk. What is the best way to do this? Edit: This is the C# code that I ended up using. document is an XTextDocument. protected void Save (string path) { string url = "file://" + path; PropertyValue [] propertyValues = { new PropertyValu...
Implement a simple many-to-many relation in a Form in OpenOffice.org's Base
I'm doing a small relational database, to be used by one person on a single computer. I chose OpenOffice.org's Base (version 3.1.1) because it's free and should be more than enough for this case. The simplified version of my problem is: I have an Articles table, with columns: ID, Title, Content, etc.... I have a Keywords table with colu...
Embedding objects into Microsoft Word and OpenOffice Writer
I am looking for some references on how to implement the following feature: ability to embed objects (e.g. diagrams) into word processors and being able to edit them in their respective "mother" application For example, MS Word and Visio work like this together, allowing the user to easily edit/tweak the diagrams after adding them ...
Is .rdb file required each time I compile my open office UNO program
Hi, Just wondering, is my program specific 'xyz.rdb' file (generated using makefile) required each time I run my program (xyz.exe) ? Can I embed the .rdb file in the main .exe file generated using VC++ 2008. If the .rdb file is not in path, I usually get the 'Registry Error'. Thanks, Aiwee ...
"Hello World" using OpenOffice 3 sample code
I am trying to program a simple "Hello World" window on WinXP MSVC 2008.NET using OpenOffice 3.0 API and SDK. The article is big for beginners... http://api.openoffice.org/docs/DevelopersGuide/OfficeDev/OfficeDev.xhtml#1_1_OpenOffice.org_Application_Environment What would the code for "Hello World" look like? ...