Copy Cell Ranges with Page Break to another Sheet

[Onnie]

Good morning!

I have a calc sheet with entries for several persons. I would like to copy the name of the columns and the data for a person to a new sheet, insert a page break and do the same for the others. That way I can print the data for each person on a separate sheet.

I’ve attached an example file that includes the source data and the desired new sheet with the copied data: Example.ods (14.8 KB)

I was hoping that there is some formula to achieve this but so far I could not find ist. I was trying to do this with cell references but this does not work because the names of the person might change and also the number of lines for each person.

I’m using this version of LibreOffice:
Version: 24.2.7.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 2; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.4
Calc: threaded

Thank you for your suggestions.
Cheers
Onnie

[PKG]

What is preventing the page break?

You can set the column header to be repeated on every page in the
menu Format → Print Ranges → Edit.

[Onnie]

Hello,

The suggested solution from PKG looks very promising. I’ve tried it with the example file and it worked. At least in the print preview.

I’m impressed to receive such a good and helpful reply!
Thank you very much!

Cheers
Onnie

[fpy]

@Onnie

entries

@Onnie

copy

@Onnie

hoping

indeed it does not really exists. for reasons.


sort of FAQ,
somehow XY problem - Wikipedia,
also quickly leading to Anti-pattern - Wikipedia
and more or less lengthy discussions and docs :
→ Calc Guide 25.2 - Chapter 15, Calc as a Database
→ Is LibreOffice Base the right tool for my situation?
→ Can you use Calc for viewing and editing Base data?

a chat with some AI may help you to digest underlying ideas and concepts.