Bug 75046 - PRINTING Prints off page beyond bottom margin when a row break is in hidden rows
Summary: PRINTING Prints off page beyond bottom margin when a row break is in hidden rows
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.1.4.2 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-02-16 08:33 UTC by Chris Severance
Modified: 2014-02-20 12:58 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments

Description Chris Severance 2014-02-16 08:33:52 UTC
LO Calc 4.1.4.2
May be related to Bug 64703

The problem occurs when a ROW BREAK is inside hidden rows. Whether the rows are hidden manually or by a filter doesn't matter.

Steps to reproduce.
New Spreadsheet
Fill A1:A100 with any printable value, enough to make 2 printable pages.
Select Row 10, Insert, Page Break, Row Break
Hit print preview to see expected result: Multi page print with pages correctly formatted between bottom and top margin. The first page is short.
Hide rows 2-12. The ROW BREAK is now hidden.
Hit print preview

Unexpected result: One page print which goes past the bottom margin off the page.

Expected result: Multi page print with pages correctly formatted between top and bottom margin.

Note: Print Preview, Print Dialog Preview, Print, and Export to PDF are affected.

Note: When the bug is activated the print preview screen takes noticeably longer to produce a complete preview. This slow painting can be seen on an i3 based Celeron G530 when the page is set to Landscape and a many column spreadsheet fills the entire preview with text.

****
Another bug:

Show all rows. Hide rows 2-9. Now the row break is at the top of the visible rows.
Format, Print Ranges, Edit, User Defined, Rows to Repeat: $1

Unexpected result: The first page prints a single line of text consisting of the header row with a blank page underneath.

Expected result: The first page should have printed text below the header row. The header row should only print when there is printable data following it.

Note: Microsoft Excel XP also does not handle this correctly so maybe it's best to just leave it.
Comment 1 Dominique Boutry 2014-02-20 12:58:13 UTC
First bug report reproduced with Lib0 4.2.0.4 on Win7.

I propose to limit the current report 75046 to this first bug. Please fill in a second report for your "another bug".


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.