We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

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

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

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.

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

Hi,

Please try the attached version.

Thank you.

Works great! Thanks.

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.