I am trying to export data from my application to Excel sheet. I have used the Worksheet.AutoFitRows() method to Auto fit the rows in excel sheet. But as soon as this method is executed, it gives error for some Japanese records. The error received is "Index and Length must refer to a location within the string. Parameter name :length."
The above mentioned error is usually thrown by .Net when you are trying to access an Index not in a collection or if you are trying to get a substring out of a string where length of the substring is more than the string. In my case, there is nothing like that. Neither I am trying to get a substring nor an Index. The error is received on execution of Worksheet.AutoFitRows() method, and that too for Japanese characters only(working fine for other languages).
I am not sure if this is a bug with Aspose.cells(version 220.127.116.11). If yes, please let me know if this is fixed with the latest version or else please suggest a Solution/Workaround.