Fedora Linux Support Community & Resources Center
  #1  
Old 15th January 2007, 06:37 PM
pascald Offline
Registered User
 
Join Date: Jan 2007
Location: Blainville/Orne, France
Posts: 33
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.
Reply With Quote
  #2  
Old 15th January 2007, 08:29 PM
brunson Offline
Registered User
 
Join Date: Jun 2005
Location: Westminster, Colorado
Posts: 2,306
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
Quote:
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
Reply With Quote
  #3  
Old 15th January 2007, 10:23 PM
pascald Offline
Registered User
 
Join Date: Jan 2007
Location: Blainville/Orne, France
Posts: 33
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)
Reply With Quote
  #4  
Old 15th January 2007, 10:26 PM
brunson Offline
Registered User
 
Join Date: Jun 2005
Location: Westminster, Colorado
Posts: 2,306
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
Quote:
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
Reply With Quote
  #5  
Old 16th January 2007, 08:42 AM
pascald Offline
Registered User
 
Join Date: Jan 2007
Location: Blainville/Orne, France
Posts: 33
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.
Reply With Quote
  #6  
Old 16th January 2007, 10:31 AM
paul matthijsse Offline
Registered User
 
Join Date: Sep 2005
Location: Dieulefit, France
Posts: 721
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.
Reply With Quote
  #7  
Old 16th January 2007, 03:32 PM
pascald Offline
Registered User
 
Join Date: Jan 2007
Location: Blainville/Orne, France
Posts: 33
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).
Reply With Quote
  #8  
Old 16th January 2007, 05:53 PM
brunson Offline
Registered User
 
Join Date: Jun 2005
Location: Westminster, Colorado
Posts: 2,306
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
Quote:
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
Reply With Quote
  #9  
Old 17th January 2007, 11:54 AM
pascald Offline
Registered User
 
Join Date: Jan 2007
Location: Blainville/Orne, France
Posts: 33
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
File Type: txt Fournisseurs.txt (306.5 KB, 142 views)

Last edited by pascald; 17th January 2007 at 02:10 PM. Reason: Trying to attach a file
Reply With Quote
  #10  
Old 17th January 2007, 01:49 PM
paul matthijsse Offline
Registered User
 
Join Date: Sep 2005
Location: Dieulefit, France
Posts: 721
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.
Reply With Quote
  #11  
Old 17th January 2007, 02:12 PM
pascald Offline
Registered User
 
Join Date: Jan 2007
Location: Blainville/Orne, France
Posts: 33
OK I'll try that. Thanx.
Reply With Quote
  #12  
Old 17th January 2007, 05:07 PM
pascald Offline
Registered User
 
Join Date: Jan 2007
Location: Blainville/Orne, France
Posts: 33
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 ?
Reply With Quote
  #13  
Old 17th January 2007, 05:10 PM
brunson Offline
Registered User
 
Join Date: Jun 2005
Location: Westminster, Colorado
Posts: 2,306
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
Quote:
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
Reply With Quote
  #14  
Old 1st February 2007, 10:04 PM
eelco Offline
Registered User
 
Join Date: Jan 2004
Location: Haarlem, The Netherlands
Posts: 12
In the tools menu, select Plug-ins. Search for 'MS Excel (tm)' in the list, and make sure it is selected. Worked for me.
Reply With Quote
  #15  
Old 5th February 2007, 09:06 PM
pascald Offline
Registered User
 
Join Date: Jan 2007
Location: Blainville/Orne, France
Posts: 33
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.
Reply With Quote
Reply

Tags
excel, files, gnumeric

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
formatting data to excel format ub007 Using Fedora 1 17th May 2009 09:55 PM
xsl output to excel cdlaforc Programming & Packaging 0 30th April 2007 08:19 PM
Samba and Excel Files drewsmith Servers & Networking 2 15th April 2005 05:09 PM
Need to mount a Floppy drive in Excel with Crossover 4.0 backroger Using Fedora 2 2nd December 2004 09:55 AM


Current GMT-time: 19:34 (Thursday, 24-04-2014)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat