I am running into another issue when saving an Excel document in XLSB format. Validations do not seem to work.
The result should be that when adding a negative number or non-numeric value to any cell in the first row a validation message pops. Works great in XLSX, but does not work at all in XLSB.
This is somewhat similar to an issue posted earlier this week regarding Excel formulas: SUMIFS Excel function does not work in XLSB format
I’m using the .NET v220.127.116.11 version of Aspose.Cells.
Thanks for providing us sample project.
After an initial, I observed the issue as you mentioned by using your sample project. I found that Validations are not applied and do not work in XLSB format, it works fine in XLSX file format though. I have logged a ticket with an id “CELLSNET-44034” for your issue. We will look into it soon.
Once we have any update on it, we will let you know here.
This is to update you that we have fixed the problem logged earlier as CELLSNET-44034. We will shortly provide the fix here after ensuring the quality, and incorporating other enhancements. As soon as the next build of Aspose.Cells for NET API is available for your testing, we will notify you in reference to aforementioned tracking number.
Thanks for your using Aspose.Cells.
Please download and try the latest fix: Aspose.Cells for .NET v18.104.22.168 and let us know your feedback.