Appending a hidden column

[mozaharul]

Hi,

Is it possible to append a hidden column in front of the existing first column/cell?

Statement: table9.SelectCell("H",0)
appends a zero width column after the existing last column/cell and the appearance of the row in the screen starts at the end – that is not desired.

regards.

 

[Cableguy]

I'm not sure of that, but it is possible to have two tables, one visible and the other invisible, and have their values correlated....

 

[Erel]

You can add a hidden column by setting the column width to 0 (when you add the column).

 

[willisgt]

It is not possible to add a column in the first (or leftmost) position. If you add a column to a table, it will always be in the far right position.

The only way around this (that I can think of) would be to create a second table, and add the column you want. That column would then be in the leftmost position. You would then have to basically copy all of the columns from the first table to the second table, and then copy the value of each cell from table1 to table2.

You could then dispose of the first table.

Make sense?

Gary