A spreadsheet and a page want different things
A spreadsheet has no pages. It is an unbounded grid, and any conversion to PDF has to decide where to cut it — which is the entire difficulty. Rows flow onto as many pages as they need here, with the header row repeated at the top of each so a table spanning twenty pages stays readable rather than becoming a wall of unlabelled numbers.
Columns are the harder direction, because a page cannot grow sideways. As many columns as stay legible are kept, and the PDF states plainly on the page how many were left off, rather than shrinking forty columns into an unreadable smear or dropping them silently.
Values, not formulas
What lands in the PDF is the last calculated value of each cell, which is what the workbook stores alongside the formula that produced it. Formatting, colours, merged cells, conditional rules and charts are not carried over — the output is the data, set as a plain table.
If you need the numbers rather than a document, JSON to CSV and PDF to Text cover the data-wrangling direction, and Merge PDF will combine the result with a cover page or a report.