After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 172241 - I need a quick removal of Excel-limitations in no rows (65535)
I need a quick removal of Excel-limitations in no rows (65535)
Status: VERIFIED DUPLICATE of bug 168875
Product: Gnumeric
Classification: Applications
Component: import/export Text
1.4.x
Other All
: High enhancement
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2005-03-31 12:54 UTC by Jorgen Larsson
Modified: 2009-08-15 18:40 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Jorgen Larsson 2005-03-31 12:54:28 UTC 
In order to make this fantastic application even more appealing to statistical 
analytics it should be possible to handle a lot more than the Excel-limit of 
65535 rows in one sheet. I have for example a tab-separated file with approx. 
500 000 rows in that I want to use the filter-function on each kolumn and to do 
some statistical tests on.

Is this feature possible to have in a near future?
I am using the release 1.4.3 for Windows.

Best regards
Jorgen Larsson
Comment 1 Morten Welinder 2005-03-31 14:24:14 UTC 
It's possible, but you'll have to recompile yourself.

*** This bug has been marked as a duplicate of 168875 ***
Comment 2 Jon Kåre Hellan 2005-03-31 14:31:00 UTC 
Edit SHEET_MAX_COLS and SHEET_MAX_ROWS in src/gnumeric.h and re-compile.
However, there is still some black magic involved in building gnumeric for
Windows. Do you have access to a Linux machine?
Comment 3 Jorgen Larsson 2005-03-31 16:01:24 UTC 
No I do not have a Linux machine and I am sorry but I do not have the 
knowledge to compile the source code.
Is there another way to have this problem solved?
Comment 4 Jody Goldberg 2005-03-31 22:38:15 UTC 
I'm sorry, no.
We don't have the resources to do custom builds.  It would be nice if a win32
build was simpler, but unfortunately there are no turn-key solutions for a build
environment.  Your best bet would be a linux install, then you could use jhbuild.

Alternatively, you may be able to bribe our local win32 build master.  However,
that is not a solution that scales.  There would be no way to generate new
packages as updates occur.
Comment 5 Jorgen Larsson 2005-04-04 06:33:00 UTC 
Thanx for all your answers.
I'm really satisfied with the quick responses I've received.

Although I do not agree that this is just a custom build. This is actually a 
really good argument for not using MS Excel since it has this limitations. I 
still think it should be a default number of rows that is a lot more than 
65535. If it then could be changed by the user it is even more appealing.

This feature would for me be a reason for changing to Gnumeric from Excel, 
dispite that Gnumeric is a lot slower in its respons times (another issue of 
concern). 

Please let me know if I can help the development team in some way. I have 17 
years of experiances in DB-design (Oracle) and 12 years in DW/OLAP/BI so I 
should be able to contribute in some way at least when it comes to some 
extreme data usage.

Best regards
Jorgen Larsson