[jopendocument] Exception java.lang.IllegalArgumentException while opening ods file modified by Microsoft Excel
Hi, I have created ods file using Apache OpenOffice Calc 4. After that this file has been modified and saved in Microsoft Excel. The file format is still ods but jopendocument is throwing below exception- Exception in thread main java.lang.IllegalArgumentException: Cannot change format version from org.jopendocument.dom.XMLFormatVersion@10c83693 OD version null to org.jopendocument.dom.XMLFormatVersion@10df2f5f OD version 1.1 at org.jopendocument.dom.ODPackage.checkVersion(Unknown Source) at org.jopendocument.dom.ODPackage.setTypeAndVersion(Unknown Source) at org.jopendocument.dom.ODPackage.updateTypeAndVersion(Unknown Source) at org.jopendocument.dom.ODPackage.putFile(Unknown Source) at org.jopendocument.dom.ODPackage$1.processEntry(Unknown Source) at org.jopendocument.util.ZippedFilesProcessor.process(Unknown Source) at org.jopendocument.dom.ODPackage.init(Unknown Source) at org.jopendocument.dom.ODPackage.init(Unknown Source) at org.jopendocument.dom.spreadsheet.SpreadSheet.createFromFile(Unknown Source) I am using jOpenDocument-1.3 My aim is to read an ods file, which can be edited/modified in both Excel and Open Office. -- --- You received this message because you are subscribed to the Google Groups jOpenDocument group. To unsubscribe from this group and stop receiving emails from it, send an email to jopendocument+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
Re: [jopendocument] Exception java.lang.IllegalArgumentException while opening ods file modified by Microsoft Excel
Hi Guillaume, Thanks for the suggestions. Can you provide me the updated jar with required changes or point me to that please? On Tuesday, August 20, 2013 10:25:21 PM UTC+5:30, guillaume...@gmail.com wrote: Hi, Microsoft and standards a long story. In short, some versions of Excel just output invalid files (file format is not specified). I think we should add a flag to support invalid files, but for now, the quickfix is to modify org.jopendocument.dom.ODPackage.checkVersion. Regards, 2013/8/20 Ravi Joshi ravi20...@gmail.com javascript: Hi, I have created ods file using Apache OpenOffice Calc 4. After that this file has been modified and saved in Microsoft Excel. The file format is still ods but jopendocument is throwing below exception- Exception in thread main java.lang.IllegalArgumentException: Cannot change format version from org.jopendocument.dom.XMLFormatVersion@10c83693 OD version null to org.jopendocument.dom.XMLFormatVersion@10df2f5f OD version 1.1 at org.jopendocument.dom.ODPackage.checkVersion(Unknown Source) at org.jopendocument.dom.ODPackage.setTypeAndVersion(Unknown Source) at org.jopendocument.dom.ODPackage.updateTypeAndVersion(Unknown Source) at org.jopendocument.dom.ODPackage.putFile(Unknown Source) at org.jopendocument.dom.ODPackage$1.processEntry(Unknown Source) at org.jopendocument.util.ZippedFilesProcessor.process(Unknown Source) at org.jopendocument.dom.ODPackage.init(Unknown Source) at org.jopendocument.dom.ODPackage.init(Unknown Source) at org.jopendocument.dom.spreadsheet.SpreadSheet.createFromFile(Unknown Source) I am using jOpenDocument-1.3 My aim is to read an ods file, which can be edited/modified in both Excel and Open Office. -- --- You received this message because you are subscribed to the Google Groups jOpenDocument group. To unsubscribe from this group and stop receiving emails from it, send an email to jopendocumen...@googlegroups.com javascript:. For more options, visit https://groups.google.com/groups/opt_out. -- --- You received this message because you are subscribed to the Google Groups jOpenDocument group. To unsubscribe from this group and stop receiving emails from it, send an email to jopendocument+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
Re: [jopendocument] Exception java.lang.IllegalArgumentException while opening ods file modified by Microsoft Excel
Hi, We provide commercial support for this kind of request. Regards, Guillaume Le 20 août 2013 à 19:06, Ravi Joshi ravi2008jo...@gmail.com a écrit : Hi Guillaume, Thanks for the suggestions. Can you provide me the updated jar with required changes or point me to that please? On Tuesday, August 20, 2013 10:25:21 PM UTC+5:30, guillaume...@gmail.com wrote: Hi, Microsoft and standards a long story. In short, some versions of Excel just output invalid files (file format is not specified). I think we should add a flag to support invalid files, but for now, the quickfix is to modify org.jopendocument.dom.ODPackage.checkVersion. Regards, 2013/8/20 Ravi Joshi ravi20...@gmail.com Hi, I have created ods file using Apache OpenOffice Calc 4. After that this file has been modified and saved in Microsoft Excel. The file format is still ods but jopendocument is throwing below exception- Exception in thread main java.lang.IllegalArgumentException: Cannot change format version from org.jopendocument.dom.XMLFormatVersion@10c83693 OD version null to org.jopendocument.dom.XMLFormatVersion@10df2f5f OD version 1.1 at org.jopendocument.dom.ODPackage.checkVersion(Unknown Source) at org.jopendocument.dom.ODPackage.setTypeAndVersion(Unknown Source) at org.jopendocument.dom.ODPackage.updateTypeAndVersion(Unknown Source) at org.jopendocument.dom.ODPackage.putFile(Unknown Source) at org.jopendocument.dom.ODPackage$1.processEntry(Unknown Source) at org.jopendocument.util.ZippedFilesProcessor.process(Unknown Source) at org.jopendocument.dom.ODPackage.init(Unknown Source) at org.jopendocument.dom.ODPackage.init(Unknown Source) at org.jopendocument.dom.spreadsheet.SpreadSheet.createFromFile(Unknown Source) I am using jOpenDocument-1.3 My aim is to read an ods file, which can be edited/modified in both Excel and Open Office. -- --- You received this message because you are subscribed to the Google Groups jOpenDocument group. To unsubscribe from this group and stop receiving emails from it, send an email to jopendocumen...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out. -- --- You received this message because you are subscribed to the Google Groups jOpenDocument group. To unsubscribe from this group and stop receiving emails from it, send an email to jopendocument+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out. -- --- You received this message because you are subscribed to the Google Groups jOpenDocument group. To unsubscribe from this group and stop receiving emails from it, send an email to jopendocument+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.