Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index


ajebay schrieb:
Hi Bruce,
Defined the ranges as before and Edit shows Print Range, User defined as:-


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.

Each print range is printed on its own page and uses further pages, if the content of the range does not fit on one page. So you will get first some pages for $A$1:$C$165, after them some pages for $I$1:$I$165 and last some pages for $K$1:$K$165.

If you want to show columns A,B,C,I,K together, you need to add a sheet with a copy of this columns being adjacent. If you use references the sheet will update, if you alter the original data. You will have in A1 =Orig.A1, in B1 =Orig.B1, in C1 =Orig.C1, in D1 =Orig.I1, and in E1 =Orig.K1. Of cause you need your own sheet name instead of "Orig".

Then you do not define your print range on the original data but on the copy, which would give you the one print range $A$1:$E$165.

Sometimes you have to print one column which is small but very long and you want to print all of it on one paper sheet. In such cases I use a trick. I define a page size, which is as wide as the column. And in the print dialog, I use the dialog page "Page Layout" to put several of this small "pages" together on one paper sheet. Most printers need the setting "Use only paper size from printer preferences" in such case and you have to set the actual paper size in the printer settings.

Kind regards

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.