GNOME Bugzilla – Bug 586818
Import "not between" conditional formatting from Excel files
Last modified: 2009-06-24 09:26:36 UTC
The upcoming attachment has "not between" conditional formatting set for A1:A5, but Gnumeric does not recognize it. (Note: Bug 306411 is a general request for conditional formatting, but this one is only meant to cover the "not between" case.) The condition: if "cell value is not between .15 and .45" set the background to red Steps to reproduce: - Import the upcoming attachment and notice that cells A1 and A5 do not have red backgrounds
Created attachment 137288 [details] xls file with 'not between' conditional formatting
This is probably not an import problem but a question of evaluation inside Gnumeric. If you try to import conditional formats from ODF then the normal comparisons with numbers and "between" works but "not-between" does not work. (Of course ODF import is completely untested.)
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.