![[TEST] Document Foundation Community](https://communitytest.documentfoundation.org/images/discourse-logo-sketch.png){kind=logo}
Hi,
I have a small problem. When I'm exporting PDF and then I try to print it, it results with small reduction of document's dimensions in comparison with result obtained by printing directly from LO.
My question is: Is there any way to have the size of PDF Document exactly as the original LO Document (margins, characters,..) without any size reduction?
Thank you,
Tom
Hi 
Do you do
File - "Export to Pdf"?
If so then in the dialogue-box, see the right-hand side? See underneath "lossless compression" there is an option for "Jpeg compression"? You can set the percentage for whatever you want. Also you can further reduce the images from 300Dpi to something much lower. 200 is fairly normal. Jpeg compression suffers from all the usual problems of jpg such as speckling, whirls around sharp edges and all that but most people don't notice that nowadays.
A better way to get documents smaller is to make a copy of the .odt and change the file-ending from .odt to .zip and then open it. Some archive managers allow you to right-click on the odt and "open with" the archive manager without having to change the file-ending. Look for items that seem heavier than the rest. Usually i find 1 or 2 images are excessively 'heavy' (large), particularly logos or photos. These can usually be edited in Gimp or PhotoShop or something. Gimp is OpenSource and free so it's my favourite. Scale or crop images, despeckle, generally clean them up and you will find they take up much less space. Then you just have to replace the old heavy ones with the nicer new ones.
Regards from
Tom
Hi
Ooops, sorry. There is usually an option in the printer properties to shrink the document/image to fit the printable area. Printers seem to have a psychological aversion to printing right up to the edges and you need to over-ride that. i think it's something like
File - Print - Properties
and then it's different for each type of printer depending on how the manufacturer set-up their dialogue boxes. In Gnu&Linux they tend to be fairly generic but in Windows they are all very different.
Regards from
Tom
Hello Tom,
sorry, maybe I wasn't so precise. My problem isn't a file size - my problem is a printing Document size. When it's exported in PDF, the printing result is a little bit reduced than the one printed directly from LO. Is there any way to maintain the exact dimensons for the same printing result?
Tom Duk wrote
sorry, maybe I wasn't so precise. My problem isn't a file size - my
problem is a printing Document size. When it's exported in PDF, the
printing result is a little bit reduced than the one printed directly from
LO. Is there any way to maintain the exact dimensons for the same printing
result?
Are you sure the result is reduced? Isn't it using the same page size? Is
the total number of pages different or the text that fits in each page
different?
Maybe the export PDF option is setting a different Initial View (which could
modify the Magnification)
Hi
No i have found a similar thing happens on my printer here. It assumes that the user is an idiot and doesn't really want what they ask for so it protects the user from accidentally using the whole page by creating a 4-5mm border around the edge of the page and then shrinking any images or pdfs to fit inside that "printable area".
The original post was clear enough but i am dealing with the other issue quite a lot at the moment and didn't read the question carefully enough.
Apols and regards from
Tom
Here is my question:
When you print directly, you get it the correct margins.
Are you getting the wrong margins when you print the PDF file, or does the PDF file have the wrong margins?
It was unclear to me.
It there is headers and footers in the page, there may be the issue of the PDF file being too "large" for printing on the paper without "shrink to fit page" option being used. I have had that issue pop up before myself, but I do not know if that is the same as the user's issue.
Then there is the question on what is the margins set for and what are you getting with the Export to PDF option?
Have you tried a PDF printer, like doPDF for Windows and CUPS-PDF for Linux? If the problem is the printing of the PDF document, print the document using a PDF printer [like a physical printer but only to a PDF file]. Then print that document to see if the margin/size issue is the same. If so, then it is a printer issue printing the PDF file. If not, then it is the Export to PDF option that is causing the issue.
Solved. It was a problem of PDF printing. I changed properties of Page handling and everything seems OK now. Thank you Tom and webmaster of KKP.
Hi
Congrats, nicely done
Regards from
Tom too
Hi All
I have a spread sheet in LO 3.4.3 where I record and analyse monthly numbers and amounts for a electricity bill.
The figures for each month are all in one Row.
Below this I have "Allocation Blocks" that allocate the top figures to different sub-users.
Like this...
A B C D
1 Jan 00 00 00 ........etc
2 Fed 00 00 00 ........etc
3 Mar 00 00 00 ........etc
4 Apr 00 00 00 .........etc
_ANALYSIS FOR (Month)_
Name - Cell n + Cell n (where the 'n' has to be the correct Month Row)
Name - Cell n + Cell n (ie it increments by one for each month)
etc
I have simplified the above but this is the basic concept.
How can I modify the formula to pick-up the correct Row for the month I wish to do the analysis - and printout the report for? Is there a way to pick-up the 'Month' in the Analysis Block and use this to select the correct row?
(In Basic this would have been "If 'Month'=Jan then Row=1" etc etc
Hope you follow me. Thanks for any help.
Ian Whitfield.
Please start a new thread instead of responding to an already existing
thread. To know more about what I'm talking about, please search "thread
hijacking" in google.
You'll increase your chances of getting an answer.
Thanks Marcello
I was/am under the impression that to start a New Thread you start with a brand new Subject line WITHOUT any "Re:' in front of it, but it seems that I'm wrong and for this I apologize.
I did do a search on Google as you suggested but found nothing that tells me HOW to start a new Thread. Only that it shouldn't be done.
I then looked in the 'TDF/LibreOffice Mailing List Netiquette' but again I find no instructions on HOW to start a new thread!!!
Maybe you could give me - and others - some pointers for this or direct us to a specific site where we can find the 'How To' information please.
I did learn in this search that I should use a "full" signature with my postings so I will start to do that from now on!!
*/_Ian Whitfield_/*//
ZS6CDX
*Pretoria, South Afric*a
*Tel* - +27 (0)12 817 2001
*Cell* -+27 (0)82 573 9142
*FAX* - +27 (0)86 651 4844
*Skype* - ianzs6cdx, also on Facebook
*SnailMail* - Box 72226, Lynnwood Ridge 0040, South Africa/
/
Hi
Don't worry about using a full signature. That really is not needed at all. You can start a new thread by writing a new email instead of replying to a previous one (or forwards an existing post) and just copy&paste or type the address
users@global.libreoffice.org
into the "To" field.
Many apologies for the "support" so far! Hopefulyl someone might actually answer the question at some point!
Regards from
Tom
To start a new thread (or I could say to not hijack an existing thread)
just write an e-mail to users@global.libreoffice.org
Ps: sorry for not being able to help you on your question... I hope I've
been helpful in another way.
Ian,
The "If 'Month'=Jan then Row=1" relationship can be a VLOOKUP, MATCH and INDEX family of spreadsheet functions. I have sometimes used the INDIRECT functions but these get very cumbersome and fragile.
This looks like it would be better done as a query in Base. I used combinations of spreadsheets, for the raw data, and databases for the monthly reporting in my budget/expense tracking work.
Thanks to Brian and the others who have now "put me right" and shown me the right way to start a new Thread!!!
Regarding the 'Signature' I was going along with what I found in the 'TDF/LibreOffice Mailing List Netiquette'...
/"Signature/
/Always 'sign' your message with your name and your preferred e-mail address. This is especially important because some e-mail and newsreader software do not always convey the originator's full e-mail address. While you may certainly include your regular mail address in your postings, you may wish to give this out only in personal replies, when necessary. /
/Use a short signature, including only the essential information. Four lines are usually enough to include name, email, telephone number and other nicknames, and - if necessary - corporate affiliation. Please avoid lengthy legal disclaimers, which are useless in principle and even more useless - and disturbing - when posting to a mailing list."
/
If this is in fact wrong I would suggest that it be changed on the WebSite!!
So - OK - I will go back to just signing my name and occasionally adding my City!!
Thanks all - On the main question I'm still looking for a positive answer. So far VLOOKUP is NOT what I want am about to look at HLOOKUP and MATCH.
Just thinking........ I wonder if "=A+'Z4' " would work to give me 'A12" if I put the value 12 into Z4. Will try.......
NO - That doesn't work!! I tried various combinations.
The one I thought would work was 'A+(VALUE(Z4))' but no luck.
Is my syntax out??
Ian Whitfield
Pretoria./
/
Maybe
=INDIRECT("A"&VALUE(Z4))
Miguel Ángel.
* Español - detectado
* Inglés
* Español
* Inglés
* Español
<javascript:void(0);> <#>
Hi
The signatures advice sounds mad to me. You are right it does need changing but i doubt we could agree on something sensible. The list is available to the general public around the world so posting phone numbers is very much NOT a good idea and definitely not a home address! Personally i am usually wary about even letting people know which country i am in!
On a different mailing list (nothing to do with LibreOffice) one girl wrote in that she was 16 and lived such and such place and would happily meet up with anyone on that list! Someone did get in touch, but with her parents (not the girl) to warn them of the dangers and to let them know what their daughter had been doing online!
I think the note must be for people thinking about taking a key position in TDF and 'must surely' be referring to non-private phone numbers and not the persons home address.
Regards from
Tom