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 72459 - sign change in formula bar.
sign change in formula bar.
Status: VERIFIED INCOMPLETE
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
1.0.x
Other Linux
: Normal trivial
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2002-02-24 22:40 UTC by Mark Copper
Modified: 2009-08-15 18:40 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
example (14.00 KB, application/octet-stream)
2002-02-25 02:12 UTC, Mark Copper 		Details

Description Mark Copper 2002-02-24 22:40:07 UTC 
Save Gnumeric sheet to Excel format.  Open with Gnumeric.  Formula bar
shows negative entries with "+" sign instead of "-" although the number is
displayed in the cell as negative and seems to be treated internally as such.
I'm glad to link you to an example if you like, but it should be easy to
reproduce if I'm not completely deluded.
Comment 1 Jody Goldberg 2002-02-25 01:38:44 UTC 
More detail please.
If I fire up 1.0.4 and enter
'-20' without quotes in A1
save it as xls
then reload
I see '-20' without quotes in the cell and on the editline
Comment 2 Mark Copper 2002-02-25 02:12:05 UTC 
Created attachment 6852 [details]
example
Comment 3 Jody Goldberg 2002-02-25 03:12:11 UTC 
Got it.  There was a typo in the XL exporter that swapped the unary positive
and negative.  Fixed in both branches.  The patch will be in 1.0.5 due next
weekend.