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 Böker
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 Böker 		Details | Diff
DGet.xls (53.00 KB, application/octet-stream)
2017-03-06 13:07 UTC, Patrick Böker 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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]
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!