Dear Support Team,
My application uses Style and StyleFlag to re-format my spreadsheets. Depending on the underlying cell, row, and column characteristics, I am required to format the cells in a number of passes (one to three passes), switching the required StyleFlags on/off as required.
The first pass applies the formatting on a cell by cell basis (therefore I use Cell.SetStyle()), whereas, the second and third passes apply formatting on a Row and Column level respectively, using the ApplyStyle() method.
Originally, my application was built using Aspose.Cells v18.104.22.168 and all seemed to work fine. I have recently identified a number of issues in v22.214.171.124 and await these to be included as fixes in the next release. Therefore, I have rebuilt my application using v126.96.36.199 to begin the re-testing process. Unfortunately, it would now appear that the ApplyStyle() method has been corrupted in v188.8.131.52/v184.108.40.206.
Please see attached in the zip file the spreadsheet I am using for testing (Aspose.Cells.XLSM), the output generated by v220.127.116.11 (which is what I expect to see) and the output generated by v18.104.22.168/v22.214.171.124 (which is no longer behaving as expected).
The vb.net code is also included to replicate this behaviour.