Hi,
Please explain the difference between these methods:
Component.Sheet[0].Columns.AddIfNone(X,Y);
Component.Sheet[0].InsertColumns(X,Y);
Component.Sheet[0].Columns.InsertColumns(X,Y);
column insertion / addition
Re: column insertion / addition
Hello
1. Component.Sheet[0].Columns.AddIfNone(X,Y);
This will ensure that there is a column object at the position(s).
2. Component.Sheet[0].InsertColumns(X,Y);
This will insert columns at the position, shift existing cells and columns to the right.
3. Component.Sheet[0].Columns.InsertColumns(X,Y);
This will only shift the columns (headers) to the right. Cells are untouched.
1. Component.Sheet[0].Columns.AddIfNone(X,Y);
This will ensure that there is a column object at the position(s).
2. Component.Sheet[0].InsertColumns(X,Y);
This will insert columns at the position, shift existing cells and columns to the right.
3. Component.Sheet[0].Columns.InsertColumns(X,Y);
This will only shift the columns (headers) to the right. Cells are untouched.
Lars Arvidsson, Axolot Data