Sometimes we need to adjust our thinking rather than our software. Carl, if you wish to fill a range with the same date (or any auto increasing character set) using a dragging motion, it's really a lot simpler to use the 'old school' copy operation as follows:
Type the date in the top cell of the desired range. Right hand on mouse, left hand on keyboard Select the cell <Control c> to copy, with the left hand Select the range to fill with the mouse <Control v> to paste The above process is actually a lot fewer keystrokes and movement, and therefore much more efficient, than typing the date twice and dragging it after. Jeannie -----Original Message----- From: Carl Paulsen [mailto:[EMAIL PROTECTED] Sent: Monday, April 25, 2005 5:00 PM To: [email protected] Subject: [users] Auto fill 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
