I am using a system that reading documents (ods) write in another
language (Python) that are generated with jOpenDocument,
but this system can not read the file due to the following:

In ods file (according to OASYS) the cell must have one type format
string.

Ex:

<table:table-cell table:style-name="ce68"
office:value-type="string">
<text:p>Report</text:p></table:table-cell>

My code in jopendocument:

 ...
 final Sheet sheet= SpreadSheet.createFromFile(fileOds).getSheet(0);
 sheet.getCellAt("A1").setValue("Report");
 ...

(to put the value Report in A1 cell)

This write in file ods:

<table:table-cell table:style-name="ce68">
<text:p>Report</text:p></table:table-cell>

Jopendocument not put the text "office:value-type="string" an my
system can not read.

There is a way to set a type to any cell (String, Boolean, Date, Time)?

Reply via email to