Sent from my mobile device.
> On 12 Jun 2014, at 4:02 am, Hung Mark <mark...@gmail.com> wrote: > > 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. You can,t fill a 10 liter bucket with 11 liter water. > 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 Yes it is unusual, what you try to do is driving a screw in the wall wit a hamer. > 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 >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org