Free Support Forum - aspose.com

FormatException during file opening

Hi,

I tried to open a file with such code:
Workbook wb = new Workbook(fName);
but received an exception (System.FormatException) with message "Input string was not in a correct format."
This document is opening with Excel 2010 without any problem.
I use Aspose.Cells v7.3.5.0.

Thanks,
Alex Shloma

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We have tested your issue with the latest version: Aspose.Cells
for .NET v7.3.5.1
and did not find any issue.


If you still find an issue, then please provide us your code to
replicate it using the latest version. We will soon look into your issue
and help you asap.

Below is a sample test code. I have attached the output xlsx file generated by this code for your reference.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\pivotManyTableMod.xlsx”;


Workbook workbook = new Workbook(filePath);

workbook.Save(filePath + “out.xlsx”, SaveFormat.Xlsx);

Hi,

I found the cause of the exception. It's Regional Format (Control Panel -> Region and Language -> Formats -> Format).
Try to set it to Russian(Russia) and open my file with Aspose.Cells.

Thank you,
Alex Shloma

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We were unable to replicate your issue with your recommended control panel, regional settings. However, we will look into your issue further and help you asap.

Once, there is some fix or update for you, we will let you know.

This issue has been logged as CELLSNET-41371.

Hi,


Thanks for response.

I was able to reproduce this issue on PCs with English (USA) version of Windows 7 Ultimate x64 and Windows XP.

Thanks,
Alex Shloma

Hi,

Thanks for your input and using Aspose.Cells for .NET.

We have logged your feedback against this issue id: CELLSNET-41371. Hopefully, it will be helpful in diagnosing this issue.

Once, we will have some update for you, we will share it with you asap.

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We have fixed this issue.

Please download and try this fix: Aspose.Cells for .NET v7.4.0.1 and let us know your feedback.

All works as expected!


Many thanks,
Alex Shloma

Hi,

Thanks for your feedback.

We are pleased to know that your issue is fixed with this latest version. We have closed this thread now.

If you face any other issue, please feel free to let us know, we will be glad to help you further.

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


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