Hello, I am searching on ways to make a small app using GWT for converting documents from one format to other. Mainly these formats .doc , .pdf , .odt , .rtf.. and maybe a couple more. Has anyone tried this before?? I came across the library JODConverter but it needs open office to be already installed and i don't really know how ...
I'm looking for a way to customize a column chart. Open office and Excel produce the following chart for a column with values 1, 2, 3, 3, 2. But, I'd like to generate a chart with the following properties. The chart should have five bars. All bars must be of the same height. The chart should color bars based on their values. In this ex...
I have an Open Office Calc Sheet with a column full of data that has hyperlinks. I wish to trasnfer the hyperlinks to another column. How do I extract them? Thanks.,. ...
Hi I'm looking for a way to script an OpenOffice document so it would: have only parts editable do some magic with saving it (i'd like to save it into some generated from the entered content name) be reasonably easy to implement I've looked into this question: http://stackoverflow.com/questions/261318/what-is-the-single-best-online-s...
I am trying to edit the xml code in an Open office document so that it will print a date depending on today's date. Basically I want it be something like this: If today's date is between the first and the 15th, then the due date is the first of the following month. else if today's date is between the 16th and the 31st, the due date is...
I have N Word documents (Office 2003) from which I want to make a single Word document by merging all the N documents together in some order. How do I go about doing this in Ruby? Thanks! It's just the documents that are created in MS Office. I do not use Windows and would prefer non-Windows solutions. EDIT: Will this be easy if the d...
Hi, 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 aware of any web-based equivalent? Edit: Should have done more research, I need it to interact with MySQL, not an Access DB. ...
Has anyone come across a Git or Hg plugin for "meaningful" diffs/merging/branching of OpenOffice or Microsoft word files. I know I can 'checkin' .doc files but both Git and Hg treat them as binary blobs. I'd like to be able to do all (or at least many) of the normal revision based operations on the text of the file. And yes, I do know...
I use a Windows Web Server 2008 with ruby, PDFCreator, Microsoft Office, and OpenOffice to convert files to PDF automatically. The setup works ok for Microsoft Office files but I have not been able to get it to work automatically with OpenOffice files (e.g. .sxw). PDFCreator is able to convert .sxw files without problem when I do it manu...
Is there some limitation that makes having a --stdin option especially difficult for unoconv (Convert between any document format supported by OpenOffice) to support? It looks likes the file type is used to determine the document type so if standard input is used instead of a file name then the --doctype option would be required. But asi...
I have a table in an Openoffice Database, containing two date columns. I'm trying to create a view that will aggregate all the rows in these columns and sum up the difference between these two columns in minutes. This is pretty trivial, and in Postgres it would look like: SELECT SUM(EndDate-BeginDate) AS total_minutes FROM mytable Wh...
Hello all. I am trying to generate some ranges for a problem I am working on. These rangers are going to be based on the sum of the ratio's of a bunch of numbers. So for example, the constant's are 5 6 and 7. The ranges I get will be 5/x + 6/y + 7/z = S I want x, y, and z to come out of a list of numbers I have - say .5, .6, .7, .8, ....
I found some documentation about interop with OpenOffice using technologies like COM, but before delving in more deeply I wondered if anyone's worked on this kind of thing? We have a need for the following, all wrapped up in a method call from a client PC (client talks to server using COM): Client sends a map of name/value pairs to a ...
Hello, I'm using Ruby for displaying the contents of powerpoint files in a webpage. I've found solutions using the win32ole but I'm in the linux environment and it doesn't work. I think the application could trigger a openoffice command for conversion. ...
I have script in python using pyuno that extracts data from many excel files. My problem is that for every file I open and close a window with url = unohelper.systemPathToFileUrl(os.path.abspath(file_name)) file = desktop.loadComponentFromURL(url, "_blank", 0, () ) and file.close(True) Is there any way to extract data from the f...
I have generated a html table from my web application and save the table into .xls format(in a single word i am generating a .xls sheet from my web application ). But when i open that file in open office it shows the following thing (see the url) http://yfrog.com/jy390pj What other setting i have to show it in table form. ...
Hi, I've got something like this (in Open Office Calc): Streetname. Number Streetname. Number a etc. Now I want to delete everything in front of the number. So I need to do a search and replace I guess. ^.*?([0-9]) this one matches Streetname. Number .. but what should I put in the replace field? If I do the search and replace, i...
Testing on both Debian and Mac OSX On Debian, openoffice.org-writer package is installed Using latest OpenOffice.org version: 3.2.1 Tried both unoconv and JODConverter I start by launching a headless OpenOffice instance: soffice -headless -nofirststartwizard -accept="socket,host=localhost,port=8100;urp;" I'm in the right directory ...
I would like to retrieve the plural words in different languages in Python. I know that openoffice has an API called uno (import uno) and it should give me this ability using openoffice's language dictionaries, but I could not find any reference to it. As a concrete example, I would something like this: >>> print getPluralOf('table') ...
I'm trying to port an application I've written in Qt from the windows platform to the Mac OS X platform. The application is relatively simple: It queries the user for a document (either MS Word, or OOo Writer document). It than launches that that document inside the respective application, and than replaces various text elements with o...