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.
Thank you for contacting Aspose support.
Could you be kind enough to provide a sample console application replicating the issue with latest version of Aspose.Cells for .NET 220.127.116.11 along with input & output files? This will help us evaluate the presented scenario more efficiently.