#353810 validation inadequacy

Package:
gnumeric
Source:
gnumeric
Description:
spreadsheet application for GNOME - main program
Submitter:
Clint Adams
Date:
2019-11-13 05:57:03 UTC
Severity:
normal
#353810#5
Date:
2006-02-21 03:47:43 UTC
From:
To:
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?"
#353810#16
Date:
2013-06-13 11:18:11 UTC
From:
To:
Hi Clint,

If this is still a problem with recent versions of gnumeric, then
could you please provide a sample document?

Thanks.

Regards,
 Dmitry.
#353810#21
Date:
2013-06-13 16:32:20 UTC
From:
To:
Hi.  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.