I tried in version 1.1.3 Debian. It works like this:
I filled in a date in cell A1
I selected cells A1 to A40
Then Edit --> Fill --> Down
et voil�
BTW: after selecting the cells you could enter CTRL-D, but then you need a keyboard ;)
Carl Paulsen wrote:
OO 1.1.4, Win XP
I have a spreadsheet with a date that I want to be able to drag to auto fill a single date over a range of records/rows. I've been able to do this in several other spreadsheets as follows: type in at least 2 values for the same date (2 rows will have, for instance, 4/9/2005). Then I select these two dates, click the lower right corner of this selection, and drag the selection for the entire range of rows I want to fill with that same date. When I do this in other spreadsheets, the software assumes that since the two dates are the same, the rest should be the same too. When I do this in OO, what I get is the original two values, followed by two rows of the next date, followed by 2 rows of the subsequent date, etc., as follows:
4/9/05
4/9/05
4/10/05
4/10/05
4/11/05
4/11/05
4/12/05
4/12/05
etc.
If I type in 3 rows with the same date and do this kind of auto-fill, I get the same pattern with three rows of consecutive dates. I can see where this kind of auto-fill could be very handy, but what I want is just 12 rows of one date, 4/9/05. It seems like the user should establish a pattern which the auto-fill takes over for the range specified. I seem to be missing how OO works, and I couldn't find a setting to do what I want. Also checked the archives but didn't find anything.
BTW, I'm a long-time Mac user so I'm a mouse user with a hard habit and I prefer the drag and drop approach, but I suppose I could change... Also, I mostly LOVE the OO software so far!
Thanks Carl
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
