save as text, transpose from the linux command line, re-import to your spreadsheet. This way you exploit best your machine's hardware.
use the attached "transpose" code if you wish cat text | tr '\011' ' ' | ./transpose ' ' > text.trans (to transpose tab-delimited "text" file ) runs right away; more in the error message... On Wed, Oct 29, 2014 at 11:30 AM, Morten Welinder <[email protected]> wrote: > 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 > <[email protected]> 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 >> [email protected] >> https://mail.gnome.org/mailman/listinfo/gnumeric-list >> > _______________________________________________ > gnumeric-list mailing list > [email protected] > https://mail.gnome.org/mailman/listinfo/gnumeric-list
transpose
Description: Binary data
_______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list
