Skip to content

GitLab

  • Menu
Projects Groups Snippets
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • gnumeric gnumeric
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 378
    • Issues 378
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 3
    • Merge requests 3
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Packages & Registries
    • Packages & Registries
    • Container Registry
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • GNOME
  • gnumericgnumeric
  • Issues
  • #49

Closed
Open
Created Feb 21, 2006 by Bugzilla@bugzilla-migration💬Reporter

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

Assignee
Assign to
Time tracking