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 306411 - Implement conditional formats
Implement conditional formats
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: General
git master
Other All
: High enhancement
: ---
Assigned To: Jody Goldberg
Jody Goldberg
: 581934 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2005-06-03 20:36 UTC by philippe
Modified: 2011-07-08 01:01 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
File with conditional format (red if >0 and white in the other cases) (21.00 KB, application/octet-stream)
2005-09-22 20:32 UTC, philippe 		Details

Description philippe 2005-06-03 20:36:04 UTC 
Version details: 1.5.1.RC1
Distribution/Version: XP SP2

In Excell, the cells have a conditionnal format (example: Red color for text if
value <0).
When you open the file with gnumeric, the cells seem empty.In fact, the text
color is white. 
Is it possible to have a similar function for conditional format?
Comment 1 Morten Welinder 2005-06-03 21:12:09 UTC 
Conditional formats are simply not implemented in Gnumeric at this time.

You probably get a white cell because the cell's default format (the one to be
overridden by the conditional format) is white.
Comment 2 Jody Goldberg 2005-07-05 20:43:44 UTC 
1.5.3 now imports conditional formats and implements background and patterns.
Comment 3 Jody Goldberg 2005-09-20 22:33:05 UTC 
Can you give me a sample file ?
Comment 4 philippe 2005-09-22 20:32:11 UTC 
Created attachment 52529 [details]
File with conditional format (red if >0 and white in the other cases)

When I was prepairing the file, I have noticed that:
-Gnumeric doesn't ask for updating external data
-Gnumeric doesn't take care of the Excell protection (read only when saving)
Comment 5 Morten Welinder 2005-09-22 21:22:56 UTC 
Thanks, reopening.
Comment 6 Andreas J. Guelzow 2009-05-09 01:13:38 UTC 
*** Bug 581934 has been marked as a duplicate of this bug. ***
Comment 7 Andreas J. Guelzow 2011-07-06 15:29:27 UTC 
Note that we have been handling conditional background colours for a while. This file uses conditional foreground colours which we apparently are not.
Comment 8 Andreas J. Guelzow 2011-07-08 01:01:49 UTC 
This turned out to be a rendering issue, The conditional styles where loaded but just nor rendered.

This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.