incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dennis E. Hamilton" <orc...@msn.com>
Subject RE: Question Restrict Cell entry to width of cell
Date Fri, 11 Nov 2011 14:50:38 GMT
or use "=HYPERLINK(URL, text)" where the displayed text can be different than the full URL?

-----Original Message-----
From: Manuel Andres Ramirez [mailto:manuelandresr@aim.com] 
Sent: Friday, November 11, 2011 06:18
To: ooo-users@incubator.apache.org
Subject: Re: Question Restrict Cell entry to width of cell

El 10/11/11 16:26, Brian Barker escribió:
> 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?
>>>
>
>

Hi,

I'll recomend you use the function =right() or =left(), maybe you can 
extract part of the link in another column and hide the original.

bye.

-- 

Manuel Andrés Ramírez P.
Administrador Informático
GNU/Linux Registered User:412887
www.obtengalinux.org

<<Yo Tengo mi Office Legal y no pagué por su licencia>>

"El placer más noble es el júbilo de comprender"
(Leonardo Da Vinci)


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


Mime
View raw message