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 <[email protected]> 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 <[email protected]> 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: [email protected] >>>> 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: [email protected] > 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: [email protected] 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
