On this page
Prepare calculated values and print settings
Recalculate the workbook, save current formula results and confirm that filters, hidden rows and print ranges reflect the intended report. PDF captures the rendered state, not the spreadsheet logic behind it.
Check charts, conditional formatting, merged cells and font availability. These features depend on the office renderer and deserve a representative preview.
Choose the correct sheet-to-page behavior
Preserve print layout respects the workbook’s existing page breaks and print areas. One page per sheet scales each sheet into a single PDF page and is useful for compact dashboards, but large data grids may become unreadable.
| Mode | Best for | Risk |
|---|---|---|
| Preserve print layout | Prepared reports and print ranges | May create several pages per sheet |
| One page per sheet | Dashboards and summary sheets | Fine text can become too small |
Review the fixed report
Preview the output and confirm sheet order, page count, chart labels, repeated headings, totals and the last used columns. Retain the ODS as the editable source.
- Check formula values and dates.
- Inspect wide tables at normal zoom.
- Confirm charts and legends.
- Review the first and last PDF pages.
Put the workflow into practice
Arrange source documents, select the pages you need, and create one PDF locally in your browser. Review the result before choosing any optional next step.
Try ODS to PDFFrequently asked questions
Clear answers before you merge
Are formulas preserved?
Their saved values are rendered, but formulas do not remain editable in PDF.
Can one sheet become one page?
Yes, using One page per sheet; check readability on large sheets.
Does the source workbook change?
No. Conversion creates a separate PDF.
