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

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

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]

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]

To be placed in test-data\spreadsheet\DGet.xls