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?"


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to