GNOME Bugzilla – Bug 331983
Validation with list choices from non-expression array
Last modified: 2018-05-22 13:14:00 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?"
Interesting, it looks like validate from list accepts a non-standard form of expression.
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.
This could be related to bug #608780.
Created attachment 246774 [details] sample files to demonstrate problem
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".
-- 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.