Each line of my spreadsheet looks like this:
Code: Select all
ItemNumber InventoryCount PhysicalCount Difference
Code: Select all
ItemNumber InventoryCount PhysicalCount Difference
Code: Select all
Sub ClearColC
oSheets = ThisComponent.getSheets()
oObj1 = oSheets.getByName("Sheet1")
oColumns = oObj1.getColumns()
oObj2 = oColumns.getByName("C")
oObj2.clearContents(1) `the 1 causes numeric values to be deleted.
End Sub