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 331983 - Validation with list choices from non-expression array
Validation with list choices from non-expression array
Status: RESOLVED OBSOLETE
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
git master
Other All
: High normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2006-02-21 06:29 UTC by J.H.M. Dassen (Ray)
Modified: 2018-05-22 13:14 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
sample files to demonstrate problem (49.88 KB, application/zip)
2013-06-14 00:44 UTC, Dmitry Smirnov
Details

Description J.H.M. Dassen (Ray) 2006-02-21 06:29:11 UTC
[Originally reported as http://bugs.debian.org/353810]

Package: gnumeric
Version: 1.6.2-1

When importing an Excel 97 spreadsheet with a situation similar to the
following, the validation criteria get mangled.

In Excel, several cells are marked with validation settings to allow a
List.  The Source is

Alpha, Beta, Gamma

"Ignore blank" and "In-cell dropdown" are checked.

When loading into gnumeric, the validation settings for the cells become
Allow in a list
with a Source of

"Alpha"

"Ignore blank" is checked.

gnumeric proceeds to enforce these settings, only allowing a value of
"Alpha".  If I try to change the source to

"Alpha", "Beta", "Gamma"

gnumeric pops up the dialog saying "The validation criteria are
unusable. Disable validation?"
Comment 1 Jody Goldberg 2006-11-25 03:32:56 UTC
Interesting, it looks like validate from list accepts a non-standard form of expression.
Comment 2 nathan.pepper 2010-01-08 22:33:47 UTC
This might be related.... I have two sheets, Expenses and PayMethods (listing 6 payment methods: cash, debit, FSF Visa, MC, Discover, Citi Visa).

For the Method column in the Expenses sheet, I set validation to allow 'In a list'.  I select the source "PayMethods!$A$1:$A$6" by using the interface option.  However, if I just click the "Select source" button, switch sheets, select the range, then click the button again to get back to the Validation dialog, it sets the validation for the active cell on the PayMethods sheet.

If I manually click back on my original sheet (Expenses) before clicking OK to finalize validation changes, the dropdown menu shows up in the active cells on the original sheet.
Comment 3 Andreas J. Guelzow 2010-05-05 08:30:28 UTC
This could be related to bug #608780.
Comment 4 Dmitry Smirnov 2013-06-14 00:44:46 UTC
Created attachment 246774 [details]
sample files to demonstrate problem
Comment 5 Dmitry Smirnov 2013-06-14 00:45:56 UTC
Here is recent feedback (and sample documents) for the issue:

    Since I don't have any relevant Excel documents right now,
    I had someone contrive some examples.  They are presumably from a
    newer version of Excel, and on a Mac, but gnumeric 1.10.17-1.1
    and 1.12.2-2 seem to fail to cope with them as well.
    
    The relevant cell is A1.

see attached "mac-excel-crap.zip".
Comment 6 GNOME Infrastructure Team 2018-05-22 13:14:00 UTC
-- GitLab Migration Automatic Message --

This bug has been migrated to GNOME's GitLab instance and has been closed from further activity.

You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/49.