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 142474 - gnumeric display text as red in the number format
gnumeric display text as red in the number format
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: General
git master
Other Linux
: Normal major
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2004-05-13 17:00 UTC by Frederic Parrenin
Modified: 2006-09-15 18:32 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
The .xls file that shows the problem. (6.50 KB, application/msexcel)
2004-05-13 17:01 UTC, Frederic Parrenin 		Details

Description Frederic Parrenin 2004-05-13 17:00:56 UTC 
Steps to reproduce the problem:
- open the .xls file I will attach
=> the text in the A1 cell appears red
- try to open the same file in XL
=> the same text appears black

This has to do with the number format used.
Texts are displayed the same color than negative number with this format in
gnumeric.
I don't know if it is an import/export bug or a gnumeric bug.
(Note: This .xls file has been produced by gnumeric).
Comment 1 Frederic Parrenin 2004-05-13 17:01:34 UTC 
Created attachment 27674 [details]
The .xls file that shows the problem.
Comment 2 Andreas J. Guelzow 2004-05-13 17:12:01 UTC 
This has nothing to do with XL import/export. We seem to be defaulting to the
font colours for negative values. I think we should use the ones set-up for `0'.

This bug is also in cvs HEAD.
Comment 3 Jody Goldberg 2004-05-15 13:29:34 UTC 
A quick test workbook suggests that we should not be using the last element as
the catch all.  Numbers use the first element, others revert to general.  I also
noted that booleans match as strings, and errors don't match at all.

patched and backported.
Comment 4 P. K. CHAN, Esq. 2006-08-10 10:27:35 UTC 
Is this issue really fixed?  I can still see text formatted in red in the spplied test case when opened in 1.6.3.
Comment 5 Andreas J. Guelzow 2006-08-10 14:12:08 UTC 
just for the record: in gnumeric 1.6.0 the text in the sample file displays as black. So the bug was fixed. This does not mean that it may not be back in 1.6.3....
Comment 6 P. K. CHAN, Esq. 2006-08-11 02:45:27 UTC 
Thank you for the information.  So should I post a new bug for 1.6.3?  As I do not have the privilege to reopen this issue.
Comment 7 Andreas J. Guelzow 2006-08-11 06:26:09 UTC 
I can confirm that this bug is back in 1.6.3 and also in current cvs HEAD.
Comment 8 Morten Welinder 2006-09-15 18:32:00 UTC 
Fixed in the development version. The fix will be available in the next major release. Thank you for your bug report.