Mailing-List: contact users-help@openoffice.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openoffice.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Message-ID: <538F374E006E1F6C@smtpout16.bt.lon5.cpcloud.co.uk> (added by
 postmaster@btinternet.com)
Date: Wed, 11 Jun 2014 17:41:35 +0100
To: users@openoffice.apache.org
From: Brian Barker <b.m.barker@btinternet.com>
Subject: Re: How to prevent very long text in a cell overlap the footer
  in Calc?
In-Reply-To: <CAGXUSKB1mkgYm5HxQeG8_6bMJJaO+iV-4X2vAxJx1=Sq_89ZwQ@mail.g
 mail.com>
References: 
 <CAGXUSKB1mkgYm5HxQeG8_6bMJJaO+iV-4X2vAxJx1=Sq_89ZwQ@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed

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