If this forum is to be a meaningful source of shared knowledge, no matter what skill level or ability the poster has, there must be respect and and decorum. If a poster has a question to ask, there may be many others seeking the same or similar solution.
If you can't contribute to the body of knowledge, then don't reply at all. Allowing such remarks is off putting to others, enough to prevent someone from future contributions or asking of help. IMHO, Rochelle On Wed, Jun 11, 2014 at 11:48 AM, Martin Groenescheij < mar...@groenescheij.com> wrote: > > > 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 > >
