https://bz.apache.org/bugzilla/show_bug.cgi?id=60823
Bug ID: 60823 Summary: [PATCH] DGET function, correct behavior with multiple result entries but only one non-blank Product: POI Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P2 Component: SS Common Assignee: dev@poi.apache.org Reporter: patrick.zimmerm...@haltec.de Target Milestone: --- Created attachment 34799 --> https://bz.apache.org/bugzilla/attachment.cgi?id=34799&action=edit dget_multi_blank_result.patch This patch fixes a misbehavior of the DGet() function. If the filtering returns more than one result, but only one of the results is non-blank, Excel 2013 returns that one non-blank result. POI currently returns #NUM! in that case. A respective test case is included. -- 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