Ask Your Question
1

Repeat row header on every page (print)

asked 2015-12-02 16:15:18 +0200

Yanick gravatar image

For a fixed number of rows in a spreadsheet, how do I make these rows repeating and be the header on every printed pages?

I have selected the first rows as header, then Window -> Freeze. Now, I'd like to have them printed as header on every page. Is it possible?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
2

answered 2015-12-02 19:25:07 +0200

pierre-yves samyn gravatar image

HI

  • Go to FormatPrint RangesEdit.
  • Select the Print Range (data to print)
  • Click on the box to the right of Rows to repeat or Columns to repeat.
  • Select the row(s)/column(s) to be repeated.
  • Click OK.

When you print, the selected area will now be printed on each page. You will not see any visible change in your spreadsheet. Use FilePrint Preview to see what the pages will look like before printing.

Regards

edit flag offensive delete link more

Comments

This worked for me.

Thiagarajan gravatar imageThiagarajan ( 2017-07-29 12:16:10 +0200 )edit

how to achieve this by command line mode ? my environment only allow me to start libreoffice by "libreoffice --headless"

getright gravatar imagegetright ( 2018-09-20 08:14:49 +0200 )edit

How to save this setting(repeat heading) and apply this for all tables forever? because I found next time I open such tables, I need set them again.

getright gravatar imagegetright ( 2018-09-20 10:48:53 +0200 )edit

Hi @getright - it is a sheet parameter that must be defined via a graphical interface. It can only be set by default in a template, possibly defined as the default template for newly created documents. Template management has already been discussed here and is documented in the documentation.

pierre-yves samyn gravatar imagepierre-yves samyn ( 2018-09-20 11:57:08 +0200 )edit

@pierre-yves samyn , Hello, is there any template which is close to Microsoft Word template? or can we just import a template file from MS Word? In addition, I try to edit the default template, It seems in template there is no table inside, so we cannot update the table style , I also try to build a new table in the template, and I found by default the "repeat heading" is checked,

getright gravatar imagegetright ( 2018-10-03 11:49:13 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-12-02 16:15:18 +0200

Seen: 12,955 times

Last updated: Dec 02 '15