Free Support Forum - aspose.com

DeleteRange gives 'Invalid shift option' when shifting right or down

Hey guys,

Every time I call Worksheet.Cells.DeleteRange with a final argument of Cells.ShiftType.Down or Cells.ShiftType.Right, it throws an invalid shift option exception. What are the rules for shifting right and down? Or is this just a bug? Thanks.

Matt

If Matt,

If you call DeleteRange, the shift option should be ShiftType.Left , ShiftType.Up or ShiftType.None.

The option ShiftType.Down or ShiftType.Right only apply for InsertRange.