Help - Search - Members - Calendar
Full Version: Gnumeric On Eabi
OESF Forums > Distros, Development, and Model Specific Forums > Distro Support and Discussion > Debian
Chero
Hi,

I've got a problem with gnumeric on eabi :
When importing an xls (95) I get the following message :
**(gnumeric:26547): CRITICAL **: workbook_iteration_tolerance: assertion 'tolerance >= 0' failed

(26547 is the process number - the real error are the iterations)
All the "number" cells have strange values. (e.g. 0:30 changes to 0:02) and all reals change really high numbers (E8 or E12).

Anyone has noticed this ?
Anyone has a clue ?

It seems to be an old problem rising again : http://mail.gnome.org/archives/gnumeric-li...y/msg00027.html

This doesn't happen on oabi (Titchy).

sad.gif
Chero.
jpmatrix
QUOTE(Chero @ Nov 11 2007, 07:55 PM) *
Hi,

I've got a problem with gnumeric on eabi :
When importing an xls (95) I get the following message :
**(gnumeric:26547): CRITICAL **: workbook_iteration_tolerance: assertion 'tolerance >= 0' failed

(26547 is the process number - the real error are the iterations)
All the "number" cells have strange values. (e.g. 0:30 changes to 0:02) and all reals change really high numbers (E8 or E12).

Anyone has noticed this ?
Anyone has a clue ?

It seems to be an old problem rising again : http://mail.gnome.org/archives/gnumeric-li...y/msg00027.html

This doesn't happen on oabi (Titchy).

sad.gif
Chero.


i've tried to import an xls from excel and got the same problem
however i've tried an xls from openoffice and it seems good...
dlj0
QUOTE(jpmatrix @ Nov 11 2007, 05:14 PM) *
QUOTE(Chero @ Nov 11 2007, 07:55 PM) *
Hi,

I've got a problem with gnumeric on eabi :
When importing an xls (95) I get the following message :
**(gnumeric:26547): CRITICAL **: workbook_iteration_tolerance: assertion 'tolerance >= 0' failed

(26547 is the process number - the real error are the iterations)
All the "number" cells have strange values. (e.g. 0:30 changes to 0:02) and all reals change really high numbers (E8 or E12).

Anyone has noticed this ?
Anyone has a clue ?

It seems to be an old problem rising again : http://mail.gnome.org/archives/gnumeric-li...y/msg00027.html

This doesn't happen on oabi (Titchy).

sad.gif
Chero.


i've tried to import an xls from excel and got the same problem
however i've tried an xls from openoffice and it seems good...


I finally got around to checking this. I have the same problem, and it also shows up on *.xls files made by gnumeric (at least those from a different machine, and maybe a year or so ago). It seems that random entries, those with formulas and maybe some pure data entries, get messed up.

*.gnumeric files, even older ones, seem to display just fine.
Chero
problem solved by new packages compiled by ZDevil !!!

Upload will probably follow soon.

I'm a happy guy now and ZDevil saved my Z from being reflashed with titchy !!! laugh.gif

Having fun,
Chero.
dlj0
QUOTE(Chero @ Nov 20 2007, 03:44 PM) *
problem solved by new packages compiled by ZDevil !!!

Upload will probably follow soon.

I'm a happy guy now and ZDevil saved my Z from being reflashed with titchy !!! laugh.gif

Having fun,
Chero.


Where are these? BTW, as a workaround, if you have another machine with gnumeric, you can load your xls files in it, save them as gnumeric format, and they work properly on the Z. But a better solution would be nice.
ZDevil
The packages will be up really soon. Now only waiting for smplayer to get packaged.
ZDevil
Uploaded. Please note that you also need the patched libgsf package to enable importing from Microsoft Excel.
Enjoy.
dlj0
QUOTE(ZDevil @ Nov 21 2007, 05:48 PM) *
Uploaded. Please note that you also need the patched libgsf package to enable importing from Microsoft Excel.
Enjoy.


Thanks. It works perfectly. We should have you have a go with iceweasel and icedove.
ZDevil
In fact I tried Iceweasel 2.0.0.9 some time ago. The build still suffered from the same mysterious seg fault without any further error message, even with the debugging package. Is there any pointer or patch to refer to? I will surely try again if there are workarounds. smile.gif
jpmatrix
QUOTE(ZDevil @ Nov 22 2007, 10:56 AM) *
In fact I tried Iceweasel 2.0.0.9 some time ago. The build still suffered from the same mysterious seg fault without any further error message, even with the debugging package. Is there any pointer or patch to refer to? I will surely try again if there are workarounds. smile.gif


