Re: weird limits

[David Stanaway <david stanaway net>]

On Tue, 2004-08-03 at 11:45 -0400, rivin math temple edu wrote:
> To my great chagrin, I discovered that the last part of the recipe below
> (recompilation) is basically impossible. I have tried it on a Mac OS X
> machine (heavily finkified), on a Fedora-based enterprise machine, and on
> a knoppix up-to-date debian machine. No luck, after spending (literally)
> hours getting the latest versions of everything. It looks like I have to
> be living in the gnome development world to recompile. It is nice to have
> the sources, but if you can't recompile them it is nowhere as nice as it
> could be... Perhaps you guys could distribute binary packages with the
> ROWS/COLUMNS #defines change, but in the meantime, the advice below seems
> purely academic.
>
>   Thanks,
>
>      Igor
>
>
> > On Tue, Jun 29, 2004 at 03:09:41PM -0400, Igor Rivin wrote:
> > > I note that gnumeric has kept the wonderful Excel feature of allowing
> > > at most 65535 rows in the data. Is this realy true? Is there any way
> > > to get around this?
> >
> > The default build uses those limits for XL compatibility.  Changing them
> > is simple, but requires a recompilation.
> >
> > - edit src/gnumeric.h
> > - change SHEET_ROWS_MAX
> > - recompile


Here is the process for a debian bases system (With deb-src entries in 
/etc/apt/sources.list).


david dmxnocws13(build)$ sudo apt-get build-dep gnumeric
Reading Package Lists... Done
Building Dependency Tree... Done
0 upgraded, 0 newly installed, 0 to remove and 463 not upgraded.
david dmxnocws13(build)$ apt-get source gnumeric
Reading Package Lists... Done
Building Dependency Tree... Done
Need to get 17.9MB of source archives.
Get:1 http://ftp.us.debian.org unstable/main gnumeric 1.2.13-2 (dsc)
[1192B]
Get:2 http://ftp.us.debian.org unstable/main gnumeric 1.2.13-2 (tar)
[17.9MB]
Get:3 http://ftp.us.debian.org unstable/main gnumeric 1.2.13-2 (diff)
[70.1kB]
Fetched 17.9MB in 33s (532kB/s)
dpkg-source: extracting gnumeric in gnumeric-1.2.13
david dmxnocws13(build)$ vi gnumeric-1.2.13/src/gnumeric.h
david dmxnocws13(build)$ cd gnumeric-1.2.13/
david dmxnocws13(gnumeric-1.2.13)$ dpkg-buildpackage -rfakeroot
...
... go brew some coffee
...
dpkg-deb: building package `gnumeric' in `../gnumeric_1.2.13-2_i386.
deb'.
dpkg-deb: building package `gnumeric-plugins-extra' in `../gnumeric-
plugins-extra_1.2.13-2_i386.deb'.
 signfile gnumeric_1.2.13-2.dsc
gpg: skipped `J.H.M. Dassen (Ray) <jdassen debian org>': secret key not
available
gpg: [stdin]: clearsign failed: secret key not available
david dmxnocws13(build)$ sudo dpkg -i gnumeric*.deb
(Reading database ... 179597 files and directories currently installed.)
Preparing to replace gnumeric-common 1.2.13-1 (using gnumeric-
common_1.2.13-2_all.deb) ...
Unpacking replacement gnumeric-common ...
Selecting previously deselected package gnumeric-doc.
Unpacking gnumeric-doc (from gnumeric-doc_1.2.13-2_all.deb) ...
Preparing to replace gnumeric-plugins-extra 1.2.13-1 (using gnumeric-
plugins-extra_1.2.13-2_i386.deb) ...
Unpacking replacement gnumeric-plugins-extra ...
Preparing to replace gnumeric 1.2.13-1 (using gnumeric_1.2.13-2_i386.
deb) ...
Unpacking replacement gnumeric ...
Setting up gnumeric-doc (1.2.13-2) ...

Setting up gnumeric-common (1.2.13-2) ...
Setting up gnumeric (1.2.13-2) ...

Setting up gnumeric-plugins-extra (1.2.13-2) ...
david dmxnocws13(build)$ echo gnumeric hold | sudo dpkg --set-selections


This process is similar for an RPM based distribution, you need to get
the SRPM for the gnumeric package (From the linux distribution), unpack
it, make the change, and build the package. 

With fink, You might want to add an ed command to the info file for the
fink package which makes the change to the gnumeric.h.

Let me know if you want the debian unstable package I built. I defined
GNUMERIC_MAX_COLS = (32*32*32*32)  which seems to be the max. Any more
breaks at runtime:
** ERROR **: file ../../src/sheet-style.c: line 461 (sheet_style_init):
assertion failed: (SHEET_MAX_ROWS <= TILE_SIZE_ROW * TILE_SIZE_ROW *
TILE_SIZE_ROW * TILE_SIZE_ROW)

I am not sure of the consequences of adding more cases for defining
higher TILE_SIZE_ROW values in sheet-style.c.

-- 
David Stanaway <david stanaway net>