Just hold the Ctrl key while dragging :) On 4/25/05, Carl Paulsen <[EMAIL PROTECTED]> 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 > > -- > Program Director > NH Rivers Council > 54 Portsmouth Street > Concord, NH 03301 > 603-228-6472 > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
-- My OpenOffice Calc Website http://www.openofficetips.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