yes it is very curious because iceweasel was working just great under Debian OABI ..........
apink
I am trying to get gnumeric working on debian. It is a must have for me, otherwise it is back to pdax.

I have tried several things: I successfully did apt-get gnumeric using the oregon state debian feed and manually installing an older version of gnumeric-common before installing gnumeric. But then it didn't work. The program would not recognize the "1" key blink.gif and did haywire other things.

I have tried installing ZDevil's packages, but cannot get past the libgoffice depends. apt-get reports that libgoffice-0-5 version 0.5.2 or above is required, but that version 0.5.1-2 is to be installed. I have searched the repositories for libgoffice-0-5 version 0.5.2 with no luck. I can find libgoffice-0-6 but that does not satisfy apt-get. I have tried to do apt-get install -f gnumeric but get nowhere there also.

I am sure that this is a newbie mistake as I am a tried and true newbie. Any help would be greatly appreciated.
ZDevil
This seems to be a known bug in GNOME:
http://ubuntuforums.org/showthread.php?p=3777542#post3777542

I also run into a strange issue in epiphany and galeon when the num key "1" launches the help browser.

Tried the fix here: http://bugzilla.gnome.org/show_bug.cgi?id=500881 , but i can only see "1" echo as a screen output in the terminal (when gumeric is launched from the terminal) but does not actually insert "1" in gnumeric.

Any idea? :-?
ZDevil
Hey! This seems to work!

First install yelp (the gnome helper) if you didn't: apt-get install yelp

Second do this:
CODE
sudo mv /usr/bin/yelp /usr/bin/yelp1
sudo echo "xmodmap -e 'keysym 0x31 = 1'" > /usr/bin/yelp
sudo chmod 755 /usr/bin/yelp


Now the key "1" is recognized and is inserted as usual in gumeric.
ZDevil
Another update:

Don't use my packages. Now armel lenny has all the right packages in place.
So change your /etc/apt/sources.list to the official lenny feeds (see below), followed by a apt-get update
Next first apt-get remove libgoffice*
Then apt-get install gnumeric.
Apply the trick in post #13, if "1" is not recognized (but I got it working without the trick). That's it!

I've tested gnumeric 1.8.1 and it works great. wink.gif

Here is the feed I use. Quite stable and fast.
CODE
deb http://debian.ethz.ch/debian/ lenny main contrib non-free
apink
QUOTE(ZDevil @ Mar 21 2008, 08:17 AM) *
Another update:

Don't use my packages. Now armel lenny has all the right packages in place.
So change your /etc/apt/sources.list to the official lenny feeds (see below), followed by a apt-get update
Next first apt-get remove libgoffice*
Then apt-get install gnumeric.
Apply the trick in post #13, if "1" is not recognized (but I got it working without the trick). That's it!

I've tested gnumeric 1.8.1 and it works great. wink.gif

Here is the feed I use. Quite stable and fast.
CODE
deb http://debian.ethz.ch/debian/ lenny main contrib non-free


Thanks for the fixes. Both work tongue.gif and I am using the debian.ethz.ch feed gnumeric.

Now some smaller gnumeric bugs that have popped up. When I enter a 4 for the first character in a cell the cell is filled with the previous value that I entered, wherever that may have been, as if I had entered the paste command. I can get around this by entering "4" as "04". Similarly when I enter a 9 for the first character in a cell nothing happens that I have detected. No 9 and no nothin else. "09" works here also, that is if the first character is not a 4 or a 9 then any succeeding characters can be a 4 or a 9. Interesting. dry.gif

I had noticed the bug with the 4 in previous gnumeric versions I was using on Lenny. I don't know if the 9 bug is new or was there also. This behavior is similar to the problem with the 1, so I would think that a kludge fix such as echo "xmodmap -e 'keysym 0x31 = 1'" > /usr/bin/yelp would do. Except yelp is not involved in this one. Any ideas are appreciated.

This is not a deal breaker for me but an annoyance I could live without.
ZDevil
According to the gnumeric doc,
F4 = repeat the last action
F9 = recalculate

I suspect the num key 4 also got confused with F4, like 1 and F1. But I am not sure about 9.
There seems to be no way to customize the keyboard shortcuts in gnumeric, or not?
ZDevil
Another very dirty hack (into yelp). This will make sure "1" "4" and "9" behave themselves in gnumeric...

First, edit /usr/bin/yelp like this:
CODE
xmodmap -e 'keysym 0x31 = 1'
xmodmap -e 'keysym 0x34 = 4'
xmodmap -e 'keysym 0x39 = 9'

Second, start gnumeric from the terminal by "yelp && gnumeric".
It works at least...
I know this is terribly ugly.
Perhaps we need file a bug report somewhere (debian armel, gnumeric, gnome)?

