FormatException While Opening ODS File

Aspose.Cells Product Family
1

I am getting an exception (FormatException - Input string was not in a correct format) while trying to open a particular ODS file. I’m attaching the file for sample. I’m using two “Open” methods as it follows. Both give me the same error.


Workbook xls = new Workbook();

xls.Open(pFileName, FileFormatType.ODS);

xls.Open(pFileName);

The exception stack trace is:

em System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
em System.Double.Parse(String s)
em x8289a80d583c7e4e.x8dc233e91ffa0f6e.x93a64f9035197a96(Double xfa7300893f01343a, String x9b0739496f8b5475)
em x8289a80d583c7e4e.x6419fc8ec8d3ec2c.x751b5c6dc423c06b(Border x14cf9593b86ecbaa, String x44ecfea61c937b8e)
em x8289a80d583c7e4e.x6419fc8ec8d3ec2c.x719e6729cf05ab38(Style x44ecfea61c937b8e)
em x8289a80d583c7e4e.x6419fc8ec8d3ec2c.x3d6fbfa39a576b67()
em x8289a80d583c7e4e.x6419fc8ec8d3ec2c.x637d7e009920d5a9()
em x8289a80d583c7e4e.x6419fc8ec8d3ec2c.x06b0e25aa6ad68a9(XmlTextReader xb9763b0038341e6c)
em x8289a80d583c7e4e.x6c24f1bbbb1163d2.x06b0e25aa6ad68a9(xef4b7685c2495ff2 x44563e523ace19b5)
em x8289a80d583c7e4e.x8b6071c5dcbbf539.xb8f0639dbdde78bb()
em x8289a80d583c7e4e.x8b6071c5dcbbf539.x06b0e25aa6ad68a9(xef4b7685c2495ff2 x44563e523ace19b5)
em x8289a80d583c7e4e.x8b6071c5dcbbf539.x06b0e25aa6ad68a9(Stream xcf18e5243f8d5fd3)
em x8289a80d583c7e4e.x8b6071c5dcbbf539.x06b0e25aa6ad68a9(String xafe2f3653ee64ebc)
em Aspose.Cells.Workbook.Open(String fileName, FileFormatType type)
em xx.cc.vv.bb.nn(String pTmpFileName, String pFileName, eTipoCopiaImpressao pTipoCopia, Hashtable htTagsRegs, String pExt, Decimal pBloqueiaImpressao)

Any ideas?
2

Hi,


Thanks for providing us your sample file. We are getting a different exception [Snapshot is attached] while opening your ODS file using latest fix version of Aspose.Cells for .Net v5.3.2.7. We have logged this issue under ticket ID CELLSNET-27076. Soon we will get back to you on this.

C# Code
LoadOptions loadOptions = new LoadOptions(LoadFormat.ODS);

Workbook workbook = new Workbook(@“D:\temp\MODELOAcordoIntersetorial.ods”,loadOptions);

3

Please find attached the screen shot, Babar has missed it I think.

Thanks.

4

Hi,

Please try Aspose.Cells for .NET v5.3.2.8, we have fixed it
Thank you.

5

Wow, that was fast, thank you very much!

6

The issues you have found earlier (filed as 27076) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.