* Cor Nouws <[EMAIL PROTECTED]> [270205, 10:18]:
> G. Roderick Singleton wrote:
>
> >On Sun, 2005-02-27 at 02:31 +0100, Ennio-Sr wrote:
> >
> >>* Ennio-Sr <[EMAIL PROTECTED]> [270205, 01:26]:
> >>
> >>>* Jonathon Coombes <[EMAIL PROTECTED]> [270205, 08:49]:
> >>>
> >>>>On Sat, 2005-02-26 at 21:44 +0100, Cor Nouws wrote:
[ ... ]
> >>
> >>OK, I was able to reproduce it in a brand-new spreadsheet:
> >>
> >>1. fill manually A5 with hyphens
> >>2. point on right-end-corner of cell A5 and drag it up to cell D5:
> >> all cells from A1 to D5 are now filled with hyphens.
> >>3. At this stage, if you type a hyphens in any cell on columns C,D,E and
> >> press Enter, the cell will be automaically filled!
> >>
> >>Don't ask me why ;-)
> >>
> >>Good night,
> >> Ennio.
> >
> >
> >Is AutoInput enabled?
Yes, it is ...
>
> It �s AutoInput (Tools|Cel contents|AutoInput) that makes it happen.
> A very handy feature indeed, and a sort of related to Ctrl-D (chooise
> list) very handy as well.
>
I discovered where thanks to Cor's indication above [I don't know yet
all OOo's potentialities :-) ]:
-------------
Cell Contents
Opens a submenu with commands to calculate tables and activate AutoInput.
To access this function...
Choose Tools - Cell Contents
[...]
AutoInput Toggles the AutoInput function, which automatically completes
entries, based on other entries in this column. The column is scanned up
to a maximum of 2000 cells or 200 different strings.
-------------
So, my starting question has driven me to a new discovery but hasn't got
an answer ;(
The =REPT("-";cell("width")) formula would be all right if it calculated
"width" in retation to the character within quotes instead of being tied
to "0"s!
> Thanks for clearing this up,
> Cor
It's me that thanks you all for your suggestions.
Regards,
Ennio.
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (�|�)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
