Open Office Spreadsheet

Alfie_E

LouBlue wrote: »

I don't have a sheet tab.

It could be turned off. Go to Tools → Options... → OpenOffice.org Calc → View → Window → Sheet tabs. This option needs to be ticked on. Alternatively, it could have got resized to ‘nothing’.

LouBlue

Alfie_E wrote: »

It could be turned off. Go to Tools → Options... → OpenOffice.org Calc → View → Window → Sheet tabs. This option needs to be ticked on. Alternatively, it could have got resized to ‘nothing’.

Clicked on Tools, then Options, there are 3 tabs. General, View and Data Entry. None of these have an OpenOffice.org calc option.

S0litaire

Have you tried the "Click and Drag" option in the picture above??


If you go to "Insert" there should be an option for "Sheet"

LouBlue

S0litaire wrote: »

Have you tried the "Click and Drag" option in the picture above??


If you go to "Insert" there should be an option for "Sheet"

I have tried the click and drag but nothing happens and when I click on Insert, it gives me these options:

Insert

Page Break
Row
Column
Function
Range Name

I am getting so frustrated.

Alfie_E

LouBlue wrote: »

…when I click on Insert, it gives me these options:

Insert

Page Break
Row
Column
Function
Range Name

I am getting so frustrated.

Strange as it may sound, you’re describing Microsoft Works. This doesn’t have the ability to handle spreadsheets containing more than one worksheet, so there are never any tabs at the bottom of the window. For example, here’s the drop-down Insert menu as it appears in OpenOffice.org Calc versions 2 and 3. (Version 1 is very slightly different.)

Below is the Sheet tabs option that Lord_Gardener and I were referring to.

1. Open up the OpenOffice.org Calc branch by either clicking on the + or double clicking on the name. If you’re still using OpenOffice.org version 1, this branch is called Spreadsheet. In OpenOffice.org versions 2 and 3, you must bring up the Options window from Calc. Opening the Options window from, say, Writer will show only those branches relevant to Writer.
2. Select the View leaf.
3. Make sure the Sheet tabs option is ticked, then click OK.

Lord_Gardener

Let's hope the above works for you! If not, can you paste an image of what you see and full details of the Openoffice you have.

LouBlue

Aaaah yes, thank you! OH opened it in Microsoft Works. I had no idea, thought he had used OpenOffice....

We will start a new one at the weekend, not that much to copy over. At least I can see the tabs at the bottom of the OpenOffice one. Thought I was going mad!

Thanks to everyone for all your help.

Alfie_E

LouBlue wrote: »

We will start a new one at the weekend, not that much to copy over.

If you saved it as a default Microsoft Works Spreadsheet file from Works 6 or later (.xlr), it’ll load straight into OpenOffice.org. If you have trouble with that, load the file back into Works and re-save it as a Microsoft Excel file. Choose the type of file for the newest version of Excel that your version of Works will save as.

LouBlue

Alfie_E wrote: »

If you saved it as a default Microsoft Works Spreadsheet file from Works 6 or later (.xlr), it’ll load straight into OpenOffice.org.

Yep it did that, you are a star.