HI, I wanted to delete the blank columns and rows in the excel sheet and I have used Worksheet.Cells.DeleteBlankColumns(options) and Worksheet.Cells.DeleteBlankRows(options) and Version I am using is 21.10.0 in .net5 . DeleteBlnakRows(options) is working fine but DeleteBlankColumns(options) is not working properly when comments are present, It is correctly deleting the empty columns that were present before the comments but the empty columns after the comments are not getting deleted.
Attaching the sample input and output screenshots of the excel
inputExcel.png (3.8 KB)
outputExcel.png (2.7 KB)
In the output Excel, Empty columns(C and D) after the comment in the cell B1 should get deleted but they are not getting deleted.
Could you help me with this.