Bug 63700 - [PATCH] Make D* functions work with numeric result column
Summary: [PATCH] Make D* functions work with numeric result column
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: 2019-08-27 07:48 UTC by Patrick Böker
Modified: 2019-12-31 10:42 UTC (History)
0 users


Attachments
dget_num_col.patch (1.07 KB, patch)
2019-08-27 07:48 UTC, Patrick Böker 		Details | Diff
DGet.xls (54.00 KB, application/octet-stream)
2019-08-27 07:49 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 2019-08-27 07:48:17 UTC 
Created attachment 36737 [details]
dget_num_col.patch

It is apparently possible in the D* functions to pass the desired result column (second argument) numerically as well. This patch adds that functionality. Added tests to check for that. I only verified this on Excel 2013.
Comment 1 Patrick Böker 2019-08-27 07:49:25 UTC 
Created attachment 36738 [details]
DGet.xls

To be placed in test-data\spreadsheet\DGet.xls
Comment 2 Dominik Stadler 2019-12-31 10:42:05 UTC 
Applied via r1872136, thanks for the Patch!