the attached file causes an ‘Index out of range’ exception. i believe this is due to unresolvable range-names. Aspose.Excel will open the file successfully if the Names are removed.
not sure if this needs to be handled by Aspose.Excel - for your reference.
Yes. This error is caused by defined Names. Currently Aspose.Excel doesn’t support defined name which refers to external file. Please remove those names in your file.
I will investigate and fix this problem. But it will take a relative long time for this is a complex feature.
I got hit with another open error. The file to open looks innocuous enough. The error message is: "Source array was not long enough. Check srcIndex and length, and the array’s lower bounds."
I am using the latest version of Aspose.Excel 3.4.4.0; probably another conflict with the Validation, Name Range, etc. pls help check. thanks,