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...

Running Excel Macros Automatically under Linux

Part of the software I work on uses an Excel sheet to store the user error messages & their translations. We run a macro which generates a set of internationalized text files & matching header...

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...

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....

HTML to RTF Converter for .NET

I've already seen lots of posts on the site for RTF to HTML and some other posts talking about some HTML to RTF converters, but I'm really trying to get a full breakdown of what is considered the...

How do use OpenOffice components without installing OpenOffice.org?

I'm working on solution for printing office documents based on OpenOffice.org UNO. My project is writing on C# .net. So my question is - it possible to use only required OpenOffice components...

Non-Access or -base QBE tool?

I'm currently looking for a QBE tool that can execute queries on PostgreSQL or MySQL. OS doesn't really matter. Reason is that we've got to do QBE at school but I don't want to use neither...

Web-based equivalent of OpenOffice.org Base or Microsoft Access?

I've currently been using Base/MS Access to create forms etc. that interface with a backend database, to save me writing a backend in PHP. Downside is that it only runs on the desktop. Is anyone...

What SQL magic do I need to turn one column into several?

I need to print some tickets, each of which has enough room to hold one set of customer details along with codes for up to five items ordered by that customer. Customers who have ordered more than...

Cloning a PHP/MySQL database app (w/ some automation) in MS Access or OpenOffice.org Base

I wasn't sure whether to ask this here or on SuperUser, so I apologize if it doesn't belong here. I created a small PHP/MySQL database app to manage the customer loyalty data for my mom's shop,...

check for existence of office.interop assemblies

I'm working on a c# project where I get input from Office documents, and right now I'm using MS Office for it. This simply means the MS Office interop components have to be present on the user's...

Applying a formula to all cells in a column, not just one at a time?

In OpenOffice.org Calc, I would like to apply a formula to a column that references a cell from the same row but in a different column. I.e., =C1*48 in cell D1, but I want all cells in column D to...

How to access openoffice.org database from command line

I have a database built in openoffice.org base (.odb). I would like to open this database using a command line sql client, such as sqlite3 or psql. Can anyone tell me how to make this work? I am...

JDBC/ODBC connection to Informix with Openoffice BASE on Windows 7. Will not show table lists

I've attempted this with ODBC drivers, and JDBC drivers. I'll list both approaches separately. ODBC approach I'm using the ODBC driver found here:...

com.sun.star.uno does not exists error

hi i was referring the following document for Web-based spreadsheets with OpenOffice.org and Dojo http://www.javaworld.com/javaworld/jw-05-2008/jw-05-spreadsheets.html?page=1 I am developing such...

What is the relation between PHP and XML?

I'm learning about PHP and web coding. Specifically, the PHP book I'm using that covers PHP 5.3 (by Matt Doyle and published by Wrox), says: XML ... lets you create text documents that can hold ...

problems with paste event and iframe on internet explorer 7

I've got a WYSIWYG editor, based on JqueryRTE (code.google.com/p/lwrte), which uses iframe as a main object and enables a few means of formatting. Still I need to sanitize pasted text, because...

SQL Simple Subtraction Query

I have a Database. It contains 2 Tables. Let me call them Table A and Table B. Table A Content: Date Name of Supplier Name of Good Delivered Amount of Good Delivered, simply put Ingrediënt A...

How to UNO read content of file in http format?

I used UNO to read content of file in local machine. It's ok. But when UNO reads content of file in http format, it shows error: Error (<class...

Identifying date types in Spreadsheet::ParseExcel

We are migrating from a MS Excel OLE based module to Spreadsheet::ParseExcel (or similar). As we have hundreds of programs using our module we'd prefer that we provide a drop in replacement i.e....

LibreOffice Java package settings vendorData

So I've got a task today, to automatize the proccess of selecting Java package in LibreOffice (when you install new Java version in GPO, you have to select new version of Java manualy in...

Elementary OS - LibreOffice/OpenOffice conflict, Dpkg error (unmet dependencies) - stuck in a loop

I have been looking at multiple pages for a few hours now but still no luck in solving this. I installed OpenOffice then tried to install LibreOffice-Draw through the app-center but encountered a...

Libreoffice Base macro - How to make visible/hide a control on a form?

I created a database Form with 2 comboboxes, Combo1 and Combo2. Combo2 visibility depends on Combo1 status: Combo1 checked, Combo2 visible; Combo1 unchecked, Combo2 hidden. I expected to find...

Basic Wrapper for LibreOffice Calc Python UDF

How is the Basic wrapper call formed to run a LibreOffice Calc Python User Defined Function using non-integer spreadsheet ranges? I'm not clear on how to declare the function properly for the...