openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Barker <>
Subject Re: How to prevent very long text in a cell overlap the footer in Calc?
Date Wed, 11 Jun 2014 16:41:35 GMT
At 23:34 11/06/2014 +0800, Hung Mark wrote:
>I'm using OpenOffice 4.1.0 ( Windows 7 with traditional Chinese ). 
>When I enter lots of text in a cell in Calc so that it excess the 
>height of a page, it overlaps with the page footer.

I'm not sure what you are hoping to happen here. Surely the nature of 
a spreadsheet - usually containing values, whether they be numbers, 
text, etc, to be processed - is that you would not want a single cell 
to be split across pages. If a multi-line cell would otherwise be 
split across pages, it is moved wholesale to the next page, but that 
cannot solve the problem if, as you have contrived, a single cell 
exceeds the page length.

>How do I prevent it?

o Change the font size.
o Go to Format | Cells... | Alignment | Properties, remove the tick 
from "Wrap text automatically", and tick "Shrink to fit cell size".
o Distribute the material between two cells.
o Use a text (Writer) document instead. A table may be useful.
o Use a spreadsheet but transfer the material to a text document for 
final formatting.

I trust this helps.

Brian Barker

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message