SpreadsheetML DataValidation range issue

[acturisaspose]

Hi,

In the attached input SpreadsheetML file there is DataValidation element that specifies range in following way:

R3C4:R2C2

Notice the range goes from high values to low values. When opened in Aspose.Cells and saved to XLSX the excel will display user notification about corrupted data. If I switch the range it will work as expected:

R2C2:R3C4

Could you take a look at this, please?

Thanks,
Maciek

DataValidationReverseRange.zip (1.1 KB)

[Amjad_Sahi]

@acturisaspose,

Thanks for the template file and details.

After an initial test, I observed the issue as you mentioned by using the following sample code with your template file. I found Excel file is corrupt due to data validation range after opening and resaving it via Aspose.Cells APIs. I used the following sample code to convert your SpreadsheetML file to XLSX file format:
e.g
Sample code:

Workbook wb = new Workbook("e:\\test2\\DataValidationReverseRange.xml"); 
            wb.Save("e:\\test2\\out1.xlsx");

I have logged a ticket with an id “CELLSNET-45570” for your issue. We will look into it soon.

Once we have an update on it, we will let you know here.

Thank you.

[Amjad_Sahi]

@acturisaspose,

This is to inform you that we have fixed your issue but please avoid such non standard data.

Once the fix is available for public use, we will let you know here.

Thank you.

[Amjad_Sahi]

The issues you have found earlier (filed as CELLSNET-45570) have been fixed in Aspose.Cells for .NET v17.8.