From mboxrd@z Thu Jan 1 00:00:00 1970 From: Cameron Horsburgh Subject: Re: Filling a list of dates in a spreadsheet Date: Wed, 10 Feb 2016 20:08:39 +1030 Message-ID: References: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=001a114f27eae5915f052b673247 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:37791) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1aTREQ-0008SU-7m for Emacs-orgmode@gnu.org; Wed, 10 Feb 2016 04:38:43 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1aTREP-0006fU-5x for Emacs-orgmode@gnu.org; Wed, 10 Feb 2016 04:38:42 -0500 Received: from mail-yw0-x231.google.com ([2607:f8b0:4002:c05::231]:34795) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1aTREO-0006fC-WA for Emacs-orgmode@gnu.org; Wed, 10 Feb 2016 04:38:41 -0500 Received: by mail-yw0-x231.google.com with SMTP id h129so10044699ywb.1 for ; Wed, 10 Feb 2016 01:38:39 -0800 (PST) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Christian Moe Cc: Emacs-orgmode@gnu.org --001a114f27eae5915f052b673247 Content-Type: text/plain; charset=UTF-8 Ah, thank you! That's exactly what I'm after! Cameron Horsburgh On 4 February 2016 at 18:43, Christian Moe wrote: > > Hi, > > S- (Shift-Return) is your friend. After you've entered the first > two dates, move down to the third row (which needs to be empty), and hit > S-. You can continue pressing S- without moving down a row > each time. > > Yours, > Christian > > > > Cameron Horsburgh writes: > > > Hi folks, > > > > I'm putting together a spreadsheet in org-mode. This is the general > format: > > > > |----------------------+---------------+--------------------| > > | Date | Field One | Field Two | > > |----------------------+---------------+--------------------| > > | [2016-02-07 Sun] | | | > > | [2016-02-14 Sun] | | | > > | [A few lines] | | | > > | [A few more lines] | | | > > | [2016-12-25 Sun] | | | > > |----------------------+---------------+--------------------+ > > > > The date column needs to have a list of dates for every Sunday this year. > > In a traditional spreadsheet program there would be a function to 'fill' > > the series of dates automatically. I can't see anything in org-mode that > > would do this. Am I missing something, or will I just have to do it > > manually? > > > > Thanks! > > > > Cameron Horsburgh > > --001a114f27eae5915f052b673247 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Ah, thank you! That's exactly what I'm after!



Cameron Horsburgh

<= /div>

On 4 February 2016 at 18:43, Christian Moe <= span dir=3D"ltr"><mail@christianmoe.com> wrote:

Hi,

S-<RET> (Shift-Return) is your friend. After you've entered the f= irst
two dates, move down to the third row (which needs to be empty), and hit S-<RET>. You can continue pressing S-<RET> without moving down = a row
each time.

Yours,
Christian



Cameron Horsburgh writes:

> Hi folks,
>
> I'm putting together a spreadsheet in org-mode. This is the genera= l format:
>
> |----------------------+---------------+--------------------|
> | Date=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| = Field One=C2=A0 =C2=A0 =C2=A0| Field Two=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = |
> |----------------------+---------------+--------------------|
> | [2016-02-07 Sun]=C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 |
> | [2016-02-14 Sun]=C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 |
> | [A few lines]=C2=A0 =C2=A0 =C2=A0 =C2=A0 |=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 |
> | [A few more lines]=C2=A0 =C2=A0|=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 |
> | [2016-12-25 Sun]=C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 |
> |----------------------+---------------+--------------------+
>
> The date column needs to have a list of dates for every Sunday this ye= ar.
> In a traditional spreadsheet program there would be a function to '= ;fill'
> the series of dates automatically. I can't see anything in org-mod= e that
> would do this. Am I missing something, or will I just have to do it > manually?
>
> Thanks!
>
> Cameron Horsburgh


--001a114f27eae5915f052b673247--