Inserting Columns does not update worksheet references

Aspose.Cells Product Family
1

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.

2

Hi,

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.

3

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

w.Cells.InsertColumn(cREQCOL, true);