After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 166492 - SUMIF: comma added after save as .xls
SUMIF: comma added after save as .xls
Status: VERIFIED INCOMPLETE
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
1.4.x
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
: 166498 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2005-02-06 21:17 UTC by Helmut Wollmersdorfer
Modified: 2009-08-15 18:40 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Helmut Wollmersdorfer 2005-02-06 21:17:44 UTC 
Version details: 1.4.1
Distribution/Version: Debian/Sarge

- Take an empty sheet
- put a formula like this into a cell
  =sumif(offset($D$6:$F$8,C15,C16),"<10")
- save file as .gnumeric
- exit Gnumeric
- reopen the file
- save as .xls
- exit and reopen
- now the cell will show an error "#VALUE!"
  and the formula changed to
  =sumif(offset($D$6:$F$8,C15,C16),"<10",)

The same seems to occur, if a .xls produced with XL or OO is saved by Gnumeric.

Helmut Wollmersdorfer
Comment 1 Jody Goldberg 2005-02-08 21:35:37 UTC 
Please try with 1.4.2
I'm pretty sure this was fixed.
Comment 2 Morten Welinder 2005-02-09 16:08:19 UTC 
Appears fixed (2005-01-16  Jody Goldberg <jody@gnome.org>)
Comment 3 Morten Welinder 2005-02-09 16:12:13 UTC 
*** Bug 166498 has been marked as a duplicate of this bug. ***