Problem opening SpreadsheetML when there exists a Named Range with the letter 'R'

Aspose.Cells Product Family
1

Hi,



I have a spreadsheet here (attached) that only contains a single named range. This name (MyName) refers to a string literal ‘Office Products R Us’.



When I try to open this spreadsheetML with Aspose, it throws:



System.ApplicationException: Invalid formula in cell @0: =“Office Products R Us”



However, when the ‘R’ is changed to anyother letter (e.g. Office Products C Us) then Aspose would not throw the above error.



Here is the code I used to open this spreadsheetML:



var workbook = new Workbook();

workbook.Open(“C:\NamedRangeWithR.xml”, FileFormatType.SpreadsheetML);



-Steve

2

Hi Steve,

I get the error opening your template spreadsheetML (.xml) file into MS Excel (2003, 2007 etc.) , check the attached screenshot.

Kindly make sure that the file can be opened properly by MS Excel (without generating any error types etc.), so Aspose.Cells should open it fine. If a file is opened fine into MS Excel but not with Aspose.Cells for .NET, we will figure out the issue then.

Thank you.

3

Sorry … here’s one attached that opens fine on my Excel 2003.

4

Hi,

Please try the attached version.

Thank you.

5

Works great! Thanks.

6

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

This message was posted using Notification2Forum from Downloads module by Laurence.