How to print without page breaks 1

[jokeefe]

I have a user that has a spreadsheet filled with page breaks. She wants to print it out, without the page breaks. In other words, she wants Lotus to ignore the page breaks she has entered. Don't ask why.

Has anyone heard of a way to do this.

Thanks,
jo'k.

 

[DaleWatson123321]

Hi jo'k,

I expect the easiest method would be to:

1) Insert a new worksheet

2) Copy the entire (existing) worksheet. To do this, click the sheet letter (above the "1" for row 1, and to the left of "A" for column A). Then right-click, and choose "Copy".

3) Click on the sheet tab for the new sheet.

4) Click on the sheet letter (above the "1" for row 1, and to the left of "A" for column A). Then right-click and choose "Paste".

You'll notice that all the data is copied, but NOT the Page-Breaks.

Being a new sheet, you might have to set the Page Settings, Margins, etc to match the previous sheet.

I hope this helps. Please advise as to how you make out.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[drdebit]

When I experimented and grouped the sheets to pull the formatting, the page breaks came too. So if it comes down to a choice between which is the less work-manually reformatting everything or manually removing the page breaks and manually removing the page breaks would be less, for a one time print, you could make a back up copy of the sheet remove the page breaks and print from that.

Dale,
I'm still thinking about the version 5 comments and what I want to say in the other post. Thinking about your comments there, about this problem, and macros (which I was never very skilled at) a question. If every page had a range name, would it be possible to write a macro to add and remove page breaks between range names?

Dave H.

 

[DaleWatson123321]

Dave,

Regarding your question...

"If every page had a range name, would it be possible to write a macro to add and remove page breaks between range names?"...

Here's a routine that will remove page breaks "within" 3 separate ranges on 3 separate worksheets.

This requires that the range names be assigned to the 3 ranges - which I've named: range1, range2, range3.

At the bottom of each of the three ranges, it's required that a range name be assigned to the bottom row. I've used the names: range1_br, range2_br, range3_br.

Preferably on a separate sheet (that you have for macros), include these routines in column B. In column A, opposite the first line, enter the label for the letter you'll be using to activate the macro. I've used "\Q". Then of course create the range name "\Q" for the first row of the routine - column B.

{INDICATE Deleting Page Breaks}{WINDOWSOFF}{PANELOFF}
{LET rownum,@CELL("row",range1_br)}{GOTO}range1~{delete_breaks}{HOME}
{LET rownum,@CELL("row",range2_br)}{GOTO}range2~{delete_breaks}{HOME}
{LET rownum,@CELL("row",range3_br)}{GOTO}range3~{delete_breaks}{HOME}
{FC}
{WINDOWSON}{PANELON}{INDICATE}

Leave at least one blank row, and then enter the next subroutine in Column B. In column A, enter the label "delete_breaks". Then opposite, in column B, create the range name "delete_breaks".

{IF @CELLPOINTER("row&quot=rownum}{RETURN}
{PAGE-BREAK-ROW "OFF"}
{D}
{BRANCH delete_breaks}

Leave at least one blank row, and enter the label "rownum" in Column A. In Column B, create the range name "rownum".

===============================================
A Second Option... If you want to refer to "specific" cell locations where you want to add or delete page breaks, then the following option might be preferable.

I've only created an example for 3 ranges, but of course you could extend this to whatever number of ranges you require.

Again, in Column A, it's a good practice to identify your macro with a label. For example I've used "\Q" for the following - which is entered in Column B. Of course next create the range name "\Q" for the first line of code.

The following routine is of course for Deleting Page Breaks.

{INDICATE Deleting Page Breaks}{WINDOWSOFF}{PANELOFF}
{GOTO}range1~{PAGE-BREAK-ROW "OFF"}
{GOTO}range2~{PAGE-BREAK-ROW "OFF"}
{GOTO}range3~{PAGE-BREAK-ROW "OFF"}
{HOME}
{FC}
{WINDOWSON}{PANELON}{INDICATE}

This next routine is for Adding Page Breaks. As for the above routine, also add a label in Column A, and create a range name in Column B. I've used "\W"

{INDICATE Adding Page Breaks}{WINDOWSOFF}{PANELOFF}
{GOTO}range1~{PAGE-BREAK-ROW "ON"}
{GOTO}range2~{PAGE-BREAK-ROW "ON"}
{GOTO}range3~{PAGE-BREAK-ROW "ON"}
{HOME}
{FC}
{WINDOWSON}{PANELON}{INDICATE}

The range names can be on any worksheet.

{HOME} takes you to cell A1 of the existing worksheet.

{FC} takes you to cell A1 of the first worksheet.

I hope this helps. Please advise as to how it fits.

jo'k, I hope you too can possibly utilize this. Certainly if your user want to "permanently" remove the page breaks, then Option 1 might be useful. My first answer was based on your user wanting to "temporarily" ignore the page breaks.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca