Description:
Summary:
--------------------
Assuming that "Supress output of empty pages" is ON from calc options.

If all cells on the sheet have direct formatting cleared and "Default" style applied, if that style has a border defined AND page border is also applied from page style, it causes black lines bleeding over the page border when printing/exporting, even with print ranges defined.

It seems there's an issue with how calc handles border defined in the default style.
It shouldn't try to render ANY empty cells, even if they have a border or other styles applied to them.

If you disable border in Default style, and define your documents cell styles with any other style, issue goes away. So there's a workaround, but it's very unoptimal because that means you cannot use the Default style unless you disable the border.

I've created two files that demonstrate the issue. First document displays the issue (use print preview or export as PDF and see what happens when you select between page border on/off and "default" cell style having border on/off)

Second file is a PDF that was exported from said document by me, proving that the issue isn't just visual but affects printing and exporting as well.

I will download a bunch of older portable versions in the following days and do some spot checking if I can see where the issue came up in or if it's a regression.

I'll update the bug report after that.

Steps to Reproduce:
1.
Enable "Supress output of empty pages" from calc options.

Create a new calc sheet.
Define/edit Default page style: Size A4, add full border,
Set scaling mode to "Reduce/enlarge printout".

2.
Edit the "Default" cell style and enable full border on that style.

3.
Select the whole sheet, and clear direct formatting. Then double click the "default" style from the list to apply it to every cell of the sheet.

4.
Select (for example) first 3 columns and 100 rows, then fill them with data.
Make sure the contents doesn't go over cell borders.

5.
Define following Print Range:
Print Range: - entire sheet -
rows to repeat: - user defined - with value of $1
columns to repeat: - user defined - with value of $A:$C

6.
Go to View -> page break. And confirm that print range is properly defined and you have enough data that it can't fit on single sheet and you have multiple pages when you scroll downwards

7.
Go to "print preview" and confirm that there are black lines on left and bottom of the pages that extend outside of the page border and print range.

Actual Results:
Every printed page has black line bleeding over the print range and page border on the top right and bottom right of the page that shouldn't be there.

Expected Results:
Only borders and other cell contents of the current page and print range are rendered/printed and if the cell is outside of print range of the current page, it's contents nor borders won't be displayed even if it's adjacent to the cells in the print range or page.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
If you disable either Page Border OR Default Cell Style border and check the preview again. Black lines should be gone.

So the issue is with these two features having issue with each other and the printing rendering is misbehaving.