Apache OpenOffice Community Forum

I suspect this is easy, but


When I start a new spreadsheet, it starts with 3 sheets and will print Sheet 1
as the header. I have to delete sheets 2 and 3 and turn off header.

How can I have a new spreadsheet start off that way?

Mel, using 4.xx

Edit: Changed subject, was when starting a new spreadsheet how do I...  Make your post understandable by others  -- MrProgrammer, forum moderator

Leave them alone; they don't do any harm, and when your spreadsheet becomes more advanced you may need extra sheets to present results.

Thanks for the quick response. But it still prints SHEET1 as a heading. I would like the default be to NOT print SHEET1.
I can create this and save it and always open it for any new spreadsheet, but can't I do it so that opening a new spreadsheet does this?
I'm sure it's very basic.

Mel

compiler wrote: ↑Sat Apr 22, 2023 7:31 pm When I start a new spreadsheet, it starts with 3 sheets and will print Sheet 1 as the header. I have to delete sheets 2 and 3 and turn off header. How can I have a new spreadsheet start off that way?

Create a spreadsheet with the properties that you want:
• Single sheet   (use Edit → Sheet → Delete → …)
• No header     (use Format → Page → Header → uncheck Header on)

Save this as a template and make that template the default for Calc. I find it helpful to put styles that I often use in the default template,
[Tutorial] Creating a new default template

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

You can set this property in the LibreOffice: