[Solved] Sheet Tabs

Discuss the spreadsheet application

[Solved] Sheet Tabs

Postby Marioz » Wed Jan 19, 2011 1:12 am

I have lost the sheet tabs on my spreadsheet. The sheets still exist which I access through Edit-Sheet-Select. I would really appreciate it if someone could tell me how to restore my sheet tabs.

Thank You
Last edited by Hagar Delest on Thu Jan 20, 2011 9:17 am, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 3.2 on Windows Vista
Marioz
 
Posts: 5
Joined: Wed Jan 19, 2011 1:02 am

Re: Sheet Tabs

Postby Villeroy » Wed Jan 19, 2011 1:16 am

Somewhere in Tools>Options>Calc>View
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 27760
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Sheet Tabs

Postby Marioz » Wed Jan 19, 2011 4:32 am

Thank you for your effort but was not successful
OpenOffice 3.2 on Windows Vista
Marioz
 
Posts: 5
Joined: Wed Jan 19, 2011 1:02 am

Re: Sheet Tabs

Postby Rugslug » Wed Jan 19, 2011 4:52 am

Maybe Format, Sheet, Show

Then a dialog pops up showing the hidden sheets....(crossing fingers)
Windows XP SP3 & 7 with OpenOffice 3.4.1 / LibreOffice 3.6.1
Rugslug
 
Posts: 8
Joined: Fri Oct 09, 2009 4:56 am
Location: Canada

Re: Sheet Tabs

Postby Marioz » Wed Jan 19, 2011 7:08 am

No, that didn't work either. I did learn that I am able to navigate between sheets using CTRL- Page Up or Page Down. I do appreciate the responses - thank you.
OpenOffice 3.2 on Windows Vista
Marioz
 
Posts: 5
Joined: Wed Jan 19, 2011 1:02 am

Re: Sheet Tabs

Postby Charlie Young » Wed Jan 19, 2011 9:20 am

Marioz wrote:No, that didn't work either. I did learn that I am able to navigate between sheets using CTRL- Page Up or Page Down. I do appreciate the responses - thank you.


If it's not hidden sheets or the Tools>Options setting, try resetting your user profile.
Apache OpenOffice 4.1.1
Windows XP
User avatar
Charlie Young
Volunteer
 
Posts: 1559
Joined: Fri May 14, 2010 1:07 am

Re: Sheet Tabs

Postby JohnSUN-Pensioner » Wed Jan 19, 2011 1:35 pm

Maybe so?
RestoreTabs.gif
Animated GIF - Allow animated in your browser
RestoreTabs.gif (7.12 KiB) Viewed 7177 times
I may not have a lot to give but what I got I'll give to you...
Apache OpenOffice 4.1.4, LibreOffice 5.4.2.2 (x64) on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
User avatar
JohnSUN-Pensioner
Volunteer
 
Posts: 761
Joined: Fri Jan 14, 2011 1:21 pm
Location: Kyiv, Ukraine

Re: Sheet Tabs

Postby johntait » Thu Jan 20, 2011 12:33 am

Hi

Despite what you said above, it should be under Tools-Options-OpenOffice.org Calc (you need to expand this by clicking on "+" and it will give you further options including "View"). Click on this "View" and a menu starting with "Visual aids" will come up - on the bottom right there is a heading Windows and under that should be a tick box for Sheet Tabs. Tick this,then click OK and the tabs should come back.
OpenOffice 4.1.1 on Windows Vista
johntait
 
Posts: 13
Joined: Tue Jan 18, 2011 11:32 am

Re: Sheet Tabs

Postby Marioz » Thu Jan 20, 2011 1:07 am

Thank you very much, Johntait, that worked beautifully. When I first went in "sheet tab" was checked so I unchecked it, enterd the new setting and went back in and restablished it with the "sheet tab" checked and I am back to normal. I really appreciate all the responses I received from everyone. What a great resource. Happy New Year Everyone.
OpenOffice 3.2 on Windows Vista
Marioz
 
Posts: 5
Joined: Wed Jan 19, 2011 1:02 am

Sheet tabs & editing

Postby jagsfish » Thu Mar 17, 2011 7:08 pm

I have no Sheet Tabs and I cannot edit my spreadsheet. I can only scroll through the pages. Any suggestions? I have been using this program for several months and have not had a problem.

Thanks
OpenOffice 3.3 on Windows Vista
jagsfish
 
Posts: 2
Joined: Thu Mar 17, 2011 6:35 pm

Re: [Solved] Sheet Tabs

Postby Marioz » Thu Mar 17, 2011 7:36 pm

Please see johntait reply above - it worked for me. Good Luck.
OpenOffice 3.2 on Windows Vista
Marioz
 
Posts: 5
Joined: Wed Jan 19, 2011 1:02 am

Re: [Solved] Sheet Tabs

Postby Hagar Delest » Thu Mar 17, 2011 9:25 pm

Watch carefully the pic, it's an animated gif.
AOO 4.1.7 on Xubuntu 19.10 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28681
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Sheet Tabs

Postby chuimuro » Thu May 26, 2016 2:36 am

JohnSUN-Pensioner wrote:Maybe so?
RestoreTabs.gif


THANK YOU FOR THIS!!! :bravo:
OpenOffice 4.1.2 on Windows 7
chuimuro
 
Posts: 1
Joined: Wed May 25, 2016 5:49 pm

Re: Sheet Tabs

Postby appletreasures » Wed Nov 13, 2019 10:34 pm

johntait wrote:Hi

Despite what you said above, it should be under Tools-Options-OpenOffice.org Calc (you need to expand this by clicking on "+" and it will give you further options including "View"). Click on this "View" and a menu starting with "Visual aids" will come up - on the bottom right there is a heading Windows and under that should be a tick box for Sheet Tabs. Tick this,then click OK and the tabs should come back.


I had the same problem.
I followed your steps.
Sheet Tabs was ticked.
I toggled it off, and clicked OK.
Next I toggled it on, and clicked OK.
My sheet tabs reappeared.

Thanks for posting the solution.
OpenOffice 3.3.0 on Windows 7
appletreasures
 
Posts: 2
Joined: Sun Jun 03, 2018 7:05 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 12 guests