Stack Overflow
Stack Overflow

Questions tagged [opendocument]

opendocument is intended for questions related to one of the XML file formats defined in the Open Document Format for Office Applications specifications.

opendocument is an ISO standard which encompases three file formats:

  • .odt (word processor documents)
  • .ods (spreadsheet documents)
  • .odp (presentation documents)

These formats are defined by the following specifications:

  • ODF 1.0
  • ODF 1.0 (Second Edition)
  • ODF 1.1
  • ODF 1.2
  • ODF 1.3 (In Development)

Apache OpenOffice is the reference implementation.

References

88 questions
88
votes
12 answers

How to convert OpenDocument spreadsheets to a pandas DataFrame?

The Python library pandas can read Excel spreadsheets and convert them to a pandas.DataFrame with pandas.read_excel(file) command. Under the hood, it uses xlrd library which does not support ods files. Is there an equivalent of pandas.read_excel for…
Lamps1829
  • 2,231
  • 3
  • 24
  • 32
26
votes
8 answers

how to create an odt file programmatically with java?

How can I create an odt (LibreOffice/OpenOffice Writer) file with Java programmatically? A "hello world" example will be sufficient. I looked at the OpenOffice website but the documentation wasn't clear.
baris
  • 261
  • 1
  • 3
  • 3
17
votes
5 answers

How does Open Office compress its files?

I'm trying to create an Open Office spreadsheet programmatically but for some reason simply compressing a folder with all the necessary files makes Open Office flag the file as corrupted. How did I get to this? I started by creating a normal…
ruipacheco
  • 15,025
  • 19
  • 82
  • 138
16
votes
3 answers

Background image dark or light?

I'm doing a ODP->HTML conversion with PHP. I have problems with the following: Use the style:use-window-font-color property to specify whether or not the window foreground color should be as used as the foreground color for a light…
Florian
  • 3,145
  • 1
  • 27
  • 38
15
votes
1 answer

What is correct mimetype with Apache OpenOffice files like (*.odt, *.ods, *.odp)?

I want *.ods and *.odt files on a website to open in openoffice when clicked, not get saved on desktop, or get opened embedded in a browser etc. Now obviously it all depends on how everything is configured for each user, but what's the best…
Bhavin Solanki
  • 4,740
  • 3
  • 26
  • 46
10
votes
2 answers

Library to edit odt documents in php

I try to edit ODT-documents programmaticly in PHP. In fact I just want to do some text replacement and adding new rows in a table. I know that a normal ODF document is an archive containing XML-files. But before I reinvent the wheel: is there any…
neo
  • 1,260
  • 11
  • 22
10
votes
8 answers

How do I get files in my own file format to have its own dynamic icon?

Our application has a file format similar to the OpenDocument file format (see http://en.wikipedia.org/wiki/OpenDocument) - i.e. zipped with a manifest file, a thumbnail image, etc. I notice that OpenOffice files have a preview image of the Open…
Epaga
  • 38,231
  • 58
  • 157
  • 245
8
votes
3 answers

org-mode zip needed, how to over come?

I have an org-mode document that I want to convert to open Document format. When I try to do this (ctrl+c+e+o) I get an error message: Executeable "zip" needed for creating OpenDocument files. Aborting. I have p7zip installed on my machine but I…
Yotam
  • 10,295
  • 30
  • 88
  • 128
8
votes
1 answer

Parsing OpenDocument Spreadsheets (*.ods)

I wonder if there is a tool/lib with friendly API for parsing such documents. I guess I'm looking for some analogy of Apache POI, which supports OpenOffice documents. Does anybody know such a tool?
Vyacheslav Sermyazhko
  • 359
  • 2
  • 4
  • 13
6
votes
4 answers

reading odt files in php

How would you go about reading odt files in PHP? I know you can use QueryPath, but that seems a bit of an overkill,.. I just want to read the file.
john mossel
  • 2,158
  • 5
  • 24
  • 39
5
votes
3 answers

Generate ODT documents with dynamic images in PHP

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…
Pekka
  • 442,112
  • 142
  • 972
  • 1,088
4
votes
0 answers

How can I convert ods to xlsx in java

I wrote code that creates one ods file from csv but this file is not opening in Office 2007. How can I convert it into xlsx format in Java?
Lalit Chattar
  • 1,914
  • 8
  • 27
  • 49
4
votes
0 answers

MS Excel and Power Point cannot properly open local hosted file through WebDAV

I am currently making a project with WebDAV to make some kind of Document Management System. It is an ASP .NET Web Application, hosted in IIS. (Although it's not using IIS WebDAV, but a modification of this…
Dan
  • 41
  • 2
4
votes
1 answer

Is there RefEdit control equivalent in Libre Calc?

Does anyone know what is Libre Calc’s equivalent for Excel’s RefEdit control? All other Excel UserForm controls seem to have corresponding controls for Libre Dialog forms. If there isn’t one, is it possible to tweak some other control (like Combo…
Davit Sargsyan
  • 1,264
  • 1
  • 18
  • 26
4
votes
1 answer

Concatenating OpenDocument Text file in Linux from the command line

Is there a way to concatenate two OpenDocument Text documents (i.e. the format OpenOffice uses) in Linux from the command line? I'm looking for a command that will allow me to do something like: concat-docs doc1.odt doc2.odt doc3.odt -o…
javawizard
  • 1,277
  • 1
  • 12
  • 17
1
2 3 4 5 6