Hi :) There are some guides/manuals on; http://documentation.libreoffice.org/en/english-documentation/
If you would like individual chapters from those guides (and more) then this link might be useful; https://wiki.documentfoundation.org/Documentation/Publications/ Other types of documentation, such as the FAQ, are linked to from this page; https://wiki.documentfoundation.org/Documentation/ Btw i suspect that Brian was talking about links/'formulas' on the "print sheet" rather than copy&pasting from the original. Using links would mean that the print page would automatically show any changes made to the original page. Of course this is all a bit academic now that you have done the printing successfully already ;)) Nicely done btw :)) Good luck and many regards from Tom :) On 30 January 2017 at 22:46, Budge <aje...@errichel.co.uk> wrote: > Hi Brian > > On 30/01/17 15:25, Brian Barker wrote: > >> At 13:21 30/01/2017 +0000, Budge Noname wrote: >> >>> I am trying to hide some columns when printing. If I use the format >>> cells > cell protection > hide when printing the contents of the cells >>> are hidden and the sheet width is reduced as expected but when I try >>> and print, it seems the space they occupy is still there giving me >>> lots of white space and many sheets! >>> >> >> I suspect that is - as they say - "by design"! It's worth noticing that, >> since this technique uses cell formatting, it could apply to some cells >> in a column and not others. If the space that would otherwise be >> occupied by the hidden cells were suppressed, the alignment of other >> output (that you did want) would be wrecked. >> >> You can hide entire columns using Format | Column > | Hide (or >> right-click | Hide on the column header). The effect on the display is >> temporary, of course, and can easily be reversed immediately after >> printing: select columns surrounding the hidden ones and use Format | >> Column > | Show (or right-click | Show on a column header). >> > > When I did this the space occupied by the hidden columns was still in the > print layout so objective not achieved. > > I would like to use the filter method, assuming this will solve my >>> problem but when I tried on one column everything disappeared. >>> >> >> "Everything"? You do want entire columns to be hidden, don't you? >> > > I meant all the columns whether in filter pattern or not. Very strange > > Here are two other ways to achieve the sort of thing you need: >> >> o Move your columns around so that the ones you do not want printed do >> not occur between ones that you do. It is perfectly possible to maintain >> the same calculations, of course. Then construct a print range that >> contains the columns you want printed but not the rogue ones. Or you >> could put the unwanted columns on a separate sheet and print only the >> required sheet. >> >> o Create a separate sheet for printing purposes, containing only the >> required columns. You need to create *formulae* referring to your >> original sheet on that sheet, not just to paste values - so that values >> there update automatically as you work on your main sheet. Then print >> just that other sheet. Again, you could alternatively do this with >> additional columns on the original sheet and a print range excluding them. >> > > I refer to this as a brute force appraoch but it is what I ended up > doing. In fact I copied only the wanted columns to next sheet and printed > from that. > > I trust this helps. >> > > Yes and thank you. Problem solved for now but clearly I have much to > learn. > Regards, > > Budge > > -- > To unsubscribe e-mail to: users+unsubscr...@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+unsubscr...@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
