Consider a simple HTML table with tr td tags. Now make it a bit complex by adding rowspans and colspans.
When you try to delete a column which already spans some column it should delete the spanned columns also. It's like in excel when you select a cell and say "Delete-->Entire column", it deltes the related cells for example
A F B D G C E H
A (Blank) F
B D G
C E H
Now if I delete A then I should delete the next side column also. Again after deleting it, it will restore the table to it's original state. Meaning --> RowSpan and colspan of other cells will be restored to their original values. Obviously this method is complex and causes some errors.
Is there any other way to achive this excel deletion functionality?