Description: 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: 7.5.0.3 (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
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?
Feel free to reopen.