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

Free Support Forum - aspose.com

SpreadsheetML and named ranges with trailing numbers

Hi,

I am currently using Aspose Cells 4.4.3.18

I have noticed that if I have a Range with a name containing trailing numbers such as “arange34” and save in the FileFormatType.SpreadsheetML format, then I get the error “Invalid column expression: arange34

If I use another format such as FileFormatType.Excel2003 then it works fine. I need to name ranges in this way to adhere to a specification. Below is an example:

String namedRange = “arange34”;
Workbook workbook = new Workbook();
Worksheet pickListSheet = workbook.Worksheets[workbook.Worksheets.Add()];
pickListSheet.Cells[0, 0].PutValue(“value 1”);
pickListSheet.Cells[1, 0].PutValue(“value 2”);
pickListSheet.Cells[2, 0].PutValue(“value 3”);
Range range = pickListSheet.Cells.CreateRange(0, 0, 3, 1);
range.Name = namedRange;

Worksheet worksheet = workbook.Worksheets[0];
Validation validation = worksheet.Validations[worksheet.Validations.Add()];
validation.Type = ValidationType.List;
validation.Operator = OperatorType.None;
validation.InCellDropDown = true;
validation.Formula1 = “=” + namedRange;
validation.ShowError = true;
validation.AlertStyle = ValidationAlertType.Warning;
validation.ErrorTitle = “Warning”;
validation.ErrorMessage = “Please select a value from the list”;
CellArea area;
area.StartRow = 3;
area.StartColumn = 3;
area.EndRow = 3;
area.EndColumn = 3;
validation.AreaList.Add(area);
worksheet.Cells[3, 3].PutValue(“value 2”);

workbook.Save(“wrk1.xml”, SaveType.OpenInBrowser, FileFormatType.SpreadsheetML, Response);
Response.End();

Thanks for your help.

Hi,

Thanks for pointing it out.

We found the issue, we will fix it soon.

Thank you.

Thanks that works fine.