I need to be able to mail merge from an ASP.NET web form in C# .net to Open Office. I can connect with OpenOffice and open a file but that is where things stop at the moment. I have a table of mail merge items that need inserting into a document for each client on my system but I can't find anything on the internet that helps me perfor...
I am converting a bunch of html pages into an OpenOffice document (.odt), which will then be converted to a PDF. Is there any way to get a bunch of text lines to stay on the same page (like the keep function of old formatters) (apart from turning it into a diagram)? ...
I need a Java interface to the OpenOffice document conversion which would equal to a manual (Open... and then Save As...) as well as access to the PDF generation. The following are some example of what I want to achieve. 1) Open one type of document (fx. OpenOffice Writer document or Microsoft Office document) onto memory and save it i...
I'm trying to make a selectionlist in NeoOffice (mac osx clone of OpenOffice) from a column with strings. I can make selection lists when in the same column, but I want a reference between a list of cells to another column selection list. How can I do that? Maybe some references? ...
I am new to OpenOffice and have been reading lots of articles about it. I need to code mail merge functionality in C# to instruct OpenOffice to perform a mail merge on a supplied document. I have seen lots of mail merge examples using VB.NET but when I convert the VB to C# the mailmerge component of it always fails to create correctly. M...
Discussion on OOoForum.org In python, using pyuno, I can do it like this: table = self.model.createInstance("com.sun.star.text.TextTable") This doesn't seem to work in C#. Here is my test code (I realize I probably don't need all those using statements, but I am adapting someone else's code): using System; using unoidl.com.sun.star....
Hi all, I use OpenOffice through the java API, and make him open the .odt file, fill in some values and save as .doc and .pdf. The .doc have no checkboxes in it. I'm basically looking for a workaround of bug 45347 Correcting the bug by myself is not an option since a checkout of the openoffice code takes more than 10h (various Go o...
Discussion on OOoForum.org In python, I can do something like this: table.BreakType = PAGE_BEFORE table.HoriOrient = 0 table.RightMargin = 6.93 * 2540 - table_width In C#, I can't find a way to set properties. XTableTable only has a few methods available to it, and none of them seem to do anything like this. How do I set properties i...
Is there a way to add up all of the positive numbers in a row/column but ignoring all of the negative numbers? Like SUM(), except that it ignores negative numbers. Would I have to use VBA? If so, how would I do it in VBA? If it can't be done in Excel, can it be done in OpenOffice Calc? ...
I'm trying to get the sample and other sample codes i find for pyuno running with openoffice 3.1.1 and python 2.5 with no luck. Unfortunately, pyuno does not give any clues about what goes wrong. In [1]: import uno In [2]: local = uno.getComponentContext() In [3]: resolver = local.ServiceManager.createInstanceWithContext("com.sun.st...
I need to create an application that generates a bunch of templates for Office (2000), OpenOffice.org (2.0) and InDesign. The design of the templates will be made in each application but we need a system for placeholders so that my application opens a template, replaces the placeholder with some text (like a name, address, phone number) ...
Hi, I would like to update a odt with some external variables like version number. I know I can add variables, but the value of those variables are internal to the document. Perhaps with a formula? ...
Can you help me create the connection string to connect the ADO.net to Open Office Base, is there any Open Office additional ODBC driver? ...
My employer is considering installing OpenOffice.org's suite of Office products instead of using Microsoft Office. I've written several advanced applications in Access and Excel, and I'm trying to figure out what will and will not be compatable with OpenOffice.org. Specifically, what do I need to do to have Calc (OpenOffice.org's ver...
I need to develop a service able to convert MS Office and Open Office documents to PDF. And the PDF`s also need to be commentable when opened in ADOBE Reader. I have used a piece of software from www.neevia.com. And it does the conversion, but is not able to make the PDF´s commentable and is therefore useless in my scenario. Ideally I ...
I have a small application that generates three different template documents in OOo Writer. When one of the three "generate" buttons is clicked, this is part of the code that is executed (in C#): // Connect to OOo if (componentContext == null) componentContext = uno.util.Bootstrap.bootstrap(); XMultiServiceFactory multiServiceFacto...
I need to read and write data from an Excel spreadsheet. Is there a method to finding out how many rows/columns a certain worksheet has using ExcelPackage? I have the following code: FileInfo newFile = new FileInfo(@"C:\example.xlsx"); using (ExcelPackage xlPackage = new ExcelPackage(newFile)) { Exce...
Each block contains 3 addresses - name, city, state, zip - how do I break it apart in OpenOffice/Excel? James R. Javier DDS Kent R. Nelson DDS Theodore G. Lund DDS 421 SW 335th St 1911 SW Campus Rd 2748 SW 315th St Federal Way, WA 98023-6192 Federal Way, WA 98023-6473 Federal Way, WA 98023-7832 H. Jung Song DDS Timothy J. Weaver DDS Sa...
I have to maintain a huge set of training material in forms of slides. At a first glance, I've noticed there's no support for version control in OpenOffice OOImpress (but I might be wrong on this). Which tool should I use to easily maintain my training material? I thought about using LaTeX + Beamer so that I can easily put under versi...
I maintain a couple of web databases based on PHP and mySQL on a shared hosting package. The databases have a mechanism for the user to upload OpenOffice documents with placeholders: [person.name] [person.address] [person.postcode] I then use this great PHP tool to run through the OpenOffice document and insert values from the databas...