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
