Cannot insert sheet in .ods file

Help with installation and general system troubleshooting questions concerning the office suite LibreOffice.
Post Reply
Dond3320
Posts: 7
Joined: Sat Nov 17, 2012 9:07 pm

Cannot insert sheet in .ods file

Post by Dond3320 »

I have a LibreCalc file created from scratch. It consists of 7 sheets which I had no problem creating using the "right click" with the cursor over the green plus sign at the end of the sheet list and selecting the "Insert Sheet" option on the pop up menu.

Don't know exactly at what point this function was lost but, for this Calc file only, so far, the menu that pops up using "right click" as above no longer contains the insert sheet function; it is not greyed out; it just isn't there. In the menu for the "Insert" function the "Sheet" option is greyed out. The file is not protected. What could I have done with this file to create this problem and how do I fix it?? :?
Libre Office 3.5.4.2, Build ID 350m1 (Build:2), OS Ubunto 12.04 LTS on a Dell Inspiron 1720
User avatar
TheGurkha
Volunteer
Posts: 6482
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.

Re: Cannot insert sheet in .ods file

Post by TheGurkha »

It's a left-click on the green + that creates a new sheet, not a right-click. If I right-click the grey area to the right of the green + I get a context menu with the insert sheet option in it.

If you start a new spreadsheet altogether can you use the green + to add a sheet?
Ubuntu 14.10 Utopic Unicorn, LibreOffice Version: 4.3.3.2
Gurkha Welfare Trust
Dond3320
Posts: 7
Joined: Sat Nov 17, 2012 9:07 pm

Re: Cannot insert sheet in .ods file

Post by Dond3320 »

On my system it's a right click and to answer your question, on a new spread sheet or on all others, new or old, I've worked with since switching to Ubuntu, a right click gets me the option to create a new sheet and exercising the option creates a new sheet. I remain baffled.
Libre Office 3.5.4.2, Build ID 350m1 (Build:2), OS Ubunto 12.04 LTS on a Dell Inspiron 1720
User avatar
RoryOF
Moderator
Posts: 34618
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Cannot insert sheet in .ods file

Post by RoryOF »

Trying AOO 3.4.1 on Ubuntu 12.04 a left click on the blank space after the sheet tabs immediately pops up an Insert Sheet window, a right click pops up a context menu, offering Insert/Delete/Rename and other sheet functions, as well as Cut/Copy/Paste.

Edit: there may be a difference here between AOo and LibO, as I cannot see any green + sign.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Post Reply