Calc sheet tab numbering?

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.

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.

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.

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

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

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?

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 @Hrbrgr: Preferences is just the different wording used for Options on the Mac.

@Lupp thanks. We will probably never learn to become psychics and to know what the “questioner” knows everything and does not announce. :wink:

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?

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.