Bug 60823 - [PATCH] DGET function, correct behavior with multiple result entries but only one non-blank
Summary: [PATCH] DGET function, correct behavior with multiple result entries but only...
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: unspecified
Hardware: All All
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
Keywords: PatchAvailable
Depends on:
Reported: 2017-03-06 13:05 UTC by Patrick Böker
Modified: 2017-03-19 20:32 UTC (History)
0 users

dget_multi_blank_result.patch (1.04 KB, patch)
2017-03-06 13:05 UTC, Patrick Böker
Details | Diff
DGet.xls (53.00 KB, application/octet-stream)
2017-03-06 13:07 UTC, Patrick Böker

Note You need to log in before you can comment on or make changes to this bug.
Description Patrick Böker 2017-03-06 13:05:20 UTC
Created attachment 34799 [details]

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]

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!