I have a button which launches a macro in OpenOffice. Within the macro, I want to change the name of the button. The original code for Excel is ActiveSheet.Shapes("PunchButton").select Selection.Characters.Text = "Punch In" but the first line does nothing. I've checked the sheet in OpenOffice and the button has the right nam...
I have packaged an XSLT export filter for OpenOffice as per the instructions on this page: http://wiki.services.openoffice.org/wiki/Filter_extensions It works fine; but in order to be used, the user has to select the command 'File/Save as' then choose the correct file extension that triggers the use of the filter, and a target file n...
What is the experience of working with OpenOffice in server mode? I know OpenOffice is not multithreaded and now I need to use its services in our server. What can I do to overcome this problem? I'm using Java. ...
Let us say that we have two columns in a spreadsheet. Is it possible to perform set operations on the two columns and save the result in a third column? For eg. Col1 Col2 Col3 --------------------- A B A C D F F C D Here Col3 = Col1 - Col2 where "-" is a set operation. Is there a way to do this in Openoffice Ca...
When I write papers or documentation it makes think using LaTeX or OpenOffice is overkill as I usually only need some markup elements (bold, headlines, lists, ...) . I'd like to write my documents using a wiki style markup as this is very efficient. For example: = Introduction = '''HTML''' is a markup language... In the end I'd like ...
I have this simple code in php: <?php header("Content-type: application/vnd.ms-word"); header("Content-Disposition: attachment;Filename=kid_tag.doc"); echo '<table cellspacing="0" cellpadding="0" border="0" width="8.4cm"> <tr> <td colspan="3" style="text-align: right; height: 0.6cm">Nursery</td> </tr> <tr> <td ...
I'm interested in creating one or more spreadsheet graphs of interval metered data. The raw data is recorded as a continuously increasing value (i.e. total bytes, user logins, website hits) and date. Each sample measurement date will happen at a non-constant interval. For simplicity I would like to record the data in a spreadsheet progra...
I need to find a way to quickly convert a latex document into a Microsoft Word 2003 document. I'm using Kile to edit latex documents on Ubuntu at present. I can do it the following way: latex filename.tex tex4ht filename.tex mk4ht oolatex filename.tex then I have to open the resulting filename.odt document in OpenOffice and save as ...
That's important for good documentation, but currently it just doesnt work well. If I copy source code from Xcode editor into OpenOffice Writer, then every single line is an own paragraph. I have a paragraph style for source code, but because of multiple paragraphs I get a lot of unnecessary spaces. Could i program a macro that combines...
We currently generate reports in MS Excel format. Our client just called to ask if we could generate those reports in OpenOffice format instead. Their reason is that their entire office is being purged of Microsoft Office, as their license has expired, and they are no longer willing to renew their license. As a consequence, they want ...
I want to count the no. of pages that would be produced if I printed out an OpenOffice.org document. I can already do it for ODT files using the following code: public short getPageCount() { XModel model = (XModel) UnoRuntime.queryInterface(XModel.class, getDocument()); XTextViewCursorSupplier s...
Subversion's "keyword" feature is great to automatically tag text files with the revision number. I'd really like to do a similar thing for Word and/or OpenOffice documents. I tried this with Word documents, by inserting a "fixed-width" keyword substitution into the "comment" document properties field. But it seemed to still corrupt the...
I'm working on an Open Office document with a partner and we are using subversion to collaborate on it. However, we are saving the document as a .odt file and subversion reads this as a binary file type. Therefore it has me worrying that when we go to merge the files and the diff pops up that we will not be able to adequately perform the...
I have installed Openoffice.org3 on our server and it's running in headless mode. We use it with jodconverter to convert word and excell files. It used to work fine, but one day it just stopped working and I really don't understand why. When I run /usr/local/bin/java -jar jodconverter-2.2.2/lib/jodconverter-cli-2.2.2.jar on an .xls ...
In OOo Calc I need to copy a column (only the values, not the format) from one sheet to another (in the same worksheet) using a macro assigned to a button. I browsed a bit around but found nothing significant :-( ...
IOW how do I make OOo's undo/redo work properly when a macro is executed? This is related to my previous question: #853176 ...
How do I compare and merge 2 MS Word documents with Java and the OpenOffice API? I just want to conform that is it possible to compare 2 MS Word documents with the OpenOffice API. ...
For document exchange, I would like to generate OpenOffice.org text and spreadsheet documents. So far I have found export components which require OpenOffice to be installed, using OLE. Are there already Delphi components available which can write native files for OpenOffice.org Writer or OpenOffice.org Calc? ...
I want to set the text direction for some cells in a TextTable so that they are vertical (i.e., the text is landscape instead of portrait). You can do this in Writer by selecting the cell(s), and going to: Table - Text Properties - Text Flow - Text Direction However, I cannot figure out how to do this through the API. I tried using Char...
I am trying to change a filename extension in a macro for OpenOffice. My files are named like "file.odt" and I need to transform this string to "file.pdf". I use a macro that I have found on the Web but I have never written any line of basic code in my life ... However, the code is buggy and only works for 3 chars extensions (like ".do...