I have two CSV files with a common column and I want to "Join" the tables together on the common column. For example: Join 'A' with 'B' equals 'Result'. If a one table has a key value that does n...

I am preparing a presentation using Google Slides, though I can also work on the presentation within Open Office that will include code snippets. Is there any easy way to perform basic synt...

I have created an application using JodConverter and Open-Office for converting an excel(.xlsx) to PDF, The application works fine but i am facing two problems The pages of output PDF is in the f...

How do you merge two .odt files? Doing that by hand, opening each file and copying the content would work, but is unfeasable. I have tried odttoolkit Simple API (simple-odf-0.8.1-incubating) to ac...

There are formats that are actually zip files in disguise, e.g. docx or odt. If I store them directly in version control, they are handled as binary files. My ideal solution would be have a hook ...

I have a ASP.NET 2.0 web application that should upload a ppt file and then extract its slides to images. For that I have imported office.dll and Microsoft.Office.Interop.PowerPoint.dll assemblies ...

I have some documentation written in OpenOffice, and I would like to include some of it as PDF files in the final build deliveries. I would like to do this with the automated build script. Is ther...

Would anyone please suggest me how can we edit word document in iphone/iPad application. I wont to open word document in my app and change font style and color and save it again. Is there any...

I want to use a Open Office / Libre Office Presentation as a template and insert text and images into slides. I am trying to use odftoolkit. If I have a slide with the boxes, they are represented a...

Is there any explanation docs or tutorials of the file structure of FreeDict, Aspell, Hunspell/OpenOffice Dictionaries especially concerning the switches at the end of each row in each .dic file? M...

I needed to export data of a table to Excel. I got a solution as below: http://jsfiddle.net/jquerybyexample/xhYcD/ In the above example, it allows you to generate .xls file when Microsoft Excel is ...

I am using Open Office's spreadsheet program and am trying to concatenate several text cells together with delimeters. For example, suppose I have the cells below: +--------+ | cell 1 | +--------+...

I want to know if there is a way to do this conditional in excel or open office: if the cell is empty then the cell will have the same value as the cell above it else do nothing. Should...

Does LibreOffice/OpenOffice Support the COM Model (Component Object Model)?

I am using OPEN OFFICE ORG CALC. I can't use MSOFFICE How can i highlight Duplicate value in a Column ? I am in real need. Did my part of homework LINK 1, Link 2

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

I'm trying to dynamically generate a csv file with some cells that will contain multiple lines, the address field for example will need to be grouped into a single "address" cell instead of address...

I want to know if it is possible to read OpenOffice Calc spreadsheet programatically with c#, I can do this for Excel(.xls and .xlsx) but unable to find a solution for reading calc spreadsheet. He...

I am working on a project (in Python) that needs formatted, editable output. Since the end-user isn't going to be technically proficient, the output needs to be in a word processor editable format....

I have a WSGI application that generates invoices and stores them as PDF. So far I have solved similar problems with FPDF (or equivalents), generating the PDF from scratch like a GUI. Sadly this m...

My customer is replacing MS Office with OpenOffice in some workstations. My program export a file to Excel using the .xml extension (using open format) and opens it using the current associated pro...

Is there a .NET API for OpenOffice? EDIT: Is there a OpenOffice SDK for .NET?

I have the following code that creates an odf-document with a heading and a picture: #!/usr/bin/perl use strict; use warnings; use OpenOffice::OODoc; my $doc = odfDocument( file => 'test.od...

Does anyone know of an Android API or Library for viewing MS-Office's files (.doc, .ppt, etc.)? I know this question brought up several time, but it was a long time ago, and I just wanted to ...

I'm using one of the popular spreadsheet applications (Excel/OpenOffice/LibreOffice Graph) to create some nice charts. Is it possible to export the charts to SVG format from any of those pro...