Validation with list choices from non-expression array
Submitted by J.H.M. Dassen (Ray)
Link to original bug (#331983)
Description
[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?"
Version: git master