Issue 28433 - keeping merged ranges together when printing
Summary: keeping merged ranges together when printing
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1.2
Hardware: All All
: P3 Trivial with 5 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-04-27 22:24 UTC by avagula
Modified: 2013-02-07 22:20 UTC (History)
2 users (show)

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


Attachments
Example OOo spreadsheet file for illustrating merged cells printing issue (14.73 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-01-04 13:53 UTC, soro714
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description avagula 2004-04-27 22:24:31 UTC
Were good to have a possibility to set an option in page setup dialog: 
1) to keep merged cell ranges together when printing 
or 
2) to repeat the content in both pages if page break crosses merged area.
Comment 1 frank 2004-04-28 08:49:35 UTC
Hi,

I think this is possible since the first version of OOo. Go to format page-Sheet
and select fit pintout to x Page(s).

Bettina, could you evaluate the users suggestions, please ?

Frank
Comment 2 avagula 2005-07-15 12:02:31 UTC
I had in mind this:
I have spreadsheet, where first 3 cells are vericalli merged, the rest not:
------------------------
          |first
something |second
          |third
------------------------
When this happens in the end of page, calc can print out so:
------------------------
          |first

(page break)

something |second
          |third
------------------------

I want, that user could select, to keep range together, or repeat the content in
first column like this:
------------------------
something |first

(page break)

something |second
          |third
------------------------

I hope you can understand
Comment 3 pelladigabor 2008-10-02 20:07:58 UTC
Still applies for 2.4.1. Printing should not split merged cells between pages if
possible. It should try to keep merged cells together, even if it means one more
page in total.
Comment 4 bettina.haberer 2010-05-21 15:15:45 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements". 
Comment 5 soro714 2012-01-04 13:53:47 UTC
Created attachment 77101 [details]
Example OOo spreadsheet file for illustrating merged cells printing issue

Hi,

Issue still applies to OOo 3.3.0...

A small OOo spreadsheet testcase file is attached: just click on "Print preview" to see that some merged cells in column A appear split across 2 pages and the letters in the cell are also split in half (you may change the top and bottom margin height in "Page setup" to see that depending on their values you can get more or less merged cells split).

A "Protect merged cells" feature is missing to avoid this ugly print layout.
Comment 6 Terry Yang 2012-09-21 08:55:04 UTC
Confirm at AOO 3.5 Trunk r1387482, change to confirmed status
Comment 7 Terry Yang 2012-09-21 08:56:22 UTC
Confirm at AOO 3.5 Trunk r1387482, change to confirmed status