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?