Hi Brian, Thank you for the advices, but I expect that textflow to stop before the page footer and start from next page instead of covering over the page number. That's what I'm asking for help. I use it in a way as a form to collect opinions from other people and append new text. ( like issue tracking ) I believe this is not an unusual case of spreadsheet usage and using writer arise other inconvenience despite it solves formatting problem. 2014/6/12 上午12:42 於 "Brian Barker" <b.m.bar...@btinternet.com> 寫道:
> 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 > >