Bug 156524 - Make it easier to export spreadsheets to pdf
Summary: Make it easier to export spreadsheets to pdf
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Keywords: needsUXEval
Depends on:
Blocks: PDF-Export-Options-Dialog
  Show dependency treegraph
Reported: 2023-07-29 21:55 UTC by MarjaE
Modified: 2023-09-27 04:56 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description MarjaE 2023-07-29 21:55:16 UTC
Many of the steps to export spreadsheets are hidden away under Format > Pages and/or Format > Print Ranges, and not available in the Export dialogue. Some steps will throw errors. Some options imply they address these issues, but actually do not.

Steps to Reproduce:
If I try to export a spreadsheet to pdf, I will need:

1. Column and row headers on each page.

2. Grid lines.

3. Sometimes landscape view.

The default settings lack these, and the export dialogue lacks options to set these up. Going from easiest to hardest...

3. Open Format > Page Style > Page and select "Landscape." The problem is that this isn't in the export dialogue, and you have to know where to look.

2. Open Format > Page Style > Sheet and check "Grid." The problem is that this isn't in the export dialogue, and you have to know where to look.

1. There are options under Format > Page Style > Header and Format > Page Style > Sheet which imply they will print the headers, but they will not be enough. Instead users are supposed to use Format > Print Ranges > Edit. And figure out what causes "invalid sheet reference" and avoid it. A lot of documentation suggests users select the rows or columns, but if we do select a column, that will narrow the print range instead. If we try to copy the info to the appropriate section, we get the "invalid sheet reference" and it turns out users need to A. Select All before Format > Print Ranges > Edit, figure out the appropriate syntax for the rows and columns, and type that in.

Actual Results:
Try to export to pdf using the export dialogue.

Expected Results:
All the  necessary options should be in the export dialogue. Or if not, at least there shouldn't be misleading options in the Format > Pages ? Headers and > Sheet dialogues. And there should be an easier way to select rows and columns to repeat.

Reproducible: Always

User Profile Reset: No

Additional Info:
Version: (X86_64) / LibreOffice Community
Build ID: c21113d003cd3efa8c53188764377a8272d9d6de
CPU threads: 4; OS: Mac OS X 10.14.6; UI render: default; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 1 Heiko Tietze 2023-08-15 14:17:19 UTC
Generally I think (PDF) export works well and you can do everything with a maximum on flexibility. 

Can you break the request down into actionable issues ideally with a use case?
Comment 2 Heiko Tietze 2023-09-27 04:56:14 UTC
Feel free to reopen.