RE: Question Restrict Cell entry to width of cell

2011-11-11 Thread Dennis E. Hamilton
or use "=HYPERLINK(URL, text)" where the displayed text can be different than the full URL? -Original Message- From: Manuel Andres Ramirez [mailto:manuelandr...@aim.com] Sent: Friday, November 11, 2011 06:18 To: ooo-users@incubator.apache.org Subject: Re: Question Restrict Cel

Re: Question Restrict Cell entry to width of cell

2011-11-11 Thread Manuel Andres Ramirez
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

Re: Question Restrict Cell entry to width of cell

2011-11-10 Thread Brian Barker
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 d

Re: Question Restrict Cell entry to width of cell

2011-11-10 Thread Martin Hediger
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. Kind regards Martin Am 10.11.11 12:52, schrieb Harold Fuchs: "Dan Lewis" wrote in message news

Re: Question Restrict Cell entry to width of cell

2011-11-10 Thread Harold Fuchs
"Dan Lewis" wrote in message news:1320840667.3318.12.camel@dan-desktop... On Wed, 2011-11-02 at 10:17 +0100, Martin Hediger wrote: Dear List 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 n

Re: Question Restrict Cell entry to width of cell

2011-11-09 Thread Dan Lewis
On Wed, 2011-11-02 at 10:17 +0100, Martin Hediger wrote: > Dear List > 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 >

Re: Question Restrict Cell entry to width of cell

2011-11-03 Thread Martin Hediger
your suggestion for defining a new style worked perfectly., thanks. Martin Am 02.11.11 11:26, schrieb Terry: You can do that three ways. One is to format each cell. I recommend that, instead of re-formatting each cell, you create a new cell style because that will mean that there is less

Re: Question Restrict Cell entry to width of cell

2011-11-02 Thread Martin Hediger
Thank you very much for your comprehensive answer, Terry. I will be going through it, Marti Am 02.11.11 11:26, schrieb Terry: You can do that three ways. One is to format each cell. I recommend that, instead of re-formatting each cell, you create a new cell style because that will mean

Re: Question Restrict Cell entry to width of cell

2011-11-02 Thread Terry
You can do that three ways.  One is to format each cell.  I recommend that, instead of re-formatting each cell, you create a new cell style because that will mean that there is less formatting data for the file to hold. F11 will open the styles dialogue.  Right click on 'default' and select 'new