Re: Differences from Excel...



On Mon, 2006-21-08 at 05:34 +0000, Scott Ballantyne wrote:
I notice that doing the 'drag cell' trick to extend a series (i.e.,
you have 2 in A1 and 4 in A2, highlighting both of these and dragging
downards yields 6, 8, 10 etc.) doesn't seem to work with dates. That
would be quite handy for rapidly entering date ranges as column/row
headings.

Dates are just numbers, so this works for dates as well (as long as you
enter those dates in a way that allows Gnumeric to recognize them as
dates);

For example enter 2006/2/1 in B4 and 2006/2/3 in B5. Select B4 and B5
and do the "drag-cell" trick to extend the selection to B4:B20. B20 now
contains 2006/03/5.

Andreas




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]