Ask Your Question

Calc sheet tab numbering?

asked 2018-12-02 16:57:58 +0200

warren3200gt gravatar image

Is there anywhere you can control how added tab names are auto created?

EG, Calc sheet with page 1 called warren 1 on the document tab. Right click and hold + Ctrl the tab, move to the right to copy the sheet and the new copy sheet tab auto names itself warren 1_2 and I want it to auto name itself warren 2? then warren 3 and not warren 1_3 etc.

edit retag flag offensive close merge delete


I don't know of a way to get it working the way you want without user code.
By the way:
Avoid sheet names with spaces and/or special characters.
Avoid series of sheets of same structure.

Lupp gravatar imageLupp ( 2018-12-02 18:36:20 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-12-02 17:46:20 +0200

ebot gravatar image

Select Tools>Options>LibreOffice Calc>Preferences. There you can choose a name for the future tables and OK. For a new table you only need to click on the "+" sign (new table).

If my answer did solve your problem, please click the big checkmark inside the circle to the left of this answer.

edit flag offensive delete link more


The OP wanted to copy an existing sheet. Your proceeding addresses the creation of new sheets.

Lupp gravatar imageLupp ( 2018-12-02 18:31:49 +0200 )edit

This is also possible with an existing table. You then have to rename only "Table1".

ebot gravatar imageebot ( 2018-12-02 19:36:31 +0200 )edit

answered 2018-12-02 18:07:33 +0200

warren3200gt gravatar image

updated 2018-12-02 18:24:34 +0200

I don't appear to have preferences menu. Tools>Options> LibreOffice Calc I can get to but then only have options for general, default, view, calculate, formula, sort lists, changes, grid and print. What Im trying to do is generate a new sheet within a document with a consecutive sheet number. What is happening at the present is sheet one is called warren 1. When I right click+ctrl on that tab, drag to the right to generate a new copy sheet, it auto names the new sheet warren 1_2. What I want it to do is call the new sheet warren 2. If I do the same again on the new sheet it auto names it warren 1_2_2, when I want it to be warren 3.

I get the idea with the + sign to create a new sheet. However my document has many sheet groups within it each with consecutive numbers. eg I may have warren 1 through 76, paul 1 though 27, mark 1 through 58. etc.

When I want to add another sheet to warren say, I go to the last warren sheet, right click + ctrl, move to the right creating a new sheet which I want to be called warren 77. Not warren 76_2.

Like excel does.

Any idea's?

edit flag offensive delete link more


This is not an answer. To add information, please edit your original question.
To reply to a question in return, or to a statement posted in an answer, use the "add a comment" tool.
In this case the issue is due to different OS used by yourself and by @ebot: Preferences is just the different wording used for Options on the Mac.

Lupp gravatar imageLupp ( 2018-12-02 18:28:16 +0200 )edit

@Lupp thanks. We will probably never learn to become psychics and to know what the "questioner" knows everything and does not announce. ;-)

ebot gravatar imageebot ( 2018-12-02 18:32:46 +0200 )edit

Ok, soz guys, new to your format. Most forums run consecutively, question followed by answer, followed by clarification if required, followed by solution hopefully! So any Ideas?

warren3200gt gravatar imagewarren3200gt ( 2018-12-02 19:03:58 +0200 )edit

Yes. This isn't actually a forum exactly, imo. It's the special case of an "askbot-site" . I don't like it too much.

Lupp gravatar imageLupp ( 2018-12-02 19:46:03 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-02 16:57:58 +0200

Seen: 149 times

Last updated: Dec 02 '18