PDF guides
ODS to PDF: What Spreadsheet Data Is Preserved
It’s tempting to assume a spreadsheet converter preserves everything a spreadsheet can contain. It doesn’t — here’s exactly what Looty Tools’ ODS to PDF converter actually reads from an .ods file and what it doesn’t, verified directly against the underlying parser rather than assumed.
Ready to try the tool this guide describes?
What survives
Text, numbers, dates, percentages, and currency values — each using the cell’s own displayed formatting from the source file. Blank cells render as blank. Merged cells are preserved as merged in the PDF grid. Multiple worksheets convert with their names shown as page headers. Column-width hints from the file are used as a starting point for sizing when present.
Formulas: cached results, not recalculation
The PDF shows each formula cell’s cached, already-displayed result from the file — the value LibreOffice or Google Sheets last calculated and saved. Formulas are not recalculated during conversion; there’s no spreadsheet engine running in the browser to do that.
What does not survive, and why
Cell fill/background colors, bold/italic emphasis, custom fonts, cell alignment, and border styles are not carried over — the converter’s underlying spreadsheet parser reads cell values and merged-cell structure from ODS files, but does not expose the file’s visual cell-styling properties for this format. Every cell renders in one consistent typeface and a uniform grid instead.
Hidden worksheets are not excluded
Unlike Excel to PDF (which does exclude hidden worksheets for .xlsx files), worksheet visibility metadata isn’t available to this converter for the ODS format — every worksheet in the file is treated as visible and selectable, hidden or not.
Long cell text is truncated, not wrapped
A value too wide for its column is shortened with an ellipsis rather than wrapped onto a second line within the cell, keeping row heights predictable across a page.
ODS to PDF Formatting Support FAQ
- Why don’t my cell background colors show up in the PDF?
- Cell fill/background color is not read from ODS files by this converter’s spreadsheet parser, so no cell in the output PDF is shaded — this applies to every ODS conversion, not just some files.
- Are hidden worksheets excluded automatically?
- No, not for ODS files. Every worksheet is treated as visible. Remove or skip a sheet manually in the worksheet selection step if you don’t want it included.
- Will formulas update if I change the source spreadsheet later?
- No — each conversion is a snapshot of the cached values at the time of conversion. Re-convert the file after updating it to get fresh values.
- Are number formats like currency and percentages preserved?
- Yes — the PDF shows each cell’s already-formatted displayed text (e.g. "$12.50" or "25%"), exactly as the source file stored it.
- Are row heights and column widths preserved exactly?
- Column-width hints from the file are used as a starting point when present, but sizing is ultimately content-based rather than an exact replica of the source spreadsheet’s layout.
Related guides
- How to Convert ODS to PDFConvert an OpenDocument Spreadsheet (.ods) file into a paginated PDF table in your browser. Covers the conversion steps and how worksheet selection and pagination work.
- ODS vs. XLSX vs. PDFHow OpenDocument Spreadsheet compares to Excel (.xlsx) and PDF for compatibility, editability, and formula support, and when to choose each one.