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:
Hello Ennio,
Ennio-Sr wrote:However, while munging it, I discovered that typing a single "-" in a cell would do what I was looking for, i.e. fill the whole cell with hyphens (sometimes beyond the cell border). As this behaviour seems to be undocumented, I wonder whether it is normal ?! Just to be sure I closed and re-opened the spreadsheet in which I was testing and it still works :-).
Sound interesting. How do you get that? Doesn't work for me .. (OOo 1.1.2)
I am wondering if this is a variation of the border/line autoformat that you get in Writer when you put in a number of hyphen characters?
Hmmm ... no wonder: it only works on that particular spreadsheet but I'm not sure why it does so; I tried to obtain the same result in a new empty s-sheet but was unsuccessfull ;( Still investigating ..... Regards, Ennio
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?
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.
Thanks for clearing this up,
Cor
-- Cor Nouws www.nouenoff.nl
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
