jferard / fastods

A very fast and lightweight (no dependency) library for creating ODS (Open Document Spreadsheet, mainly for Calc) files in Java. It's a Martin Schulz's SimpleODS fork
GNU General Public License v3.0
36 stars 6 forks source link

Excel complains when loading .ods document created by FastODS #167

Closed GregorySokoloff closed 3 years ago

GregorySokoloff commented 4 years ago

Loading an .ods document into Excel (V 1909 Build 12026.20264), a dialog pops up that says, "We found a problem with some content in 'minimaldoc.ods'. Do you want us to try to recover as much as we can?" Click yes and all seems fine. Likely to be a problem with all documents created by FastODS.

Here is some code to create the minimal document:

OdsFactory odsFactory = OdsFactory.create(Logger.getLogger("hello-world"), Locale.US);
AnonymousOdsFileWriter writer = odsFactory.createWriter();
OdsDocument document = writer.document();
Table table = document.addTable("Worksheet1");
File file = new File(filesDir, "junk.ods");
writer.saveAs(file);
ablundgren commented 4 years ago

I am seeing this issue as well.

jferard commented 4 years ago

Hi @ablundgren. This issue was first raised here. My reply was:

Feel free to post Excel related issues. I won't investigate these issues because I do not have Excel, but I'll use the tag "help wanted" and we'll see if someone finds why Excel whines about FastODS files.

Unfortunately, if you don't have any clue, you'll have to wait and hope someone can fix it! BTW, I'm curious about what bothers Excel and hope someone will provide some hints (a log, a modification of the XML that makes the file readable, ...).

ueen commented 3 years ago

Should be resolved with this https://github.com/jferard/fastods/issues/216

jferard commented 3 years ago

I'm closing this issue, see post above.