Convert ODS to PDF

ODS is the OpenDocument spreadsheet — the native format of LibreOffice Calc, and the one public bodies increasingly require because it is a published standard rather than a vendor’s internal structure. It is a good format and it has one recurring practical problem: send it to somebody on Excel and there is a fair chance of a reply asking what to do with it.

PDF solves that in the direction that matters. Anyone can open it, on anything, and see exactly what you saw. For a quotation, an expense claim, a set of accounts or a price list, that is the whole requirement.

Every other spreadsheet conversion on this site involves an engine interpreting somebody else’s format. This one does not: ODS is LibreOffice’s own, and the engine doing the conversion is LibreOffice. It reads the file the way the program that wrote it reads it.

That is why this is the most faithful spreadsheet-to-PDF conversion available here. Cell styles, number formats, conditional formatting, merged cells, borders and column widths are not being reconstructed from a foreign description — they are simply being printed.

A chart in a Calc file is a drawing described in shapes, not a picture, and PDF describes shapes too. So charts are written into the PDF as vectors: zoom to four hundred per cent and the axis lines are still one pixel wide and the labels are still crisp.

This is worth knowing if the spreadsheet is going to a printer or into a report that will be read on a large screen. A conversion that rasterised the charts would look identical on a laptop and visibly poor at full size.

A spreadsheet extends as far as you keep typing; a PDF is made of fixed sheets. The break between them is decided by the page style stored in the file — print ranges, scaling, orientation, repeated header rows — and the conversion follows it rather than inventing its own.

If a table is being sliced in an awkward place, the fix is in Calc before you convert: Format, Page Style, then landscape and "fit print range to width". Set the print range to cover exactly the cells that matter, and set the header row to repeat so page four still has column titles. The PDF will match the print preview because they are the same operation.

The PDF holds the results, not the calculations. Every cell shows what it contained at the moment of conversion, and nothing recalculates afterwards — no external links, no volatile dates, no dependency on the recipient’s locale or decimal separator.

For a document being sent or filed that is the point rather than a limitation: the figures are fixed and identical for everybody who opens it. When the recipient genuinely needs to work with the numbers, send them a spreadsheet as well.

A great deal of the demand for this conversion comes from people who cannot install anything: a locked-down work laptop, a Chromebook, a phone, a borrowed machine. The conversion here needs none of it — the office engine runs on the server, and the browser only has to hand over the file and take the result back.

The file travels over an encrypted connection, is converted in an isolated environment with no route out to the internet, and the working files are deleted as soon as the job finishes. The free limit is 25 megabytes, which a spreadsheet reaches only if it contains a lot of embedded images.

PDF is for a spreadsheet that is finished. If the recipient has to sort it, filter it, add a column or check a formula, a PDF forces them to retype everything, and they will.

Convert to XLSX for those cases. Current Excel opens it natively and Calc round-trips it well enough for ordinary work. Keep the ODS as your own master copy — it is the version that will still be readable in twenty years, which is why the format exists.

Drop up to a hundred ODS files at a time. Each is converted in turn, keeps its name with the extension swapped, and the finished PDFs come back together as a single ZIP.

That covers the recurring monthly job — a folder of departmental sheets, a set of invoices, a term’s worth of reports — without opening each one and choosing "export as PDF" twenty times. This pair runs on our server, so each sheet also counts against the free plan’s hundred server conversions a day; a monthly folder is nowhere near that, a full archive in one sitting would be.