https://bugs.freedesktop.org/show_bug.cgi?id=75046

          Priority: medium
            Bug ID: 75046
          Assignee: [email protected]
           Summary: PRINTING Prints off page beyond bottom margin when a
                    row break is in hidden rows
          Severity: normal
    Classification: Unclassified
                OS: Windows (All)
          Reporter: [email protected]
          Hardware: x86 (IA32)
            Status: UNCONFIRMED
           Version: 4.1.4.2 release
         Component: Spreadsheet
           Product: LibreOffice

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to