Bug 128102 - calc page break does not work
Summary: calc page break does not work
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.0.0.alpha1+
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-10-12 04:24 UTC by Elmar
Modified: 2019-12-24 13:41 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
spreadsheet sample (186.93 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-10-12 04:26 UTC, Elmar 		Details
screenprint shows dotted line (67.13 KB, image/png)
2019-10-12 04:30 UTC, Elmar 		Details
screenprin shows break not honoured (132.13 KB, image/png)
2019-10-12 04:32 UTC, Elmar 		Details
example (8.57 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-10-12 07:55 UTC, Oliver Brinzing 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Elmar 2019-10-12 04:24:03 UTC 
Description:
Menu/sheet/page break/row break has no effect on printing

I have used this in older versions (v5?) but does not work  in v6.4 and v6.0

Steps to Reproduce:
1. create spreadsheet
2.insert page break
3.do print view
 

Actual Results:
shows dotted line where break should be

Expected Results:
on printing should advance to new paper page, or when creating pdf


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes

Version: 6.4.0.0.alpha0+
Build ID: 66e45a1ae861d50edf65fed9e39c9c9d5b15e0ac
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-09-28_15:31:38
Locale: en-GB (en_ZA.UTF-8); UI-Language: en-GB
Calc: threaded
Comment 1 Elmar 2019-10-12 04:26:43 UTC 
Created attachment 154947 [details]
spreadsheet sample
Comment 2 Elmar 2019-10-12 04:30:28 UTC 
Created attachment 154948 [details]
screenprint shows dotted line
Comment 3 Elmar 2019-10-12 04:32:29 UTC 
Created attachment 154949 [details]
screenprin shows break not honoured
Comment 4 Oliver Brinzing 2019-10-12 07:55:39 UTC 
Created attachment 154950 [details]
example

no repro with: 

Version: 6.4.0.0.alpha0+ (x64)
Build ID: 59cbf34740bead037b0aed1ece24870324365b7a
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: threaded

using my attached example file, will print 3 pages 

Can you please check settings in 

Format/Sheet/Page.../[Sheet]
->Scale
Comment 5 Robert Großkopf 2019-10-12 12:33:13 UTC 
It's a special problem of the attached document from Elmar. If you set 
Format/Page/Sheet/Scale to Reduce/enlarge printout 100%
the page break will work.
If it will be set to 70% the width of the page will show the whole content in A4-landscape and the page break.

Also "Fit print range(s) to width/height" and setting the width to 1 page will give the expected result. The height shouldn't be selected here.

All other formatting of Scale won't work, because it will set the page height also.
Comment 6 m_a_riosv 2019-10-13 21:35:23 UTC 
Seems to me it's a problem with Menu/Tools/Options/LibreOffice Calc/Pring - Always apply manual break.