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 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 >>> 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.(Unknown Source) >>> at org.jopendocument.dom.ODPackage.(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.
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 > > >> 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.(Unknown Source) >> at org.jopendocument.dom.ODPackage.(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.
Re: [jopendocument] Exception java.lang.IllegalArgumentException while opening ods file modified by Microsoft Excel
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 > 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@10c83693OD > version null to org.jopendocument.dom.XMLFormatVersion@10df2f5fOD 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.(Unknown Source) > at org.jopendocument.dom.ODPackage.(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. > -- --- 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.