Re: transpose on bigger datasets?



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



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