LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices


View Poll Results: Which do you use/like the most?
Calc 18 75.00%
Gnumeric 5 20.83%
KSpread 1 4.17%
Voters: 24. You may not vote on this poll

Reply
  Search this Thread
Old 06-16-2006, 04:46 PM   #1
Thetargos
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?

TIA!

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
IBall
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.

--Ian
 
Old 06-17-2006, 12:31 PM   #3
Cogar
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: 52
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
noranthon
Member
 
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
Member
 
Registered: Nov 2003
Distribution: Mandriva
Posts: 441

Rep: Reputation: 31
Quote:
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
UK MAdMaN
Member
 
Registered: Jul 2004
Location: Manchester, England
Distribution: Gentoo
Posts: 211

Rep: Reputation: 30
Quote:
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
Thetargos
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
ciotog
Member
 
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
jlinkels
LQ Guru
 
Registered: Oct 2003
Location: Bonaire, Leeuwarden
Distribution: Debian /Jessie/Stretch/Sid, Linux Mint DE
Posts: 5,195

Rep: Reputation: 1043Reputation: 1043Reputation: 1043Reputation: 1043Reputation: 1043Reputation: 1043Reputation: 1043Reputation: 1043
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.

But...

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.

jlinkels.

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

Rep: Reputation: 87
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.
 
Old 05-25-2023, 08:37 AM   #11
newbie-02
LQ Newbie
 
Registered: May 2023
Posts: 1

Rep: Reputation: 0
@ciotog
> 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".
sorry for late reply ;-) but not to mislead others: spreadsheets don't account empty cells for some / most statistical functions, LO Calc as well as gnumeric, you might have been trapped by a feature in LO Calc displaying cells with result '0' as blank.
 
Old 05-25-2023, 10:32 AM   #12
DavidMcCann
LQ Veteran
 
Registered: Jul 2006
Location: London
Distribution: PCLinuxOS, Debian
Posts: 6,130

Rep: Reputation: 2302Reputation: 2302Reputation: 2302Reputation: 2302Reputation: 2302Reputation: 2302Reputation: 2302Reputation: 2302Reputation: 2302Reputation: 2302Reputation: 2302
i use Calc, but only as a sort of database. The only real spreadsheet I have is a budgeting application I wrote for Psion Exchange's Abacus. I still use it with a QL emulation program — I can barely remember how the formulae work, so I'm certainly not going to try converting them!
 
Old 05-25-2023, 10:47 AM   #13
rclark
Member
 
Registered: Jul 2008
Location: Montana USA
Distribution: KUbuntu, Fedora (KDE), PI OS
Posts: 450

Rep: Reputation: 171Reputation: 171
Calc works just fine for my needs. But I don't do anything fancy either. For example, I use it to keep track of my vehicle(s) maintenance records. So simply formula usage (average oil change period, etc.) .
 
Old 05-25-2023, 12:23 PM   #14
fatmac
LQ Guru
 
Registered: Sep 2011
Location: Upper Hale, Surrey/Hants Border, UK
Distribution: Mainly Devuan with some Tiny Core, Fatdog, Haiku, & BSD thrown in.
Posts: 5,427

Rep: Reputation: Disabled
I tend to use Calc as a convenience, although sc/sc-im would work just as well for me though....
 
Old 05-25-2023, 02:00 PM   #15
petelq
Member
 
Registered: Aug 2008
Location: Yorkshire
Distribution: openSUSE(Leap and Tumbleweed) and a (not so) regularly changing third and fourth
Posts: 627

Rep: Reputation: Disabled
You do realise, until today the last post on this thread was 2/6/2006 and Openoffice calc and particularly Libreoffice calc have come a long way since 2006. I've never used gnumeric.

Last edited by petelq; 05-25-2023 at 02:03 PM.
 
  


Reply


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

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 06:07 AM.

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