LibreOffice is a suite of open source office for excellence, created by the project OpenOffice when it was bought (along with other products SUN Microsystems) the Oracle. “Calc” is one of the programs included in the suite LibreOffice, it is a spreadsheet. Today's article tries to make life easier for those who have the need to always have certain cells as a page header.
The header row included in Calc, reached by following the menu “Format” – “Page” – “Header row“- “Edit“, is basic and is explained in the screenshot taken from the program, below.
The few customization options allow you to enter:
- different formatting of text,
- the name of the file,
- the name of the sheet,
- the number of printed page,
- the number of total pages,
- the data,
This menu is not thought to show the specific cells as a header. I'm thinking very long lists, where it is necessary a reminder at the top each page (type “Name“, “Description“, “Qty“, “Category“, etc..).
To define a row (or more lines) it prints at the beginning of each page must navigate a menu “neighboring“. It is “Format” – “Print Area” – “Edit“.
I have already shown in the image defined as an interval “Rows to repeat“, these are the lines “the 1 a 3“.
The result is immediately visible in print preview where I proceeded to obscure data.
Each page will have the same header, in this way, even with very long lists the user does not run the risk of being wrong column.