Questions tagged [odf]

The Open Document Format for Office Applications, also known as OpenDocument.

The Open Document Format for Office Applications (ODF), also known as OpenDocument (OD), is an XML-based file format for spreadsheets, charts, presentations and word processing documents. It was developed with the aim of providing a universal document format that could be used with any office software suite.

111 questions
1
vote
1 answer

Formatting cells with Apache ODF Toolkit Simple API and Java

I need to create a ods document using the Apache ODF Toolking and to format the content of its cells. I was able to set a format for dates and simple numbers, but for some reason when I try to format with scientific notation it does not work. It…
1
vote
1 answer

What dependencies to use for APACHE ODF TOOLKIT (INCUBATING)

I am trying to load a .ods file with the code: import org.odftoolkit.simple.SpreadsheetDocument; SpreadsheetDocument data = SpreadsheetDocument.loadDocument(f); I've added the import statement to show which package I am using. However I keep…
1
vote
1 answer

OpenOffice::OODoc - How to insert Horizontal Line/Rule in a Page

I am creating ODF Document using OpenOffice::OODoc module. I want to have a Horizontal Line/Rule after a Heading. I have seen documentation but it has no solution for this problem. I even tried to insert a paragraph with border, but it leaves a…
1
vote
0 answers

Extracting Hebrew text from an OpenDocument Text Bible

I'm trying to extract Hebrew text from a Bible in OpenDocument Text (odt) format with the following code: from odf import text, teletype from odf.opendocument import load textdoc = load("Heb-OT.odt") texts =…
1
vote
0 answers

How to copy one ODS sheet into other file?

Thought that copying one sheet from one ODF file into other is piece of cake. Unfortunately even simplest code below ends with empty new file: #!/usr/bin/env perl use strict; use warnings; use 5.014; use utf8::all; use ODF::lpOD; my $doc =…
w.k
  • 8,218
  • 4
  • 32
  • 55
1
vote
2 answers

How to generate ODF charts with Perl

How to create Open Document Format spreadsheet with charts using Perl?
1
vote
0 answers

is there an open equivalent to OLE

Is there any kind of open equivalent to OLE, for use with ODF? Or equivalent functionality in some other format (e.g., OLE for DocBook XML) - complete with open-source protocol infrastructure?
1
vote
2 answers

MS Word/ ODF Automation in Qt

How can I perform automation of MS Word documents (.doc) or ODF documents (.odt) in Qt 4.5? I know using the QAxWidget, QAxObject. I have data (QString) and few images as well. I have to add them into the document. I googled but I couldn't find any…
liaK
  • 11,422
  • 11
  • 48
  • 73
1
vote
0 answers

Convert ODS to XLSX results in too many columns

I've converted an ODF file to XLSX using LibreOffice. When I open the output file in Excel 2013 there are too many columns on each sheet. How do I fix this? The scrollbars are now kind of useless. Note that I can't just copy and paste to a new sheet…
posfan12
  • 2,541
  • 8
  • 35
  • 57
1
vote
1 answer

Get font type in python odfpy?

Have somebody experencies with odfpy ? I parsed document with this python package and I got paragraphs with his text and stylenames, now I need to detect which type of text font is in this paragraphs text? Do you have any ideas ?
bagere
  • 221
  • 5
  • 17
1
vote
2 answers

Webodf display odf from bytes

Is it possible for webodf to read a odf / odt file from its bytes? instead of an url? Currently using: var odfelement = document.getElementById("odf"); var odfcanvas = new odf.OdfCanvas(odfelement); odfcanvas.load("url/to/file.odt"); and would…
cipriota
  • 11
  • 3
1
vote
1 answer

Has anybody successfully used the ODF "Simple API" from LotusScript to generate documents?

I'm trying to use LS2J to invoke the Simple API for the ODF Toolkit (https://incubator.apache.org/odftoolkit/simple/index.html) from LotusScript, and I've been unable to use it properly. I've included in a Java library called ODFDOM the…
richieadler
  • 135
  • 9
1
vote
2 answers

exporting mysql data to ODF with php

I would like to know if someone triend exporting data from MySQL to an ODF format ? Any information / documentation would be very much appreciated. I am going to try to export a MySQL result set to ODF spreadsheet if possible.
user18383
  • 551
  • 3
  • 8
  • 12
1
vote
1 answer

jOpenDocument Sheet.getValueAt(int, int) return value is both a String and a BigDecimal?

I'm processing a .ods spreadsheet with the jOpenDocument library. Since I was processing strings, everything was ok, but when it comes to process numbers it's a pain. In my code I iterate the spreadsheet and make some computations based on the value…
Dev-otchka
  • 327
  • 1
  • 4
  • 20
1
vote
2 answers

Get Metadata from Open Office Files

I need to modify only the Open Office file metadata. How I can do it without loading the entire file into memory (file.odt)? I need to work only with the file: meta.xml and label: ... metadata ... I'm using Apache ODF Toolkit 0.5-incubating. My…
user2671914
  • 45
  • 2
  • 9