When creating (Impress) presentations containing source code snippets, what is the best way of including these snippets in the presentation? If possible, I would like them to be rendered with a fixed-width font and appropriate syntax coloring. An obvious answer would be to embed a screen captures from a code editor, but this causes pro...
I'm attempting to get PHP to call a batch file which will take an RTF file and convert it to a PDF using an OpenOffice macro. I've tested the batch file on the command line and it works fine, but I'm not having any luck calling and using the same batch file from PHP. My machine OS is XP professional SP 3. I'm running IIS 6 and PHP ver...
I don't know almost anything about this so if you have some experience let's share! Thanks!!! sorry Matt: OpenOffice 3.0 MySQL 5.0.75 Ubuntu 9.04 ...
I need to manipulate the ODF file format (open document format, the open office's internal format), and I need to do it in Python. It seem's ODFPy is a wonderful library for this porpouse. Unfortunately the official documentation is very poor, almost unuseful. And I can't find almost anything online (maybe it is not so popular?). Is th...
Hi, I would like to be able to automate data entry to an Open Office spreadsheet using a PowerShell script, in the same way that Excel can be automated using PowerShell (see this Scripting Guy example). Is this possible? Thanks, MagicAndi ...
I would like to be able to automate creating spreadsheets and adding data to an OpenOffice spreadsheet using a script (any scripting language is acceptable - PowerShell, Python, or even JavaScript). What is a suitable library or tutorial? ...
What are some best practices for programming a OOoBasic program? So far I know you should use XRay but there are an awful lot of weird little quirks in there as well. ...
I've heard discussion about how OpenOffice (ODF) files are compressed zip files of XML and other data. So making a tiny change to the file can potentially totally change the data, so delta compression doesn't work well in version control systems. I've done basic testing on an OpenOffice file, unzipping it and then rezipping it with zero...
Already asked but no answer: 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 page, or in some special area on the page, lab...
At home, on Linux, I've experimented with pyUNO to control OpenOffice.org using Python. I've been using Python 2.6. It all seems to work nicely. Now I thought I would try one of my scripts (run a graphical diff for ODF doc) on Windows. But when I tried to run it, I got: ImportError: No module named uno According to udk: Python UNO Br...
I have a need to be able to allow users to export their .doc files (which they upload) to a variety of formats. I got started on using OO SDK, and I set-up some custom filters using XSLT also. Everything works good and I am able to export word docs to pdf etc. However I want to run this as a web service. I wish to run this conversion se...
Hi, I'm trying to calculate F-scores (using the formula 2 * a * b / (a + b)) in OpenOffice.org Calc, and would like a and b to be the previous two cells in the same row. My problem is that while trying to define a function in OpenOffice.org Basic, I get an error that the ADDRESS and INDIRECT methods aren't defined. How would you defin...
My OS is Windows XP, and I'm using IIS 5.1 and PHP 5.2.9. I'm trying to call a PHP script from my PHP page in order to convert an RTF doc to a PDF, using OpenOffice. The script works just fine when I call it directly from the command line, but I'm not having any success getting the very same script to work when launched from my PHP w...
I'm trying to SELECT based on a date in OpenOffice Base: SELECT * FROM OrderTbl WHERE OrdDate BETWEEN #1/1/2007# AND #1/31/2007# I've tried a number of variations, but nothing is working. What is the correct syntax? ...
I want to convert an OpenOffice Impress Presentation file and convert it to HTML or JPEG. I have found a few examples, but they appear to be broken. I would like to do it, in a way that it does not matter what version of OpenOffice is installed, and I do not want to bundle any interop dlls with my application. Therefore, I am looking fo...
I'd like to import and export from a Cocoa application from/to OpenOffice format. Spreadsheets, in particular, but also potentially text. I've looked, but I can't seem to find the right combination of search words. ...
I am looking for the best documentation of Microsoft Excel's file format - 1997 - > 2003. I am not looking for ooxml. What is the best resource on the web? ...
I have this code down and this working fine from command line ... But when I put this in applet I get following error com.sun.star.lang.IllegalArgumentException at com.sun.star.comp.bridgefactory.BridgeFactory.createBridge(BridgeFactory.java:158) at com.sun.star.comp.urlresolver.UrlResolver$_UrlResolver.resolve(UrlResolver.jav...
How to load another color palette (*.soc file) in OpenOffice Writer? ...
Is there a way to embed OpenOffice inside a .NET Application? Something like the use of the DsoFramer in case of MS Office. ...