Bug 153638 - Add "Ignore Print Area" print option for Calc
Summary: Add "Ignore Print Area" print option for Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Printing and PDF export (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Print-Range
  Show dependency treegraph
Reported: 2023-02-15 14:32 UTC by Gabor Kelemen (allotropia)
Modified: 2023-11-17 22:44 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Screenshot of the feature in Excel and its lack in Calc (185.84 KB, image/png)
2023-02-15 14:32 UTC, Gabor Kelemen (allotropia)

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2023-02-15 14:32:41 UTC
Created attachment 185382 [details]
Screenshot of the feature in Excel and its lack in Calc

This came up while testing bug 149786

Excel apparently has a print option called "Ignore Print Area" in its Print dialog.

Calc does not have a similar option.

1. Open attachment 181030 [details]
2. Notice it has a print area set, this is imported correctly.
3. File -> Print -> Notice the "This should not be printed..." texts are not visible in the preview. This is the effect of the defined print area.
-> There is no way to override this setting before printing, if the user wishes so, unlike in Excel.

Version: (X86_64) / LibreOffice Community
Build ID: 14a36ad49518bcb5b606b0f1640e3ca56b636e89
CPU threads: 14; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: threaded
Comment 1 BogdanB 2023-11-17 22:44:19 UTC
Yes, maybe someone needs something like this.
Would be a nice enhancement.