Free Support Forum - aspose.com

Issue with "R" in the sheet name

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

Hi,

Thanks for reporting this bug.

I was able to reproduce it using the latest
Aspose.Cells for .NET v5.3.3
.

This issue has been logged as CELLSNET-27342.

Hi,

We have fixed this issue. Please download Aspose.Cells
for .NET v5.3.3.1
.

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


This message was posted using Notification2Forum from Downloads module by aspose.notifier.