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..