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]