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

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

Windcheetah
17 ●4 ●4 ●10

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

flag of United Kingdom of Great Britain and Northern Ireland

20317 ●18 ●59 ●59 http://etmg.altervista...

Hi, I'm using Version: 4.2.4.2 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

Comments

1

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 ( 2014-07-12 22:30:51 +0100 )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 ( 2014-07-13 14:14:59 +0100 )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 ( 2014-07-13 15:26:44 +0100 )edit

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

Windcheetah ( 2014-07-13 15:33:36 +0100 )edit

add a comment

3

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

Regina

11775 ●8 ●59 ●104

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

add a comment

0

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

Windcheetah
17 ●4 ●4 ●10

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

Comments

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 ( 2014-07-13 16:58:14 +0100 )edit

add a comment

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

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

Comments

2 Answers

Comments

Question Tools

Stats

Related questions

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

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

Comments

2 Answers

Comments

Question Tools

Stats

Related questions

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

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