At 13:27 17/12/2016 +0000, Keith Brown wrote:
I've been using OpenOffice for a couple of months but now suddenly find I cannot copy a worksheet in a spreadsheet workbook.

You are suffering from MicrosoftNamingItis. In OpenOffice, the sheets of a spreadsheet document are called "sheets" and the spreadsheet document is called a "spreadsheet". There are no workthises or workthats.

When I select Edit>Sheet> the Move/Copy option is no longer highlighted to use nor the Delete option. I'm guessing it must be to do with access rights ...

I'm guessing too, but there are two obvious possibilities:

o You have the spreadsheet open in read-only mode. Click the Edit File button in the Standard toolbar. If the original is marked as read-only in your operating system, this will offer to create a copy which you can then edit.

o The spreadsheet is set up for sharing - simultaneous editing by multiple users. If this is not intentional, go to Tools | Share Document... and remove the tick from "Share this spreadsheet with other users".

The option at Edit | Sheet > | Delete... is also disabled if you have selected multiple sheets simultaneously, using Ctrl+click on the sheet tabs - but that doesn't sound as if it is what you have done here.

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Reply via email to