Issue 117952 - Impossible to redefine PrintArea
Summary: Impossible to redefine PrintArea
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOo 3.3
Hardware: All All
: P3 Normal with 2 votes (vote)
Target Milestone: ---
Assignee: niklas.nebel
QA Contact: issues@sc
Keywords: regression
Depends on:
Reported: 2011-04-28 11:25 UTC by scap
Modified: 2013-08-07 15:13 UTC (History)
6 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---
mdxonefour: 3.4_release_blocker+

Bug with PrintArea (9.29 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-04-28 11:25 UTC, scap
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description scap 2011-04-28 11:25:04 UTC
Created attachment 76458 [details]
Bug with PrintArea

It is impossible to redefine the print range after a first definition.

The bug can be generated by a macro or simply by the user's manipulation.

Method 1:

- Open a new Calc document
- Write "aaa" in A1 and "ddd" in D4
- Open the page preview then close it => page breaks has been automatically generated (check by un-zooming, e.g: 50%)
- Select the range A1:B6
- Menu Format > Print ranges > Define. Page breaks are only visible for the previously defined range.
- Then, Format > Print Ranges > Remove. NOTHING HAS HAPPENED!
- Open page preview => only aaa appears on page 1, ddd appears on page 2. BUT BOTH SHOULD BE ON THE SAME PAGE!
- Save the document.
- Then File > Reload
- Open Page preview, it is ok now...

Method 2:

You can also try with the attached file (run the macro step by step)
Just notice that on the following lines, if you write 1000 instead of 900 it will not redefine the print range. It will work only with value under 900(?!?)

myRange = mySheet.GetCellRangeByName("A1:G900")	' Select a range 
addrRange(0) = myRange.RangeAddress		' -
mySheet.PrintAreas = addrRange()			' Define printing area

There were no problem on OOo 3.2.1, it is a regression..
Comment 1 Oliver Brinzing 2011-04-29 17:17:45 UTC
Comment 2 niklas.nebel 2011-05-03 11:26:22 UTC
Fixed in CWS calc69.
Comment 3 Oliver-Rainer Wittmann 2012-06-13 12:27:00 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 4 Shan Zhu 2012-08-31 06:43:35 UTC
Verified on AOO350m1build9610. It works.
Close it.