https://bz.apache.org/bugzilla/show_bug.cgi?id=61859
Yegor Kozlov <ye...@dinom.ru> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |FIXED Status|NEW |RESOLVED OS| |All --- Comment #1 from Yegor Kozlov <ye...@dinom.ru> --- Should be fixed in r1818587 The fix includes two important changes: 1. Support for evaluating relational operators in array mode. Before this fix POI always de-referenced the first value and $B$2:$B$11=F2 evaluated as $B$2=F2 . Now it should correctly evaluate it to an array of {TRUE, FALSE, ..... }. 2. Recognize 'array' evaluation mode from the formula context. Normally, array arithmetic is used in array formulas (those saved with Ctrl-Shift-Enter). The INDEX function seems to be a special case: if row_num or column_num are omitted or set to 0, INDEX returns an array of the entire column or row. I had to tweak the evaluator to recognize it. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org