Stack Overflow
Stack Overflow

Questions tagged [jopendocument]

jOpenDocument is a free pure Java library for developers looking to use, create and manipulate Open Document files without OpenOffice.org.

17 questions
3
votes
3 answers

Java+jopendocument: NullPointerException when using getCellAt(0,0)

In a Libreoffice Spreadsheet's sheet, I can get access to a Cell, but not to its value. I don't find my error, any feedback is welcome. Here is the code: import java.io.File; import java.io.IOException; import…
Diego
  • 31
  • 4
3
votes
2 answers

IndexOutOfBoundException when trying trying to get a .ods cell with jOpenDocument

I am facing a little challenge with my coding. File file = new File("template.ods"); Sheet sheet; try { // load file sheet = SpreadSheet.createFromFile(file).getSheet("Certificate"); System.out.println(file); …
user4942391
3
votes
0 answers

Add Image with jOpenDocument in odt document (writer)

I'm trying jOpenDocument API and I want to add/insert an Image. Can I do that with this API? I'm interested in jOpenDocument because it enables me to create a template and then process the document afterwards with Java (which I don't think it's…
azelix
  • 1,257
  • 4
  • 26
  • 50
2
votes
0 answers

Create formula in jopendocument

How can I create a formula in jopendocument which is evaluated, if the file is opened in a spread sheet application like oocalc? I want to fill in value and set up formulas that will help the user of the spreadsheet and enables him to dig into the…
KFleischer
  • 942
  • 2
  • 11
  • 33
1
vote
2 answers

How to add rows to TableModel with JopenDocument

I am working on a java application that reads a file template.ods, and fills it in with an array of Objects using JopenDocument. Based on the JopenDocument documentation, I should get the TableModel from the Sheet, and then use the method…
Zakaria Marrah
  • 755
  • 6
  • 15
  • 28
1
vote
1 answer

Set border and optimal width to a column in a ods file

I trying to find a way to set borders to each cell and the optimal width to each column before creating the ods file [or either after the file has been created - i don't mind]. I'm writing the program in Java and I'm using the jopendocument library…
Maxuel
  • 127
  • 10
1
vote
3 answers

how to read .ods document by java and jopendocument package

I have .ods file and I want to read and display it by java program I used this program : import java.io.File; import java.io.IOException; import org.jopendocument.dom.spreadsheet.MutableCell; import org.jopendocument.dom.spreadsheet.Sheet; import…
Eman
  • 111
  • 1
  • 4
  • 14
1
vote
0 answers

Copy rows with JOpenDocument

I am trying to copy a row several times using JOpenDocument v1.3 and I am failing miserably. Here is my code snippet: private void copyRow(Sheet sheet, int templateRow, int target){ sheet.ensureRowCount(target); …
nessa.gp
  • 1,804
  • 21
  • 20
0
votes
0 answers

jopendocument error in Eclipse - Unable to derive module descriptor

When executing a simple programm that aims to write a string into an ods-File, i get an error in eclipse. Here's the error: java.lang.module.FindException: Unable to derive module descriptor for…
Holger
  • 1
  • 1
0
votes
1 answer

how to get cell type using jopendocument while reading ods cell?

I need to parse .ods document to string values. So, if any of the cell has date, currency or any other format other than number and text I need to get that data according to the cell type and convert it using String. I'm doing like that so because…
Mohan Kumar
  • 1
  • 2
0
votes
0 answers

I have conflict which parsing ods file merged cell using jopendocument in java?

When i try to parse ods sheet using jopentextformat from java code, there is a exception thrown which is given below. Note that the row and column of the first merged cell fetches the data where the second cell of the merged cell throws the…
Mohan Kumar
  • 1
  • 2
0
votes
1 answer

Modular project rising InvalidModuleDescriptorException with jOpenDocument

I am developing a modular java project with java/javafx 12 in Eclipse 2019-06, using a mixed modular and non-modular approach. Cannot get the program to run because of exceptions at runtime. I need to use a mixed modular and non-modular approach…
CT95
  • 107
  • 1
  • 11
0
votes
1 answer

export file head line has extra row

I want to export odsfile like this but I really got export is this(head line has extra word) here is my code,Thanks for any suggestion @RequestMapping(value = "/export", method = RequestMethod.POST) public @ResponseBody void exportOds(Long…
user7189675
0
votes
0 answers

soffice converted .ods file ,Failed to read .ods file using jOpenDocument API

I have converted .xls file to .ods by using below command in terminal COMMAND : soffice --headless --convert-to ods abcd.xls After conversion I am not able to read fileName.ods using SpreadSheet API of jOpenDocument1.3.jar. When ever I try to read…
Rajesh Hatwar
  • 1,843
  • 6
  • 39
  • 58
0
votes
1 answer

New line in field with jOpenDocument in ODT document

I'm trying to fill out a template from java with jOpenDocument library. I want to start a new line in a field. The normal new line sign (\n) does not work. When I do this manually in a document and look in the xml file (content.xml), I see why this…
user7732300
1
2