Issue 116819 - Manual Page Break (Row Break) cannot be adjusted
Summary: Manual Page Break (Row Break) cannot be adjusted
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOO330m9
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2011-02-05 09:50 UTC by leoyuen
Modified: 2013-03-18 14:13 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description leoyuen 2011-02-05 09:50:41 UTC
After I installed the released version of 3.3.0, OOO332m20 
(Build:9567), I found I can no longer adjust the page/row break in Calc when the 
Scaling mode is on "Fit print range(s) on number of pages" or "Fit print 
range(s) to width/height". I can only adjust/move the row break in 
"Reduce/enlarge printout" mode. I have used OOo since version 2.4, I can always 
adjust (move) the break in all scaling modes. I have OOo3.2 on another PC; I 
confirmed the page break in Calc is still adjustable in OOO320m12.

To reproduce the problem, open a new spreadsheet in version 3.3.0. 
Simply fill up column A from row 1 to 60; go to View | Page Break Preview. It 
should show 2 pages by default. If the scaling mode has "Reduce/enlarge 
printout" select, the break line is still adjustable. Move the break line up, to 
row 30 for example. Then, go to Format | Page..., change the scaling to "Fit 
print range(s) to width/height" and change the "Height in pages" to "2", OK. The 
page break will change back the default position and it becomes non-adjustable. 
Same issue happen if scaling mode change to "Fit print range(s) on number of 
pages" and "Number of pages" = 2.

I don't think it is normal since the Page Break Preview should allow user to 
change/adjust the page breaks manually no matter what scaling mode is selected. 
As I said, it works fine in version 3.2. It also works in MS Excel.
Comment 1 Regina Henschel 2011-02-06 18:52:37 UTC
*** Issue 116837 has been marked as a duplicate of this issue. ***
Comment 2 Regina Henschel 2011-02-06 18:55:14 UTC
The problem exists as described.
Comment 3 Oliver Brinzing 2011-02-07 08:07:38 UTC
Comment 4 niklas.nebel 2011-02-07 11:19:43 UTC
As long as "fit to width/height" is active in a direction, manual breaks in that
direction are ignored. That's intended, see issue 94698/54993.

Adjusting the breaks in page break preview mode is a different question, so this
is a valid issue, but issue 116837 isn't really a duplicate of this.