Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Gnumeric vs OO.o Calc opinions

  1. #1
    Join Date
    Jan 2008
    Location
    Auckland, New Zealand
    Beans
    3,131
    Distro
    Ubuntu 9.10 Karmic Koala

    Gnumeric vs OO.o Calc opinions

    I've just started trying out Gnumeric and like what I see so far. The graphing tool makes it easy to create and configure good looking plots and I really like that you can just right click on a plot and export it as an image. I've also heard that it is a lot more accurate as it uses code from R for much of its calculations. I'm interested in other people's opinions on using Gnumeric over other applications like OpenOffice Calc. What do you use and why?

    Cheers,
    Adam

  2. #2
    Join Date
    Aug 2007
    Location
    La Plata
    Beans
    111
    Distro
    Ubuntu 7.10 Gutsy Gibbon

    Re: Gnumeric vs OO.o Calc opinions

    Gnumeric is my spreadsheet application of choice. It looks good on Gnome (unlike OO), it's fast (much faster than OO) and accurate, and has all the functionality I need.

  3. #3
    Join Date
    Jan 2008
    Location
    Auckland, New Zealand
    Beans
    3,131
    Distro
    Ubuntu 9.10 Karmic Koala

    Re: Gnumeric vs OO.o Calc opinions

    Thanks, yeah I'm thinking I'll stick with Gnumeric. The speed is definitely noticeable.

  4. #4
    Join Date
    Nov 2006
    Location
    Jo'burg, South Africa
    Beans
    434
    Distro
    Ubuntu 11.10 Oneiric Ocelot

    Re: Gnumeric vs OO.o Calc opinions

    I find that I sometimes have to use a combination of gnumeric and calc, though I think gnumeric is better (faster, analysis options, etc.) for most tasks. I can't actually remember why I sometimes need Calc...

  5. #5
    Join Date
    Jun 2008
    Beans
    287

    Re: Gnumeric vs OO.o Calc opinions

    For my two cents Gnumeric is superior.

    However I have found OO Calc to be slightly better at importing unusual excel sheets. Unfortunately I also find OO Calc to be slower and very crashy, thou admittedly it does generally recover your work after crashing.

    Still, I would guess I caused about 15 crashes in the first two days I used it in version 2. This was the show stopper for me. Possibly the new version is better.
    I suffer from web impatience. You have 5 seconds to amaze me.

  6. #6
    Join Date
    Jun 2008
    Location
    Singapore
    Beans
    160

    Re: Gnumeric vs OO.o Calc opinions

    I was getting very fed up with the time Calc used to take to work on large spreadsheets. I nearly went back to Excel which is much faster ... until I checked in this forum and discovered gnumeric. Fantastic!

    Thank you all..

  7. #7
    Join Date
    Nov 2008
    Location
    Saskatoon, SK, Canada
    Beans
    7
    Distro
    Ubuntu 9.10 Karmic Koala

    Re: Gnumeric vs OO.o Calc opinions

    I also prefer gnumeric for all the above reasons. However it has a couple of deficiencies
    a) lack of pivot tables/ data pilot, and
    b) screwed up filters.

    The lack of a data pilot is unfortunate, but the way the filter is screwed up is awful. If you copy filtered data, or if you refer to a filtered range in a formula, you still get the original data. It's useless.

    Apart from that gnumeric is much preferable. I just wish I could change the graph defaults (line widths, fonts etc.)

  8. #8
    Join Date
    Nov 2006
    Location
    New Zealand
    Beans
    422

    Re: Gnumeric vs OO.o Calc opinions

    I find Gnumeric is the best option for working with .csv files, it opens them easily for you to edit rather than having to go through an import process. However if you are entering a lot of data and press enter, it just takes you down one cell, while OO (and Excel) will take you back to the start of the row, or wherever you last tabbed from. This is far more convenient. So as I generally use spreadsheets only for data entry (using R for manipulation and analysis) I tend to stick to OO unfortunately.

  9. #9
    Join Date
    Apr 2009
    Location
    USA
    Beans
    80
    Distro
    Ubuntu 10.04 Lucid Lynx

    Re: Gnumeric vs OO.o Calc opinions

    I like Gnumeric, because it enables to save charts with a right-click as a Postscript, which can be imported into Scribus. It makes it a really good combo for scientific desktop publishing.

  10. #10
    Join Date
    May 2009
    Beans
    113

    Re: Gnumeric vs OO.o Calc opinions

    I will take octave over any spreadsheet, any day.

    Force = Mass * Acceleration

    reads much better than.

    $C$1:100 = $A$1:100 * $B$1:100

    I know all about named ranges, but for scientific computing, I always recommend staying away from spreadsheets.

Page 1 of 2 12 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •