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-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org