Bug 44482

Summary: PRINTING annoying behaviour when printing selected cells
Product: LibreOffice Reporter: Paolo Benvenuto <paolobenve>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: christoph.spamforme, heiko.tietze, markus.mohrhard, thomas.lendo, xndrewxry
Priority: medium    
Version: Inherited From OOo   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 103309    

Description Paolo Benvenuto 2012-01-05 00:55:31 UTC
If I select a set of cells and I issue a print command, the print dialog has the "print selected sheets" control selected, while it should has the "print selected cells" control selected.
Comment 1 Markus Mohrhard 2012-01-07 18:19:44 UTC
@Christoph: an opinion about that?
Comment 2 QA Administrators 2014-06-25 17:38:00 UTC Comment hidden (obsolete)
Comment 3 kloud 2014-06-26 08:58:40 UTC
Not a bug, unless it's supposed to work differently. Marked as enhancement.

It's working the same way on XP in 4.3 RC1 as well. Switched platform.
Comment 4 bear 2018-11-29 09:11:45 UTC
Bug not reproducible in version

Version: 6.3.0.0.alpha0+ (x64)
Build ID: 0f25a3c36f27fd51453b9a9115f236b83c143684
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-11-27_20:06:55
Locale: zh-TW (zh_TW); UI-Language: en-US
Calc: threaded
Comment 5 Thomas Lendo 2020-08-14 20:37:36 UTC
I rewarm this old request. It's the same behavior in the new print dialog. Maybe a reasonable answer can give here to close this issue or to hold it open.

There are 2 possibilities:
1. The print dialog ignores the selected cells in the sheet. The preview in the print dialog only shows full sheets.
2. The print dialog follows what the user has selected in the sheet and only this will be shown in the preview of the print dialog and printed. The "more" area will be opened automatically and "Print Selected Cells" is selected in "From which:".

What's the most used way?

Or maybe is it possible to have an extra shortcut to print only selected cells and the normal print dialog won't be changed?
Comment 6 Thomas Lendo 2020-08-14 20:39:01 UTC
*** Bug 135766 has been marked as a duplicate of this bug. ***
Comment 7 Heiko Tietze 2020-09-09 10:03:22 UTC
Under Range and Copies we have From Which where you can select Print Selected Cells. This option should be preselected when a selection has been made.

There is also a Print All Sheet option which can be controlled by Tools > Options > Calc > Print, which is too much in my opinion. The dropdown is sufficient. Same applies to the idea of separate print commands or an option (not yet commented) for "Print Selection" that drives the dropdown. Please don't do this and keep it simple.