To remove the extra columns:
- Click any cell to activate the table and show the column and row reference tabs.
- Click the tab for the leftmost column that you want to remove to select that column.
- Scroll right to the last column of the table.
- Press shift and click the tab for the last column to add it and all coumns between it and the column previously selected.
- Place the pointer toward the right end of one of the selected tabs, then click on the small v that appears, and choose Delete selected columns.
- Scroll left until you can see the table again.
There is no way to prevent the user from adding columns to (or rows) to the table except by locking the table. (Arrange menu>Lock), but this action will prevent moving the table and will prvent editing or adding to the contents of the table. It does not prevent operation of any formulas previously entered, so can be useful for tables containing only fixed values and/or formulas.
Regarding the files now on OpenOffice:
You should be able to export these from OpenOffice Calc to MS Excel file format (,xlsx) then open the Excel file into Numbers. This involves two translations of the document, one done by OpenOffice, the second done by Numbers. Any features not supported be the applications at both ends of each translation will be lost.
Regards,
Barry
