[bugzilla-daemon@widget.gnome.org: [Bug 61650] New - More autofill heuristics are needed...]

[Jody Goldberg <jgoldberg home com>]

Do other languages use Q and H ??  I doubt it.
Is the order standard or do people write
    2001Q2 also ?

----- Forwarded message from bugzilla-daemon@widget.gnome.org -----

From: bugzilla-daemon@widget.gnome.org
To: jgoldberg@home.com
Cc: 
Subject: [Bug 61650] New - More autofill heuristics are needed...
Date: Wed,  3 Oct 2001 05:41:40 -0400 (EDT)

http://bugzilla.gnome.org/show_bug.cgi?id=61650

           Summary: More autofill heuristics are needed...

Excel seems to use pattern-matching heuristics when autofilling ranges.  It
looks like the gnumeric code is not quite so smart yet.

The one I particularly noticed as missing is that Gnumeric generates 1Q01,
2Q01, 3Q01, 4Q01, 5Q01, ...  This is a pretty standard abbreviations for
quarters of a year in financial spreadsheets.  The correct fill ought to be
3Q01, 4Q01, 1Q02, ...   Similarly for 1H01, 2H01, 1H02, ...

Arguably you should also auto-fill A, B, C, D to continue E, F, G, ...  At
the moment it just repeats the selected cell.

Perhaps you could eventually have a dialog through which the patterns could
be configured, if the macro language is powerful enough to allow the
expansions to be concisely expressed.

Gnumeric seems to be coming along so nicely.  Good work!

----- End forwarded message -----