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

Free Support Forum - aspose.com

Merge & Center option got selected even it is having single cell


This sample Excel having table with 3 columns(From column A to C)

In that 2 columns A and B are merged. I am trying to delete Column B which is part of merged cells. Column B successfully deleted.

Actual Issue is “Merge & Center” option in toolbar still showing as selected even column A not merged with any other column. As merge option selected for column A, we not able to proceed with sort on that column A.

Please find the attached input and output file.

Or Is there any possibility to unmerge entire column A without iterating each cell. Because we will have huge Excel file to process.

Please find the below code that we used to remove column.

Worksheet worksheet = reportbook1.getWorksheets().get(0);
Cells cells = worksheet.getCells();
worksheet.getCells().deleteColumn(1, true);

Thanks in Advance,

Hi Sivasankari,

I have observed the information shared and the issue seems to be related with Aspose.Cells. I am moving this thread to Aspose.Cells forum for further assistance in this regard.

Many Thanks,