We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Inserting Columns does not update worksheet references

I am using Aspose.Cells to work with template files.

For a couple of my templates I need to insert columns. When I do, my cell references from other worksheets are not updated. This behaivor is different than what I observe in Excel.

Example : I have Sheet1 with column G and I have a cell that references sheet1 column G on Sheet 2.

If I insert a column on sheet1 say at column D, my cell reference on sheet 2 still references column G when using Aspose to modify the workbook. In Excel if I performed an insert column the cell on sheet 2 would reference Column H. It would be nice to have Aspose replicate the behavior of Excel in terns of tracking cell references.

This is a great product, just though I would offer a susggestion if it is feasable.


Could you please post your sample template file with your code here, we will surely check your issue and fix it (if we found the issue).

Thank you.

Found what I needed, needed to pass is in extra parameter tu update references.

w.Cells.InsertColumn(cREQCOL, true);