Printing a Spreadsheet So It Reads Like a Report
How to set a print area, repeat header rows, and control page breaks so a Piskes Sheets export reads cleanly on paper or as a PDF, not like a browser screenshot.
A spreadsheet built for on-screen editing and a spreadsheet built for handing someone a printed page are different documents, even when the data is identical. On screen, you scroll. On paper, a table that runs past the page edge just gets cut off, and a long list that loses its header row after page one becomes unreadable by page three. Piskes Sheets has dedicated print handling so the export you generate for a meeting or a PDF attachment doesn't just crop your screen at an arbitrary point.
What to set before you print
Print area. If your sheet has scratch calculations or notes off to the side that shouldn't appear in the output, define a print area covering only the range you actually want printed — the rest is excluded regardless of how far your data extends.
Repeat header rows. For anything longer than one page, set the header row to repeat on every printed page. Without this, only page one carries column labels, and a reader on page three of a long table has no way to tell what they're looking at.
Page breaks. Where the automatic page-break placement splits a table awkwardly — in the middle of a section that should stay together — you can set a manual page break to force the split somewhere cleaner.
Where this lives
Piskes Sheets treats print output as its own concern rather than an afterthought bolted onto the screen view — the logic lives in a dedicated module (frontend/apps/drive/src/lib/office/sheet-print.ts, with supporting code under lib/print/), separate from the general spreadsheet editing code. That's the same reason the print area, repeat-rows, and page-break controls exist as distinct settings in the first place, rather than Drive just rendering whatever's on your screen to a PDF and calling it done.
A quick checklist before you export
Before generating the final PDF or sending to a physical printer: confirm your print area matches what you actually want on the page, check that header rows are set to repeat if the sheet runs longer than one page, and preview the page breaks to catch any table split in an awkward spot. A minute spent here is the difference between handing someone a report and handing someone a spreadsheet that happens to be on paper.