I need to merge table header cells horizontally and some vertically. The problem is that after merging first 2 cells indexing of other cells changes. So, after merging cell(1,1) and cell(1,2) the original cell(1,3) changes to cell(1,2). I have some headers with 3-4 rows and about 10 columns with different merging configurations.
I create 2 arrays:
1- mergeFrom[(1,1),(1,4) ...........]
.Cell(mergeFrom(i).Row, mergeFrom(i).col).Merge .Cell(mergeTo(i).Row, mergeTo(i).col)
What is the way to keep track of changing cell coordinates after merging cells??
Also, merging cell by cell if very slow. Is the better/faster way to merge cells?