https://bugs.documentfoundation.org/show_bug.cgi?id=156524
Bug ID: 156524
Summary: Make it easier to export spreadsheets to pdf
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
