Hello,
I'm having an issue opening xml files in Aspose when the file contains a sheet whose name contains the letter R by itself (e.g. "Sheet R", "Toys R Us"). Please see the attached files in SpreadsheetML format. I get an error when I try to open these files in Aspose v5.2.2.3, using csharp code like this:
var workbook = new Workbook(string.Format("{0}SheetWithR/SheetWithR - Formula.xml", TestHelper.InputDirectory), new LoadOptions(LoadFormat.SpreadsheetML));
When the workbook has a formula referencing the sheet name, I get this error:
System.ApplicationException: Invalid formula in cell A2: ='Sheet R'!R[-1]C
at .ঐ.ল(String ֹ, Int32 ত, Int32 থ)
at .ঐ.য(StringBuilder ধ, String ֹ, Int32 , Int32& প, Int32 ত, Int32 থ)
at .ঐ.ব(String ֹ, Int32 ত, Int32 থ)
at 䗾.䗽.↭(Worksheet ਓ, XmlTextReader ด)
at 䗾.䗽.䑾(XmlTextReader ด)
at 䗾.䗽.↝(XmlTextReader ด)
at 䗾.䗽.䘇(Stream ☤, Workbook 㼣)
at Aspose.Cells.Workbook.ԝ(Stream Ԡ, LoadOptions ԟ)
at Aspose.Cells.Workbook.ԝ(String Ԟ, LoadOptions ԟ)
at Aspose.Cells.Workbook..ctor(String file, LoadOptions loadOptions)
at AsposeTests.AsposeFormulaTests.SheetContainingRCanBeLoaded() in AsposeFormulaTests.cs: line 122
when the workbook has a named range referencing the sheet, I get this error:
System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
at Aspose.Cells.CellsHelper.ColumnIndexToName(Int32 column)
at .ঐ.(Int32 ش, Int32 ص)
at .ঐ.ল(String ֹ, Int32 ত, Int32 থ)
at .ঐ.য(StringBuilder ধ, String ֹ, Int32 , Int32& প, Int32 ত, Int32 থ)
at .ঐ.ব(String ֹ, Int32 ত, Int32 থ)
at 䗾.䗽.⯋(XmlTextReader ด, Workbook 㼣)
at 䗾.䗽.↝(XmlTextReader ด)
at 䗾.䗽.䘇(Stream ☤, Workbook 㼣)
at Aspose.Cells.Workbook.ԝ(Stream Ԡ, LoadOptions ԟ)
at Aspose.Cells.Workbook.ԝ(String Ԟ, LoadOptions ԟ)
at Aspose.Cells.Workbook..ctor(String file, LoadOptions loadOptions)
at AsposeTests.AsposeFormulaTests.SheetContainingRCanBeLoaded() in AsposeFormulaTests.cs: line 122
Is there anything that can be done about this?
Thanks,
Mishelle