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...
Status: RESOLVED FIXED
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
URL:
Keywords: PatchAvailable
Depends on:
Blocks:
 
Reported: 2017-03-06 13:05 UTC by Patrick Zimmermann
Modified: 2017-03-19 20:32 UTC (History)
0 users



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

Note You need to log in before you can comment on or make changes to this bug.
Description Patrick Zimmermann 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 Zimmermann 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!