Axolot Data

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);

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.