Report titles not saved for each sheet

I needed different reports created from one set of data. I created different sheets within a worksheet, thinking that each report would print with its own set of data, including title from header. After some experimenting, I found that the name of the report typed in each header wasn’t saved with that sheet. Whatever the last Header contained was the report title used when generating each report. I am sending the worksheet with the tabs and hope someone can help. I don’t want to have to change the header before printing each report, if at all possible.

Thanks for your help.
2022 MEMBER GUEST PLAYER Meals.ods (35.2 KB)

Different page headers require different page styles.
https://books.libreoffice.org/en/CG72/CG7204-StylesAndTemplates.html#toc9

1 Like

I cannot figure out how this applies to my problem. I have researched numerous questions and answers. What I was doing was going in to Page Preview and using the Header to display the Title of the report I wanted. I thought that Header would be saved with each sheet within the Worksheet. I could not find a place in the sidebar for Styles that addressed this. If there is something more specific that you could point me to, I would appreciate it.

Meals2.ods (26.9 KB)

I have opened the spreadsheet, but have no idea what I am supposed to be looking at that addresses my issue. I am not a sophisticated user and am trying to do things that are new to me. If you could point out what I am supposed to be looking at, I would appreciate it.

In print preview each sheet has its own page header.

When I select a sheet and use Print Preview icon from main task bar, no page header title shows at all. Not sure where I should be looking?

menu:File>Print preview [Ctrl+Shift+O]

I think I did a poor job of explaining my problem. If you are referring to the line that shows TABLE LAST FIRST MEAL (Row 1), that isn’t what I am referring to as a title. What I was trying to do was use the HEADER section of FORMAT page in print preview to show the sheet name as the title of the report. The first tab being DINNER CHECK-IN BY TABLE, I wanted that to be centered above all the data on the report for that tab. If I change the header for that sheet, the Header Info changes for every sheet in the whole Workbook. In order to generate the reports I need, I would have to change the header, export as pdf, go to the next sheet and repeat the process for each report. I wanted to be able to have a separate title saved with each tab in the Workbook. I am so sorry for the confusion. I could not import a pdf file to show an example. If you do a print preview using the original spreadsheet of any of the tabs, it has the name of the last report I generated in all the tabs. Thanks again.

I’m pretty sure Villeroy is addressing your exact concern. But it may not be obvious.

There are two ways to get to actually editing the headers for your pages–both end up in the same place.

  1. You open the side bar at the right by clicking on the A icon in the right, grey bar, then click on the second icon under Styles for the page styles. Then you can right-click the page style, click Modify…, select the Header tab, then you click on the Edit button to actually enter the header info. I think this edit is made right there in the dialog in Excel, so you might be missing it if that’s your spreadsheet history.
    Your sheet currently has only the default page style in play:


    Villeroy has added page styles, each of which can be right-clicked to be modified as noted above:

  2. You press ctrl+shift+o to open the print preview screen then click on the Page Format Icon, then the Header tab, etc. The icon is
    Screenshot from 2022-02-07 20-31-29

See if this does what you are wanting.

I am uploading a new copy of the sheet after I tried to use your solution. Thanks for including the illustrations. I was finally able to follow what you were doing. It did not resolve my issue though. When I select the sheet “Dinner List by Table-Meal” and edit the header to change the center portion to have the same name as the sheet “Dinner List…”, then select the sheet “Dinner Count by Table and Meal” and edit that header to reflect “Dinner Count…”, the sheet “Dinner List…” now says “Dinner Count…”. The header portion does not seem to be saved with the sheet. I have not use excel for many, many years. I have been using Open Office for a long time. This might be the first time I didn’t create a different spreadsheet for every report. If there is something else I can do to resolve this, I would be interested.

Thanks for the clarification. I have never used that portion of the program. I had always gone through print preview from the main task bar.
2022 MEMBER GUEST PLAYER MealsTestTitles.ods (35.5 KB)

At this very moment, remove your header text, look at the “Custom Header” list below, find the “Sheet Name” button (3rd from the left) and click it.

1 Like

@Villeroy take a look, please, at your solution example. In 7.2.2.2 on Mint 20 it doesn’t look like the ‘Header on’ checkbox option is being persisted on a file load cycle. Everything works if I go back and Modify… each page style and turn ‘Header on’ back on, but then if I close/load cycle I have to do it again…your “Untitled 2…”, etc., text is still there in the header, but the ‘Header on’ checkbox loads as unchecked.

Should I be trying to use this solution or wait until there is another reply?

2 Likes

So long as my sheet name is what I want for the Title, this works okay. There is some formatting when I print that I would like to remove, but don’t know how it got there. The header and footer are in boxes that are shaded. This is my inexperience about how some of the features work. If you could tell me how to just print the header centered without the box and shading, I think this will work for me. It is not the solution I had hoped for and wish there was a way to save the header info without using the sheet name.

I really appreciate all the help. Thanks again, Linda