Calc text does not fit in cell when printing/exporting to pdf

English
, , , ,
#1

I have a calc spreadsheet which has cells containing significant amounts of wrapped text. After adjusting row heights (manually) to optimum height, i.e. so the text just fits, when I go to print preview or export as pdf, the text no longer fits in the cell, the last line of text not being visible. While at first glance this is just a height matter, looking closer, line breaks are in different places.

What can I do so that all the cell prints as displayed on screen.

My system: Windows 7, LO 5.2.2 64 bit.

#2

Perhaps the option
Menu/Tools/Options/LibreOffice calc/General - Use printer metrics for text formatting,
could help.

#3

Thank you!! This has been bugging me for years. Interestingly, MS Excel had precisely the same problem, going all the way back at least to MS OfficeXP. Your fix does the trick. :slight_smile:

#4

Thank you!! This has been bugging me for years. Interestingly, MS Excel had precisely the same problem, going all the way back at least to MS OfficeXP. Your fix does the trick. :slight_smile:

#5

If the answer solves your question please tick the :heavy_check_mark:.

#6

I can’t mark it as “answered” - I didn’t post the original question.

#7

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.