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

Free Support Forum - aspose.com

Incorrect value of data validation rule

We have the following file: DataValidation.zip (14.6 KB)
And the following code:

var workbook = new Workbook("DataValidation.xlsx");

var validation = workbook.Worksheets["Sheet1"].Validations.GetValidationInCell(10, 2); // cell C11
var value1 = validation.Value1; // actual: =-1000, expected -1000
var value2 = validation.Value2; // actual: 1000

We noticed that the ‘Value1’ property of this data validation rule is incorrect. The ‘=’ sign is added, which is not the case in Excel. The ‘Value2’ property is correct.

@infotron,
This issue is observed and logged in our database for an analysis and fix. We will write back here once any update is ready to share.

This issue is logged as:
CELLSNET-47426 - Incorrect value of data validation rule

@infotron,
This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-47426”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

@infotron,
Please try our latest version/fix: Aspose.Cells for .NET v20.6.2:
Aspose.Cells20.6.2 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.6.2 For .Net4.0.Zip (5.4 MB)

Your issue should be fixed in it.

This issue is also fixed in Aspose.Cells v20.6.2. Thank you!

@infotron,

Good to know that your issue is fixed with the latest fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

The issues you have found earlier (filed as CELLSNET-47426) have been fixed in Aspose.Cells for .NET v20.7. This message was posted using Bugs notification tool by ahsaniqbalsidiqui