Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


View Poll Results: Which do you use/like the most?
Calc 13 72.22%
Gnumeric 5 27.78%
KSpread 0 0%
Voters: 18. You may not vote on this poll

  Search this Thread
Old 06-16-2006, 04:46 PM   #1
Senior Member
Registered: Mar 2003
Location: Mexico City
Distribution: Fedora, Ubuntu & Mint
Posts: 1,679

Rep: Reputation: 45
Gnumeric or Calc?

Which of these do you think is a better overall spreadsheet application? Which offers the most extensibility, best forumlŠ library and stuff like that?

I know Gnumeric beats Calc in the startup and resources area (yeah, Calc tends to be a bit resource hungry, due to the integration with the rest of OOo), but I was wondering which offers the best performance and features as a spreadsheet?

Calc can be extended either with Macros, plugins or even [Java] applets, I'm not that familiar with Gnumeric to know if it is as extensible (or more) than Calc. I like both, and as of Calc 2.0.x they both pretty much support the same number of cells per sheet, is there anything one could do in Calc that is not possible in the other and vice versa?


PS: I'm writing something about Linux and office productivity with the most common free and freely available packages for Linux (OOo, GNOME-Office, KOffice, etc), and I need to collect some more data, from users of these programs, I've got my opinion, but wnat to see others as well.

Last edited by Thetargos; 06-16-2006 at 04:47 PM.
Old 06-16-2006, 09:34 PM   #2
Senior Member
Registered: Nov 2003
Location: Perth, Western Australia
Distribution: Ubuntu, Debian, Various using VMWare
Posts: 2,088

Rep: Reputation: 62
I use Calc when I have to do speadsheeting. I find that it does most things Microsoft Excel can. Also, using OpenDocument by default means that I will not have trouble opening my spreadsheets in years to come. Will "gnumeric" format be supported in 5 years when the taxman wants to audit me?

Calc also converts .xls to .ods and back almost flawlessly. Since Excel is the benchmark when it comes to spreadsheeting, this is very important.

Old 06-17-2006, 12:31 PM   #3
Senior Member
Registered: Oct 2005
Location: It varies, but usually within 100 feet of a keyboard.
Distribution: Fedora 10, Kubuntu 8.04, Puppy 4.1.2, openSUSE 11.2
Posts: 1,126

Rep: Reputation: 51
OpenOffice Calc was the first Linux spreadsheet I tried, I liked what I saw, and had no reason to look further. Anyway, I like the fact that it can read and open Excel documents, and it seems to support all the features I need. (I have not yet run into anything that I want it to do and cannot.)
Old 06-18-2006, 07:22 AM   #4
Registered: Apr 2006
Location: Australia
Distribution: PCLinuxOS with Xfce
Posts: 301

Rep: Reputation: 30
macro support was my first consideration

When migrating to Linux, I had Lotus spreadsheet documents to convert. The main document made extensive use of macros and, in view of the number of data entries required, I wanted an automated document ready to go.

I had a quick look at gnumeric. It did not appear to have macro support, it was obviously not the main contender and I wondered whether it was more than just a spare time hobby for a desktop designer. I found out about kspread much later and the same comments apply.

I'd like Calc to be better, its macro tools to be more straightforward and better documented and formula functions more streamlined. But it does what I need; for me, there's no other option.

A complementary consideration. I use kde because it has three very good tools, at least one of which does not work properly on the gnome desktop. I have to put up with a lot for the sake of those tools. Similar comments probably apply to gnome. I hesitate to encourage either to divert from lifting their desktop game.
Old 06-18-2006, 12:04 PM   #5
hand of fate
Registered: Nov 2003
Distribution: Mandriva
Posts: 441

Rep: Reputation: 31
Originally Posted by IBall
Also, using OpenDocument by default means that I will not have trouble opening my spreadsheets in years to come. Will "gnumeric" format be supported in 5 years when the taxman wants to audit me?
I think GNumeric also supports OpenDocument formats.
Old 06-18-2006, 01:18 PM   #6
Registered: Jul 2004
Location: Manchester, England
Distribution: Gentoo
Posts: 211

Rep: Reputation: 30
Originally Posted by IBall
Will "gnumeric" format be supported in 5 years when the taxman wants to audit me?
It's open source, so even if it isn't being supported you'll still have the information required to enable you to access the documents.
Old 06-18-2006, 02:32 PM   #7
Senior Member
Registered: Mar 2003
Location: Mexico City
Distribution: Fedora, Ubuntu & Mint
Posts: 1,679

Original Poster
Rep: Reputation: 45
As far as I know gnumeric can save into .ods too (just like AbiWord can save into .odt)
Old 07-01-2006, 12:59 PM   #8
Registered: Mar 2004
Location: Canada
Distribution: Slackware current
Posts: 728
Blog Entries: 2

Rep: Reputation: 43
One of the things that has always bothered me about Gnumeric is the handling of blank cells in formulae - they're treated as "1", whereas in Calc they're treated as "0". So if I have a formula that finds a weighted average or somesuch and a value is missing (implying zero in my mind), I have to manually enter "0" in Gnumeric.

Of course this is a matter for debate, as obviously different people feel strongly one way or the other. I believe Excel treats blank cells as 0, Quattro Pro as 1, so for compatibility reasons you might want to investigate this.

Last edited by ciotog; 07-01-2006 at 01:04 PM.
Old 07-01-2006, 02:53 PM   #9
LQ Guru
Registered: Oct 2003
Location: Bonaire, Leeuwarden
Distribution: Debian /Jessie/Stretch/Sid, Linux Mint DE
Posts: 5,191

Rep: Reputation: 1039Reputation: 1039Reputation: 1039Reputation: 1039Reputation: 1039Reputation: 1039Reputation: 1039Reputation: 1039
Calc is fine.

It handles XLS quite well, has many features, many features which Excel has as well, macros, in short a very good replacement for Excel.


Try to make a graph of 3 colums x 512 rows. It takes 45 seconds to get a first graph and another 30 seonds for each redraw. In ver 1.1 that is. I haven't upgraded yet, because Debian want to upgrade another 500 packages when I do so, and that is what *I* do not want.

This behaviour is rediculous, and I have to switch to Gnumeric for these jobs.

Otherwise Calc is just fine.


PS. Yes, I know, I love to use GnuPlot as well. Version 4.1
Old 07-02-2006, 04:10 PM   #10
Registered: Aug 2001
Location: ChristChurch New Zealand
Distribution: Ubuntu
Posts: 351

Rep: Reputation: 78
Ruby + Gnuplot

Do it once in a spreadsheet of your choice.

You might beat me if you are fast and good.

However, for all subsequent reruns of the data I will beat you totally.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
gnumeric / apt allelopath SUSE / openSUSE 7 04-23-2005 11:26 PM
gnumeric gone from RH? molivera Red Hat 1 10-20-2004 10:26 AM
Gnumeric phishman3579 Slackware 3 06-02-2003 06:06 PM
gnumeric griv Linux - Software 0 06-30-2002 12:56 PM
gnumeric ry Linux - Software 1 06-30-2002 12:27 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 01:21 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration