I have 36 sheets on my spreadsheets but need 10 more sheets to work?

Asked by Chetan Mehta on 2015-11-23

On spreadsheet that I am working does not allow me to have more than 36 sheets. I need to have 10 more sheets. How can I copy 10 extra sheets?

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
2015-12-10
Last reply:
2015-12-10

If you post on the OpenOffice forum it may be addresses there too.

Tony Pursell (ajpursell) said : #2

Libreoffice will allow many more than 36 sheets in a spreadsheet.

Is this an Openoffice.org limitation?

Or perhaps you have hit the limit for the number of sheet tabs that can be displayed. In LibreOffice 5 you have < and > buttons to the left of the tabs to scroll through them.

I suggest you change to LibreOffice if you are using Ubuntu.

Chetan Mehta (chetan-g) said : #3

On Monday 23 November 2015 17:52:03 Tony Pursell wrote:
> Your question #275274 on openoffice.org in Ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/27527
>4
>
> Status: Open => Answered
>
> Tony Pursell proposed the following answer:
> Libreoffice will allow many more than 36 sheets in a spreadsheet.
>
> Is this an Openoffice.org limitation?
>
> Or perhaps you have hit the limit for the number of sheet tabs that can
> be displayed. In LibreOffice 5 you have < and > buttons to the left of
> the tabs to scroll through them.
>
> I suggest you change to LibreOffice if you are using Ubuntu.

Dear Tony,

I have Open Office.org

In it there are 36 sheets.
On the last sheet if I want to MOVE/COPY SHEET I will right click on mouse and
normally the box will open with options cut,copy,paste and on the top there
should be select all sheets and there should be four more selection that is
Insert, Del, Rename sheets,Move/Copy but in my Open Office .Org I only have
Select all sheets above cut,copy,Paste. The Move?Copy Sheet selcetion is not
there.

Will appreciate if I have your contact phone number then will be able to
discuss this issue.

Launchpad Janitor (janitor) said : #4

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Chetan Mehta (chetan-g) said : #5

On Thursday 10 December 2015 08:27:44 Launchpad Janitor wrote:
> Your question #275274 on openoffice.org in Ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/27527
>4
>
> Status: Open => Expired
>
> Launchpad Janitor expired the question:
> This question was expired because it remained in the 'Open' state
> without activity for the last 15 days.

The problem has not been solved?

Manfred Hampl (m-hampl) said : #6

Did you try contacting openoffice support https://www.openoffice.org/support/index.html

You have to be aware that Ubuntu does no more provide openoffice but libreoffice.

Tony Pursell (ajpursell) said : #7

Hi Chetan Mehta

I have tested this in the current version 5 of LibreOffice and can confirm that there is no problem selecting 36 sheets and using Move/Copy to copy all of them. I can only suggest you change from OpenOffice.org to LibreOffice. Not only does LibreOffice work correctly but you can get support from the Ubuntu community for it. OpenOffice.org has not been supported in Ubuntu for many years now.

Can you help with this problem?

Provide an answer of your own, or ask Chetan Mehta for more information if necessary.

To post a message you must log in.