New option to specify initial number of sheets

This just landed on the master branch.

Starting with LibreOffice 3.5, you can now specify the initial number of sheets that new documents will have. Previously, this was hard-coded to be 3 sheets in all cases no matter what. While this didn’t seem to bother a whole lot of people based on how little bug reports we’d received on this, it did bother some users enough so that one of them have decided to code up a patch to make it happen. Now, without further ado, let’s take a look at the new option page:


where you can change the number of worksheets in new document, which becomes effective the next time you create a new document.

Last but not least, the name of the person who made this all happen is Albert Thuswaldner. Please give kudos to him for his excellent work. :-)

7 thoughts on “New option to specify initial number of sheets”

  1. Hey Kohei,

    since we are talking about it. There used to be two nice extensions for OOo. One was about managing worksheets ( and one about statistitcs ( I hope the following link is correct

    I wonder if it is worth to consider an inclusion of these tools in LO. The WorksheetMaker used to be quite convenient to manage names and so on of sheets.


    1. Hi Hans, Thanks for the URL. If the tools are indeed useful, why not? Though I normally prefer to implement truly useful functionality in the core, not as extensions.

      1. Hi Kohei,

        cool that you like them. I think it is a pitty that so much cool features for LO/OOo exist without a broad acceptance or spread. Maybe some day we see them in LO. Maybe you can put the link some place in the wiki or so?


        P.S.: I really have great respect for your and other developers work. Keep up the good work.

      2. The Worksheetmaker sound interesting, I will have a look at it. See If I can implement some of that in LO.

        I was myself thining of adding some more options maby to set the the default names of the sheet tabs.

        Someone might want to call them

        Tab A, Tab B, …


        Year 2011, Year 2012, …

        or what ever. Just a thought.

        (@Kohei I’m hnoured to be mentioned in your blog, thanks!)

        1. Hi Albert,

          that would certianly be awsome. The functionality provided by the extension was really good at that time.

          The default names sound good too. But if you start implementing such things you should try to make it configurable with “templates” (list of names which is loaded …).

          I do not know how familiar you are with gnumeric. In any case gnumeric has in my opinion the best implementation for worksheet management I know of. Besides an “crazy” option to change row and column numbers on the fly it is also possible to sort worksheets or to label them in a convenient way. Defenetly something to learn from.

          keep up your excellent work


Comments are closed.