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 586818 - Import "not between" conditional formatting from Excel files
Import "not between" conditional formatting from Excel files
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
git master
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2009-06-24 06:24 UTC by sum1
Modified: 2009-06-24 09:26 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
xls file with 'not between' conditional formatting (13.50 KB, application/vnd.ms-excel )
2009-06-24 06:25 UTC, sum1
Details

Description sum1 2009-06-24 06:24:18 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
Comment 1 sum1 2009-06-24 06:25:50 UTC
Created attachment 137288 [details]
xls file with 'not between' conditional formatting
Comment 2 Andreas J. Guelzow 2009-06-24 06:29:15 UTC
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.)
Comment 3 Andreas J. Guelzow 2009-06-24 09:26:36 UTC
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.