Re: gnumeric feature request

[Jay Love <jslove mindspring com>]

"Vsevolod E. Shorin" wrote:




In addition to just the straight transpose that all commercial
spreadsheets have, I find myself often in need of a reverse option in
conjunction with transpose.  So if you have the cells:

A1=1  B1=2  C1=3

and you do a copy, paste->transpose to cell C3, you get:

C3=1 C4=2 C5=3

But I often need these values reversed so that

C3=3  C4=2  C5=1

Maybe an option on the paste special dialog for pasting in reverse, that
would apply both to transpose and to regular pastes. In Excel, too often
I find myself writing a relatively complex macro to accomplish what
seems like a pretty basic task. 




> 
> On 31 May 1999, Miguel de Icaza wrote:
> 
> >
> > > Every commercial spreadsheet since Lotus123 release 1 has included the
> > > abililty to transpose selected data.  Nowadays, this is usually
> > > implemented using "paste special->transpose", against a selected and
> > > copied or cut portion of the spreadsheet.
> >
> > Please describe what "transpose" is supposed to do.
> >
> > I have no idea.
> 
>  1 2 3 4       1 5 9
>  5 6 7 8  ---> 2 6 a
>  9 a b c       3 7 b
>                4 8 c
> 
> >
> > --
> > miguel@gnu.org
> >
> >
> > --
> >         FAQ: Frequently-Asked Questions at http://www.gnome.org/gnomefaq
> >          To unsubscribe: mail gnome-list-request@gnome.org with
> >                        "unsubscribe" as the Subject.
> >
> 
> --
>         FAQ: Frequently-Asked Questions at http://www.gnome.org/gnomefaq
>          To unsubscribe: mail gnome-list-request@gnome.org with
>                        "unsubscribe" as the Subject.