When I use the Cells collection to insert a new column, then copy the content from another column, the behavior is not the same as in Excel. If I place a header at the top of the copied column such as ‘Column 1’, in Excel dragging the fill handle will create columns with headers ‘Column 2’, ‘Column 3’, etc in numerical order. In Aspose.Cells, this would result in ‘Column 1’, the source column, followed by ‘Column 12’, ‘Column 13’, etc. Aspose.Cells does not seem to recognize the pattern and increment the header text as Excel would.
Hi Jeffery,