<---- template headericclude ----->
gnumeric and excel files
FedoraForum.org - Fedora Support Forums and Community
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    pascald Guest

    Cool gnumeric and excel files

    Hi,
    I noticed today that gnumeric (version I don't know because the About entry of the help menu does not work) is not able to open MS excel files . In the help menu it is sait however that it is possible. And I used to do it when I was using ubuntu. The extension is not even in the file extension list in the file type combobox of the open menu.
    Please do not tell me it is the strict obedience to the GPL that forbid this (MS excel file format is non free I guess).
    The reason I want to use it is that it manages the deviation bars much better that OOo calc...
    Any help appreciated.

  2. #2
    Join Date
    Jun 2005
    Location
    Westminster, Colorado
    Posts
    2,306
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Find and excel file, right click, open "Properties", choose the "Open With" tab, click "Add", select "Gnumeric", "Add", "Close".
    Registered Linux User #4837
    411th in line to get sued by Micro$oft
    Basically, to learn Unix you learn to understand and apply a small set of key ideas and achieve expertise by expanding both the set of ideas and your ability to apply them - Paul Murphy

  3. #3
    pascald Guest
    Quote Originally Posted by brunson
    Find and excel file, right click, open "Properties", choose the "Open With" tab, click "Add", select "Gnumeric", "Add", "Close".
    I tried your suggestion but unfortunately the "Add" option of the "Open with" tab might mean add another apllication to open such a file type because a list pops up in which I did not choose anithing else since there wasn't gnumeric. Anyway even by selecting the gnumeric option in the "Open with" tab, I still get the "File format not supported" (translated from thefrench message but you should get the meaning)

  4. #4
    Join Date
    Jun 2005
    Location
    Westminster, Colorado
    Posts
    2,306
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yes, I did misunderstand your question. What version of gnumeric do you have installed?
    Code:
    $ rpm -q gnumeric
    gnumeric-1.6.3-5.fc6
    Registered Linux User #4837
    411th in line to get sued by Micro$oft
    Basically, to learn Unix you learn to understand and apply a small set of key ideas and achieve expertise by expanding both the set of ideas and your ability to apply them - Paul Murphy

  5. #5
    pascald Guest
    here is what I get :
    $ rpm -q gnumeric
    gnumeric-1.6.3-5.fc6
    same as you I see. Strange , isn't it ? I guess (from your interest) that you don't have this problem.

  6. #6
    Join Date
    Sep 2005
    Location
    Dieulefit, France
    Posts
    721
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by pascald
    Anyway even by selecting the gnumeric option in the "Open with" tab, I still get the "File format not supported" (translated from thefrench message but you should get the meaning)
    Can you open that Excel file in OOcalc? If yes, try to save it in another, more Linux friendly format. If not, perhaps the original file is corrupt? Can you open it in MS Excel, if available?

    Paul.

  7. #7
    pascald Guest
    I can open the file with OOo and it looks like in excel (not available on my laptop).
    The point of using gnumeric is that I think it makes a better use of the excel spreadsheet than OOo (at least for the moment), expecially for the graphs and it handles the error bars (deviation) where OOo doesn't (I do not consider what Calc does as handling error bars).

  8. #8
    Join Date
    Jun 2005
    Location
    Westminster, Colorado
    Posts
    2,306
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have no problem opening an excel file in gnumeric. Maybe it's a problem with the specific excel file. Is it from a particularly new version of excel, like Office 2007 or something? If you want to send me the file I can try to open it. Also, try "rpm -V gnumeric" to make sure your installation didn't get messed up.
    Registered Linux User #4837
    411th in line to get sued by Micro$oft
    Basically, to learn Unix you learn to understand and apply a small set of key ideas and achieve expertise by expanding both the set of ideas and your ability to apply them - Paul Murphy

  9. #9
    pascald Guest
    Hi,
    I tried the command you suggest as root: no problem.
    What puzzles me is that the possiblity of opening excel file is not even present i.e. the .xls is not in the extension list of the open file - file type menu.
    I only have 5 choices between: automatic detection, CSV/TSV, XML(*.gnumeric), SAX(*.gnumeric) and text

    Edit :
    I just switched to ubuntu on my laptop and looked at gnumeric there. The version is 1.6.3 That's it. No -5 or whatever. I could get this version number from the About in the Help menu which doesn't work with my FC6. Also I noticed that not only .xls files are in the list of file types that can be imported but there were many more. Did you look on your gnumeric how many file types you have in this list ? The file I attach is open with no problem with gnumeric in ubuntu (meaning I don't think the problem comes from the file)

    Edit (second):
    The attachment didn't work so I changed the extension of the file to .txt but it is a .xls file
    Attached Files Attached Files
    Last edited by pascald; 17th January 2007 at 03:10 PM. Reason: Trying to attach a file

  10. #10
    Join Date
    Sep 2005
    Location
    Dieulefit, France
    Posts
    721
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi, I think you best reinstall gnumeric. I have this program running on FC6 without all the problems you mention. The About-thing says Gnumeric 1.6.3 and it can open many spreadsheet (15 or so) types, including Excel's xls. When I type "yum info gnumeric" it gives the same version number 1.6.3 and says that it is release 5.fc6.

    So just reinstall.

    Cheers, Paul.

  11. #11
    pascald Guest
    OK I'll try that. Thanx.

  12. #12
    pascald Guest
    I removed then re-installed gnumeric with the "Applications menu->Add/remove applications" (under gnome). It didn't work.
    Then I did it again with yum in a console. It still does not work.
    What's left ?

  13. #13
    Join Date
    Jun 2005
    Location
    Westminster, Colorado
    Posts
    2,306
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I think your next step would have to be finding a Gnumeric forum and asking someone with in depth knowledge of gnumeric file handling. They'll probably be able to tell you what is missing or broken, then figure out is it's something you did to your system or a bug i the package. If it's the latter, a report to the rpm maintainer would be in order.
    Registered Linux User #4837
    411th in line to get sued by Micro$oft
    Basically, to learn Unix you learn to understand and apply a small set of key ideas and achieve expertise by expanding both the set of ideas and your ability to apply them - Paul Murphy

  14. #14
    Join Date
    Jan 2004
    Location
    Haarlem, The Netherlands
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    In the tools menu, select Plug-ins. Search for 'MS Excel (tm)' in the list, and make sure it is selected. Worked for me.

  15. #15
    pascald Guest
    Thank you eelco. That was it.
    I feel stupid. Since it worked in ubuntu and Suse I did not even look in the menus to find out if there was a solution to my problem.

Page 1 of 2 12 LastLast

Similar Threads

  1. formatting data to excel format
    By ub007 in forum Using Fedora
    Replies: 1
    Last Post: 17th May 2009, 09:55 PM
  2. xsl output to excel
    By cdlaforc in forum Programming & Packaging
    Replies: 0
    Last Post: 30th April 2007, 08:19 PM
  3. Samba and Excel Files
    By drewsmith in forum Servers & Networking
    Replies: 2
    Last Post: 15th April 2005, 05:09 PM
  4. Replies: 2
    Last Post: 2nd December 2004, 10:55 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
[[template footer(Guest)]]