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
  • #46

Closed
Open
Created Dec 08, 2005 by Bugzilla@bugzilla-migration💬Reporter

CHOOSE can return a ref, and does iteration for array indicies

Submitted by Nick Lamb

Link to original bug (#323550)

Description

http://www.ecs.soton.ac.uk/~njl98r/excel/choose.xls

Worked in 1.4.x but now CHOOSE() function won't load from Excel XLS.

(gnumeric:20547): gnumeric:read_expr-WARNING : EXCEL : Unhandled PTG 0x0. formula data : (NOT shared) 0 | 1e 2 0 19 4 4 0 a 0 14 0 1e 0 28 0 37 | .............(.7 10 | 0 17 3 0 31 73 74 19 8 26 0 17 3 0 32 6e | ....1st..&....2n 20 | 64 19 8 1c 0 17 3 0 33 72 64 19 8 12 0 17 | d.......3rd..... 30 | 8 0 46 69 6e 69 73 68 65 64 19 8 3 0 42 5 | ..Finished....B. 40 | 64 0 XX XX XX XX XX XX XX XX XX XX XX XX XX XX | d.************

(gnumeric:20547): gnumeric:read_expr-WARNING **: CHOOSE!B5 : Unknown Formula/Array

The above is repeated more or less for all uses of CHOOSE in this test sheet.

Version: git master

Assignee
Assign to
Time tracking