open office

i am using open office 4.1.3. i am trying to add columns to my spreadsheet by right clicking and hit add column, but when i do that i m told "filled cells cannot be shifted beyond the sheet" can anyone help thank you