Re: [libreoffice-users] Help Please with Printing Ranges

Well ... Calc is "adding" vertical page breaks between each of your defined
ranges ... I did not expect that.  Due to this instead of using a Print
Range I suggest that you group or hide columns D-H and J.  I prefer to
group: Data > Group & Outline > Group as it provides check boxes above row
1.  You will need to clear the defined print range.

On Wed, Oct 26, 2016 at 12:18 PM, ajebay <ajebay@errichel.co.uk> wrote:

> Hi Bruce,
> Defined the ranges as before and Edit shows Print Range, User defined as:-
>
> $A$1:$C$165,$I$1:$I$165,$K$1:$K$165
>
> Which is what I want.  My problem is getting the range on to paper without
> big spaces because I need to be able to read across on a line. Hope that is
> clear.
>
>
> On 26/10/2016 17:06, ajebay wrote:
>
> > Hi Bruce,
> > Thanks for the quick reply.  I haven't used the Edit, just defione and
> > add.  Will now try Edit option and report back.
> >
> > On 26/10/2016 16:22, Bruce Hohl wrote:
> >
> > > What is included at Format > Print Ranges > Edit for
> > > (1) Print Range, (2) Rows to Repeat, and (3) Columns to Repeat?
> > >
> > > On Wed, Oct 26, 2016 at 10:50 AM, ajebay <ajebay@errichel.co.uk> wrote:
> > >
> > > I am trying to print only selected columns which I have defined using
> > > > Format>Print Range>Define and Format>Print Range>Add.
> > > >
> > > > When I check using View>Page Break all the correct columns are shown but
> > > > with large vertical gaps so what should fit on one landscape sheet is
> > > > taking three with large parts of the page left white.
> > > >
> > > > I have tried moving breaks by dragging but get in a mess.  Also the
> > > > preview always assumes portrait format until I set the printer to
> > > > landscape
> > > > and then take paper size from printer.
> > > >
> > > > There must be a better way but I am too dumb to find it.  Can somebody
> > > > give me help please?
> > > >
> > > > --
> > > > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > > > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> > > > ubscribe/
> > > > Posting guidelines + more: http://wiki.documentfoundation
> > > > .org/Netiquette
> > > > List archive: http://listarchives.libreoffice.org/global/users/
> > > > All messages sent to this list will be publicly archived and cannot be
> > > > deleted
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted