On 12-6-2014 11:39, Rochelle wrote:
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.
The poster got an decent answer from Brian Barker but he _insisted_ to
use a spreadsheet for something it is not designed for.
All I wanted to make clear is that you can't go outside of the
specification without consequences.
If you can't contribute to the body of knowledge, then don't reply at all.
My contribution here is to help the poster to see that his request is
unreasonable, but if you have a solution feel free to share it with us.
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 <
[email protected]> wrote:
Sent from my mobile device.
On 12 Jun 2014, at 4:02 am, Hung Mark <[email protected]> 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" <[email protected]> ??:
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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
