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 <mortenw gnome org> 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 <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_______________________________________________ gnumeric-list mailing list gnumeric-list gnome org https://mail.gnome.org/mailman/listinfo/gnumeric-list
Attachment:
transpose
Description: Binary data