[EDIT]
Editing /usr/share/applications/gnumeric.desktop like this does NOT work (no effect; num keys remain naughty until "1" is pressed)
CODE
Exec=yelp && gnumeric

Had a look at http://standards.freedesktop.org/desktop-e...#exec-variables , but cannot find useful info.
apink
This works just fine. I start my spreadsheets from a script so it is no extra work except to put yelp && into the script.

I have also been wondering about filing a bug report, but am intimidated by the whole process: never done it before, don't know where it should go, unsure of who is in charge of debian on the zaurus . . .
ZDevil
I guess the simplest way for now is: edit the yelp script as posted. Then press "1" (i.e. to run the hacked "yelp") once inside gnumeric and then things will run fine for the whole session.
urkden
With newest 1.8.2-1 gnumeric from debian official the problem persists.
ZDevil
Enchanced fix. Again, rename the original "/usr/bin/yelp" to something else, e.g. "/usr/bin/yelp.orig" (you need to install the yelp package first), and then create a new /usr/bin/yelp file with this content:
CODE
#!/bin/sh
xmodmap -e 'keysym 0x31 = 1 exclam'
xmodmap -e 'keysym 0x34 = 4 dollar'
xmodmap -e 'keysym 0x39 = 9 parenright'

Save and then do "chmod 755 /usr/bin/yelp".
After opening gnome applications, like gnumeric and epiphany browser, press [1] once. This should make [1], [4], [9] produce "1", "4" and "9", and Shift [1], [4], [9] to produce "!", "$", ")" respectively. i.e. the normal behavior. wink.gif
I have just tested the number keys [1]-[0], all keys are working with the right symbols with [Shift].
Please test to see if any other key are misbehaving. I will then make/include this into a new scriptpack and let users just run a simple "./install.sh" to fix this.
ArchiMark
QUOTE(ZDevil @ Apr 2 2008, 10:56 PM) *
Enchanced fix. Again, rename the original "/usr/bin/yelp" to something else, e.g. "/usr/bin/yelp.orig" (you need to install the yelp package first), and then create a new /usr/bin/yelp file with this content:
CODE
#!/bin/sh
xmodmap -e 'keysym 0x31 = 1 exclam'
xmodmap -e 'keysym 0x34 = 4 dollar'
xmodmap -e 'keysym 0x39 = 9 parenright'

Save and then do "chmod 755 /usr/bin/yelp".
After opening gnome applications, like gnumeric and epiphany browser, press [1] once. This should make [1], [4], [9] produce "1", "4" and "9", and Shift [1], [4], [9] to produce "!", "$", ")" respectively. i.e. the normal behavior. wink.gif
I have just tested the number keys [1]-[0], all keys are working with the right symbols with [Shift].
Please test to see if any other key are misbehaving. I will then make/include this into a new scriptpack and let users just run a simple "./install.sh" to fix this.


ZDevil,

Just tried doing your fix....

However, have a real problem here to do it as not only can I not type a '1' now but if I try to type a '!' it also opens up the 'Terminal Emulator' window that I mentioned in my post on the other thread....

So, any way to get around this situation??? Or will I need to wait for your script???

Yipes!!!

blink.gif
ZDevil
QUOTE(ArchiMark @ Apr 3 2008, 07:25 PM) *
Just tried doing your fix....
However, have a real problem here to do it as not only can I not type a '1' now but if I try to type a '!' it also opens up the 'Terminal Emulator' window that I mentioned in my post on the other thread....
So, any way to get around this situation??? Or will I need to wait for your script???

In this case just use another terminal. The xfce4 terminal and gnome terminal are slow and bulky, and I won't recommend them on the Z (and on laptops as well) even if there is no such issue. There are many more much better choices: rxvt, mrxvt, mlterm, multi-aterm, to name but a few.
ArchiMark
QUOTE(ZDevil @ Apr 3 2008, 12:00 PM) *
QUOTE(ArchiMark @ Apr 3 2008, 07:25 PM) *
Just tried doing your fix....
However, have a real problem here to do it as not only can I not type a '1' now but if I try to type a '!' it also opens up the 'Terminal Emulator' window that I mentioned in my post on the other thread....
So, any way to get around this situation??? Or will I need to wait for your script???

In this case just use another terminal. The xfce4 terminal and gnome terminal are slow and bulky, and I won't recommend them on the Z (and on laptops as well) even if there is no such issue. There are many more much better choices: rxvt, mrxvt, mlterm, multi-aterm, to name but a few.


THANKS for the help, ZDevil.....installed mrxvt and then number '1' and '!' key worked great!!

laugh.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.