You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Brian Barker <b....@btinternet.com> on 2014/06/11 18:41:35 UTC
Re: How to prevent very long text in a cell overlap the footer
in Calc?
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: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org