Bug 44482 - PRINTING annoying behaviour when printing selected cells
Summary: PRINTING annoying behaviour when printing selected cells
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
: 135766 (view as bug list)
Depends on:
Blocks: Print-Dialog
  Show dependency treegraph
Reported: 2012-01-05 00:55 UTC by Paolo Benvenuto
Modified: 2020-09-09 10:03 UTC (History)
5 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 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: (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.