After opening a spreadsheet and checking the columns count property - it only reflected the last column which actually had data in.
Despite the fact that many additional columns where visible ie. ABCDEFGHIJK... etc. if no data had been populated yet the columns.count only showed a value of 1.
Is this correct ? and does this mean in order to manipulate columns/cells on a clean spreadsheet I need to insert the additional columns before I can use them. How do I tell what are actual columns as against what are being shown in the spreadsheet.