Re: max rows

[Jean Bréfort <jean brefort normalesup org>]

Le mercredi 13 septembre 2006 à 12:28 +1200, Tristan Wallbank a écrit :
> Hi there
>
>  
>
> I have come across the gnumeric software as there is a possibility to
> change the amount of rows (and Columns), something that would be
> immensely useful to me and my colleagues as we deal with data sets
> which often exceed the usual Excel limit.
>
>  
>
> Due to our experience and comfort with the many functions in Excel, we
> have preferred to stay with this as our main data manipulation tool.
>
>  
>
> I would like to perform full testing on gnumeric to see how it fits in
> with our needs, but cannot figure out how to change the number of
> rows.
>
>  
>
> On your webpage in FAQ, it is quoted as “it requires a re-compile.
> Edit SHEET_MAX_COLS and SHEET_MAX_ROWS in src/gnumeric.h and
> re-compile. Note, that performance might be an issue if you make
> either of these huge.” I have not been able to find this file
> “gnumeric.h”. Could you please provide more detailed instructions on
> how to perform this change? I am running version 1.6

gnumeric.h is in the src directory.
Lines 8 and 9 of this file are:
#define SHEET_MAX_ROWS          (16*16*16*16)   /* 0, 1, ... */
#define SHEET_MAX_COLS          (4*4*4*4)       /* 0, 1, ... */

Just replace the values with what you need and compile. If you never
compiled it before, you'll need to run configure in the top gnumeric
directory and then make.
Detailed instructions are available in the INSTALL file.

Regards,
Jean

> Please keep in mind that I am programming illiterate!
>
>  
>
> Regards,
>
>  
>
> Tristan Wallbank
>
>  
>
> Wind Engineer
>
> Suzlon Energy
>
> Level 28, Majestic Centre
>
> 100 Willis Street
>
> PO Box 3116
>
> Wellington
>
> New Zealand
>
>  
>
> Ph: +64 4 472 9417
>
> MOB: +64 21 718 487
>
> Email:trw suzlon com au
>
> Web: www.suzlon.com
>
>  
>
>  
>
> The contents of this email (including attachments) is confidential,
> and may contain copyright material of Suzlon Energy Australia Pty Ltd.
> If you are not the intended recipient, or the person responsible for
> delivering the email to the intended recipient, please immediately
> notify Suzlon Energy Australia Pty Ltd by return email or phone
> +61.3.8660 6501and destroy the original transmission and its contents.
> Any use (which includes dissemination, forwarding, printing, or
> copying) of this email and any file attachments is prohibited. It is
> the recipient's duty to virus scan or otherwise test this email before
> loading it onto any computer.  No warranty is given that this email is
> free from computer viruses or any other defect or error.
>
>  
>
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list