Bug 60823

Summary: [PATCH] DGET function, correct behavior with multiple result entries but only one non-blank
Product: POI Reporter: Patrick Böker <patrick.boeker>
Component: SS CommonAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: enhancement Keywords: PatchAvailable
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: All   
OS: All   
Attachments: dget_multi_blank_result.patch
DGet.xls

Description Patrick Böker 2017-03-06 13:05:20 UTC
Created attachment 34799 [details]
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.
Comment 1 Patrick Böker 2017-03-06 13:07:00 UTC
Created attachment 34800 [details]
DGet.xls

The test case. To replace /test-data/spreadsheet/DGet.xls
Comment 2 Dominik Stadler 2017-03-19 20:32:13 UTC
Applied via r1787658, thanks a lot for the patch!