Issue while opening Excel Files using cells V4.8

Aspose.Cells Product Family
1

Hi,

I am facing the following issues while opening excel files using cells dll V4.8.

1. Index was outside the bounds of the array.
2. This files format is not supported or you dont
specify a correct format.
3. Cannot find central directory
4. Invalid cell name

Herewith i have attached the sample files.

Regards,
Karthik
2

Hi Karthik,

Thank you for considering Aspose.

karthik.net2008:

  1. Index was outside the bounds of the array.

We checked your template file and it works fine with the attached latest version of Aspose.Cells. Please try it and let us know if you still face any issue.

karthik.net2008:

  1. This files format is not supported or you dont specify a correct format.

Please use FileFormatType.TabDelimited as the your template file is a tab delimited file.

karthik.net2008:

  1. Cannot find central directory

We have found your mentioned issue after an initial test. We will look into it and get back to you soon.

karthik.net2008:

  1. Invalid cell name

We checked your template file and it works fine with the attached latest version of Aspose.Cells. Please try it and let us know if you still face any issue.

Thank You & Best Regards,

3

Hi Karthik,

Thank you for considering Aspose.

Please try the attached version. We have fixed most of the issues you mentioned. But there are still two issues:

  1. Currently our API does not support formula that contains cell column index larger than 255 such as “=SUM(IW93:IW97)”. So some formula of file “Invalid+cell+name.xlsx” will be come error after saving out. Such as the formula of cell “IW98”(worksheet “Accessories”).

  2. Currently our API does not support chart using external reference data. So file “Cannot+find+central+directory.xlsx”’s chart series’ external reference data will get lost after saving out.

Thank You & Best Regards,

4

Hi,

Please try the attached version. We have fixed the external reference issues you mentioned.

Please let us know if you still find the problem.

Thank you