Re: transpose on bigger datasets?

[Morten Welinder <mortenw gnome org>]

You would need a spreadsheet with 12345678 columns to store that.
That's a no-go.  We max out at 16384.  While you could change that
in the source code and recompile, you will hit this and related problems:

    if (GNM_MAX_COLS > 364238) {
        /* Oh, yeah?  */
        g_warning (_("This is a special version of Gnumeric.  It has
been compiled\n"
                 "with support for a very large number of columns.
Access to the\n"
                 "column named TRUE may conflict with the constant of
the same\n"
                 "name.  Expect weirdness."));
    }


As for selecting a large area, use the entry just above cell A1.

Morten


On Wed, Oct 29, 2014 at 3:54 AM, Berntsson, Martin
<martin berntsson eon se> wrote:
> Dear all,
>
>
>
> I work with (relatively) large data tables and appreciate gnumeric for its
> stability and speed. I need some advice concerning the use of gnumeric and
> the function “transpose”.  I have used “transpose” successfully on small
> datasets.
>
>
>
> Problem :
>
>
>
> I have a matrix size ca 12345678x9 (ca 10^8 elements, numeric and text
> fields), in a gnumeric spreadsheet.
>
> I want the transposed matrix 9x12345678.
>
>
>
> How is this best done?
>
>
>
> What dosnt work :
>
>
>
> ·         Copy paste special - transpose (bug?)
>
> ·         Marking the entire spreadsheet (bug?), when using transpose.
>
> ·         The first step when using “transpose” should be to mark a region
> of size 9x12345678. This is difficult to do “manually”. Can this be done in
> another way?
>
>
>
>
>
> I have a 64_x86 linuxmint machine with lots of memory.
>
>
>
>
>
> Peace!
>
> Martin
>
>
>
>
>
>
>
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> https://mail.gnome.org/mailman/listinfo/gnumeric-list