I don't think that you can do what you want exclusively with the mouse. All you need do is enter the date in the first row, select the area you want to fill, then give your mouse bit of cheese and let it take a break while you select, 'edit / fill / down' (alt e,i,d). You could do that with the mouse as well, but yours is probably overworked and would appreciate the rest break.
tc
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]
