Thank you for sharing the sample spreadsheet. We have evaluated the presented scenario while using the latest version of Aspose.Cells for .NET 22.214.171.124 and we are able to replicate the said issue. In order to further investigate the matter, we have logged this incident as CELLSNET-44239. Please spare us little time to properly analyze the scenario and get back with updates in this regard.
This is to update you that we have resolved the problem logged earlier as CELLSNET-44239. We will shortly provide the fix here after ensuring the quality and incorporating other enhancements.
Thanks for your using Aspose.Cells.
Please download and try the latest fix: Aspose.Cells for .NET (Latest Version) and let us know your feedback.