User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:49.0) Gecko/20100101 Firefox/49.0 Build Identifier: 1:5.2.1~rc2-0ubuntu1~xenial0 The main print dialog allows to print only selected cells. The print preview, however, doesn't allow to preview the printing of selected cells only. Furthermore, scaling is only possible in the print preview dialog, therefore it is not possible to print spreadsheets with scaling and selected cells only. The calc printing story is a major showstopper for LibreOffice adoption in my experience and resolving *this* issue here would mitigate it significantly (even if Excel would still be more comfortable here). Note that there's the related issue #102068, which is *only* about the unintended reset of cell selection after use of the print preview. *This* bug here is about the inability to print only selected cells in a scaled way. Alternatively, in order to achieve the same goal, the scaling feature could also be added to the main print dialog instead. Reproducible: Always Reset User Profile?No
Created attachment 127710 [details] Screenshot Maybe I'm wrong. Scale for print is a page style option on the sheet tab. Attached screenshot with 500% scale, with the print window resized. Preview scale -bottom right- it's only for preview visualization not for print.
Nicolas: waiting for your reaction to Miguel's comment. Set to NEEDINFO. Change back to UNCONFIRMED, if you are not satisfied. Change to RESOLVED WORKSFORME, if you are happy.
(@Buovjaga - thanks for pinging me) > Scale for print is a page style option on the sheet tab. Indeed "Format > Page > Sheet > Scaling mode" is another and useful alternative option to allow scaled printing, which I wasn't aware of. > Preview scale -bottom right- it's only for preview visualization not for print. I didn't mean the zoom level slider in the normal UI on the bottom right, but the "Scaling factor" toolbar element in "File > Print Preview". As this bug is about that indeed broken "print preview", I'll keep this bug open, even if my original statement that "it is not possible to print spreadsheets with scaling and selected cells only" is not true, as scaling is not only possible in "print preview", but also in said "format page" dialog. Also, even if things are somehow possible, the discoveribility is pretty hard, as I'd expect printing features in the print dialog (as Excel does IIRC).
Sorry, as you note there is nothing broken with the Print Preview's scaling a selected range of cells. And the Page Style dialog is provided for launch from the "Format Page" button of the Print preview--making the Sheet tab available to choose to Reduce/Enlarge or a Fit-to option. So what is actually needed is an addition to to Print dialog -> Page Layout tab. Addition of either the "Scale" controls from the Sheet tab of the Page Style dialog--i.e. a drop list and spinner. Or reuse the Print preview's "Scaling Factor" slide bar but add the drop list of scaling modes from the Sheet tab (the "Fit print" controls are equally useful). An enhancement for that, otherwise closing as NAB
> Sorry, as you note there is nothing broken with the Print > Preview's scaling a selected range of cells. The "File > Print Preview" feature does not support the concept of showing only selected cells, which the main Print actually supports. So this isn't really a great preview and should be considered broken. > Addition of either the "Scale" controls from the Sheet tab > of the Page Style dialog--i.e. a drop list and spinner. Or > reuse the Print preview's "Scaling Factor" slide bar but add > the drop list of scaling modes from the Sheet tab (the "Fit > print" controls are equally useful). Good possible suggestions. > An enhancement for that, otherwise closing as NAB I don't understand the sentance "An enhancement for that". Am I supposed to do turn this into a feature request somehow? Or can I turn this into a "UX bug" for this, as in "even if it's somehow possible, this is not what users expect"?
Scaling is not a bug. The full frame screen Print Preview not offering a "selected cells" mode is not a bug, it would be an enhancement. Nor does it seem an especially necessary enhancement as the full print dialog handles choosing "All sheets||Selected sheets||Selected cell" well, and provides a multipage print preview in the dialog. It responds to "Range and Copies" controls as well as any formatting applied to the sheet/cells on the page (scaling, or fit-to). So, the interesting enhancement would be to add scalling/fit-to controls to the full print dialog.
This was a valid enhancement request and I set New.
Changing misleading summary from "Print preview should show only selected cells, if there is a selection" to "Add scaling/fit-to controls to the print dialog" as proposed in comment 6.