Mailing-List: contact ooo-users-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ooo-users@incubator.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=btinternet.com;
  h=DKIM-Signature:Message-ID:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:X-Mailer:Date:To:From:Subject:In-Reply-To:References:Mime-Version:Content-Type;
  b=Z/URTqmKC6S5HTja/qmcYn/EXEY8BF27oEQ3tDp2aLlQ0OgiOdAzrrJXO0k00oo+6usCYn6WDEUscQKS/RtFj6TB8YhwMF8StFSKPrNRmZn73LV4B5jwviuTGmpnTTOhhTcuvgOvXhaVTkk94iAUts2EBNQRZ0RAo+AIDmRVZfM=
  ;
Message-ID: <260825.65503.qm@smtp817.mail.ird.yahoo.com>
Date: Thu, 10 Nov 2011 21:26:49 +0000
To: ooo-users@incubator.apache.org
From: Brian Barker <b.m.barker@btinternet.com>
Subject: Re: Question Restrict Cell entry to width of cell
In-Reply-To: <4EBBBEBB.1000201@bluewin.ch>
References: <4EAAADB7.8070506@bluewin.ch>
 <CAP-ksoj3812-5eUony787fsSzQzr+ust=VhCrnAQenRjktmCVA@mail.gmail.com>
 <4EB10AB7.90800@bluewin.ch>
 <1320840667.3318.12.camel@dan-desktop>
 <j9gdum$pvq$1@dough.gmane.org>
 <4EBBBEBB.1000201@bluewin.ch>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed

At 13:08 10/11/2011 +0100, Martin Hediger wrote:
>Am 10.11.11 12:52, schrieb Harold Fuchs:
>>On Wed, 2011-11-02 at 10:17 +0100, Martin Hediger wrote:
>>>I have a Calc spreadsheet where in one column contains links to 
>>>files on my computer, so the entries are long in terms of number 
>>>of characters. I dont need to see the whole path all the time, and 
>>>I wanted to know how I can adjust that only the part of the path 
>>>fitting into the column width is displayed. Seeing the complete 
>>>path is confusing and distracts me somehow. Is it possible to adjust this?
>>
>>If you place the cursor directly on the border (vertical line) 
>>between two column headings it will change into a vertical bar with 
>>one arrow pointing left and another pointing right. If you now hold 
>>down the left mouse button you can drag the border left or right 
>>(by moving the mouse in the relevant direction) as much as you like 
>>thus adjusting the width of one of the two columns
>
>Thanks Harold for your answer.
>I was aware of this option, however, if it happens to be the last 
>column containing data, the links will always spread into the next 
>column and it looks messy.

There is a very simple workaround for this, of course: just put 
something in the next column so that it is no longer empty.  Type a 
space into one cell and fill it down the column.  There is no downside to this:
o If you ever need to use the column, you can overwrite the values or 
- more simply - just delete the column.
o To avoid including the column in any page layout, you can define a 
print range.
o If it worries you, you can even hide the column without upsetting 
its function.

I trust this helps.

Brian Barker - privately


---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org