Ubuntu
gnumeric package

gnumeric can't read formule from a gnumeric file create with gnumeric windows

Bug #45342 reported by humufr
8
Affects Status Importance Assigned to Milestone
gnumeric (Ubuntu)
Invalid
Medium
Ubuntu Desktop Bugs

Bug Description

I tried to open a file create with gnumeric windows and save in gnumeric format. The same file open on linux loose the result of the formula

average or stdev gave the same result:

#NOM?

In the actual state gnumeric on dapper can't be used, formula not working and graph not working

Revision history for this message
humufr (humufr-deactivatedaccount) wrote :

just to try I installed gnumeric-gtk instead of gnumeric and everything is working fine now

Revision history for this message
Daniel Holbach (dholbach) wrote :

Thanks for your bug report. Can you attach the file in question?

Changed in gnumeric:
assignee: nobody → desktop-bugs
status: Unconfirmed → Needs Info
Revision history for this message
humufr (humufr-deactivatedaccount) wrote : bug with package gnumeric and formula

Like I told before the bug seems to be in the package gnumeric itself (gnumeric-gnome?) because everything is working fine with the package gnumeric-gtk.

Revision history for this message
Daniel Holbach (dholbach) wrote :

Hum, I can generate a nice diagram from it.

Revision history for this message
humufr (humufr-deactivatedaccount) wrote : gnumeric package and average function
Download full text (7.9 KiB)

error messages

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/core/defaultfont/size'

** (gnumeric:29055): WARNING **: Using default value '10'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/core/defaultfont/bold'

** (gnumeric:29055): WARNING **: Using default value 'false'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/core/defaultfont/italic'

** (gnumeric:29055): WARNING **: Using default value 'false'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/core/file/history/n'

** (gnumeric:29055): WARNING **: Using default value '4'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/plugins/activate-new'

** (gnumeric:29055): WARNING **: Using default value 'true'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/core/gui/screen/horizontaldpi'

** (gnumeric:29055): WARNING **: Using default value '96'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/core/gui/screen/verticaldpi'

** (gnumeric:29055): WARNING **: Using default value '96'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/core/workbook/n-sheet'

** (gnumeric:29055): WARNING **: Using default value '3'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/core/gui/window/x'

** (gnumeric:29055): WARNING **: Using default value '0.6'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/core/gui/window/y'

** (gnumeric:29055): WARNING **: Using default value '0.6'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/core/gui/window/zoom'

** (gnumeric:29055): WARNING **: Using default value '1'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/core/gui/editing/autocomplete'

** (gnumeric:29055): WARNING **: Using default value 'true'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/core/gui/editing/livescrolling'

** (gnumeric:29055): WARNING **: Using default value 'true'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/printsetup/center-horizontally'

** (gnumeric:29055): WARNING **: Using default value 'false'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/printsetup/center-vertically'

** (gnumeric:29055): WARNING **: Using default value 'false'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/printsetup/print-grid-lines'

** (gnumeric:29055): WARNING **: Using default value 'false'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/printsetup/print-even-if-only-styles'

** (gnumeric:29055): WARNING **: Using default value 'false'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/printsetup/print-black-n-white'

** (gnumeric:29055): WARNING **: Using default value 'false'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/printsetup/print-titles'

** (gnumeric:29055): WARNING **: Using default value 'false'

** (gnumeric:29055): WARNING **: Unable to load key '/apps/gnumeric/printsetup/across-then-down'

** (gnumeric:29055): WARNING **: Using default value 'false'

** (gnumeric:29055): WARNING **: Unable to load key '/app...

Read more...

Revision history for this message
humufr (humufr-deactivatedaccount) wrote : gnumeric-gtk package and average function

no error message

Revision history for this message
Daniel Holbach (dholbach) wrote :

Jani, Gauvain - any idea?

Revision history for this message
Jani Monoses (jani) wrote :

heh we just packaged gnumeric-gtk, have no idea what's inside ;)
the no error message is understandable as gnumeirc-gtk does not use gconf at all so does not warn if some keys are missing. But the difference in results I am not sure.

Revision history for this message
Gauvain Pocentek (gpocentek) wrote :

I've tested the file with gnumeric/gnumeric-gtk using libgoffice and libgoffice-gtk for both, I can read the file correctly each time.

Revision history for this message
humufr (humufr-deactivatedaccount) wrote :

the thing is that I don't have any problem with gnumeric-gtk. The problems are with the package gnumeric. It's not a big deal for me because I found the workaround by install gnumeric-gtk but there are something strange at least for me with gnumeric.

Revision history for this message
Sebastien Bacher (seb128) wrote :

what version of gnumeric do you use? your example opens fine with gnumeric 1.7.2-1ubuntu1 on my desktop

Revision history for this message
humufr (humufr-deactivatedaccount) wrote :

I'm not surprised, it's working for me too but 1.7.2 is not the versions in dapper or edgy. The gnumeric version in dapper or in edgy are not good and it's a problem with the package because when I compiled them myself with the archive from gnumeric website, eveyrthing is working (version 1.7.0 or higher).
Now I'm using a version I compiled myself on edgy (I upgraded when edgy became official but gnumeric does have some very nasty bug at this time).

Revision history for this message
Daniel Holbach (dholbach) wrote :

Thanks for following up, closing the bug.

Changed in gnumeric:
status: Needs Info → Rejected
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.