Hi, I’ve encountered a bug with using DeleteRange() along with meged cells. My designer file, code, and resultant XLS file are here: ftp://ftp13VDTGY:xWrNKm@ftp.directsupply.com (FireFox doesn’t interpret the FTP addy right, use IE or explorer ). I’m using version 126.96.36.199.
After inserting my DataTable I sometimes have to delete an unneeded column but not touch some header text up above, so I’m using DeleteRange with ShiftType.Left to nuke the column and its header. This works great except when there are merged cells to the right of the deletion, their contents get shifted over one but the cell doesn’t get deleted, it’s wierd. When I manually do the same operation in Excel it works as expected.
Here’s my DeleteRange() call:
ws.Cells.DeleteRange(2, 0, 5, 0, ShiftType.Left);