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