We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Why can't I copy or move a sheet within a spreadsheet document? [closed]

asked 2014-07-12 19:39:02 +0200

Windcheetah gravatar image

updated 2020-08-20 18:47:51 +0200

Alex Kemp gravatar image

Hi, I'm using Version: Build ID: 420m0(Build:2) in the English(UK) language and the sheet component. I use ubuntu 64 bit O/S with the XFCE front end.

I am unable to move or copy a sheet within a document. I do not know about to a new document, as I feel this will be a little beoynd my simple usage.

I can select a sheet, e.g. the current sheet in the document, then when I go to Edit/Sheet, Move/Copy and Delete are not selectable, only Select and Events are enabled.

Can anyone let me know what I'm doing wrong??

Thanks loads Martin

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-29 16:45:54.269152



Please have a look at the title bar, whether the document is "read-only". If that is not the reason, please tell: Is it a problem with a special document or with all? Native file format .ods ? Can you alter the content in single cells ? Is it a local file or do you open it from somewhere in the network? Can you add a new sheet? Is the sheet protected?

Regina gravatar imageRegina ( 2014-07-12 22:30:51 +0200 )edit

Thanks, it is NOT a read-only document. It would appear to be a problem with some thing that I've done to the document, as I can move on a new ods doc. I did create the the doc in LibreOffice so not an inport/conversion issue, and as far as I can tell, it is not protected. Yes I can alter cells and it is on my local computer. Thanks Martin

Windcheetah gravatar imageWindcheetah ( 2014-07-13 14:14:59 +0200 )edit

I could duplicate your symptoms by protecting the Document (Tools/Protect Document/Document) and not entering a password. Is that the case with you?

w_whalley gravatar imagew_whalley ( 2014-07-13 15:26:44 +0200 )edit

No, I'm afraid not, but I now have the answer. Please see below. Martin

Windcheetah gravatar imageWindcheetah ( 2014-07-13 15:33:36 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2014-07-13 15:15:47 +0200

Regina gravatar image

Thanks for providing the document, that makes investigating easy. The reason is, that the document is in "record changes" mode. Goto Edit > Changes > uncheck 'Record' and you will be able to move or copy the sheet. The current implementation of change tracking does not allow moving or coying of sheets.

edit flag offensive delete link more

answered 2014-07-13 15:35:25 +0200

Windcheetah gravatar image

Thanks loads, A WINNER I don't remember setting it to record, but I must have done at some stage, in an effort to fix the problem.

Thanks loads Martin

edit flag offensive delete link more


Please do not add comments as answers, but click the checkmark next to the question to mark the answer as a solution to your question. Thanks.

bencomp gravatar imagebencomp ( 2014-07-13 16:58:14 +0200 )edit

Question Tools

1 follower


Asked: 2014-07-12 19:39:02 +0200

Seen: 64,432 times

Last updated: Jul 13 '14