Summary: | New Excel 2016 Statements Not Supported | ||
---|---|---|---|
Product: | POI | Reporter: | Adrian B. <barnes41> |
Component: | SS Common | Assignee: | POI Developers List <dev> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | matafagafo, pdg |
Priority: | P2 | ||
Version: | 4.1.1-FINAL | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | All | ||
Bug Depends on: | 64633 | ||
Bug Blocks: | |||
Attachments: |
Example of 2016 SWITCH Statement
Example of 2016 IFS Statement Example of 2016 MAXIFS Statement Example of 2016 MINIFS Statement Example of 2016 TEXTJOIN Statement Example of 2016 CONCAT Statement Patch for IFS and SWITCH |
Description
Adrian B.
2017-03-27 17:24:26 UTC
Official documentation for SWITCH function: https://support.office.com/en-us/article/SWITCH-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e I don't have Excel 2016 to be able to create a workbook to test this. Could you upload a valid, blank Excel 2016 file with a switch function and populate any cells necessary to verify the function evaluation is correct? Created attachment 34878 [details] Example of 2016 SWITCH Statement According to https://www.onmsft.com/news/excel-2016-gains-6-new-functions-to-simplify-formula-editing , there are 6 new formulas. Here's the Microsoft documentation for each: SWITCH - https://support.office.com/en-us/article/SWITCH-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e IFS - https://support.office.com/en-US/article/IFS-function-36329a26-37b2-467c-972b-4a39bd951d45 CONCAT - https://support.office.com/en-US/article/CONCAT-function-9b1a9a3f-94ff-41af-9736-694cbd6b4ca2 TEXTJOIN - https://support.office.com/en-US/article/TEXTJOIN-function-357b449a-ec91-49d0-80c3-0e8fc845691c MAXIFS - https://support.office.com/en-us/article/MAXIFS-function-dfd611e6-da2c-488a-919b-9b6376b28883 MINIFS - https://support.office.com/en-us/article/MINIFS-function-6ca1ddaa-079b-4e74-80cc-72eef32e6599 Created attachment 34879 [details]
Example of 2016 IFS Statement
Created attachment 34880 [details]
Example of 2016 MAXIFS Statement
Created attachment 34881 [details]
Example of 2016 MINIFS Statement
Created attachment 34882 [details]
Example of 2016 TEXTJOIN Statement
Created attachment 34883 [details]
Example of 2016 CONCAT Statement
Don't know why This bug is still on 'NEEDINFO'. I did already write an IFS and SWITCH function (and their Tests) Should I add the patch here? (In reply to Pieter Degraeuwe from comment #9) > Don't know why This bug is still on 'NEEDINFO'. > > I did already write an IFS and SWITCH function (and their Tests) > Should I add the patch here? Please either attach the patch and unit tests here, or open a pull request against our Github mirror, whatever is easiest for you! Created attachment 35955 [details]
Patch for IFS and SWITCH
Patch contains (I tink) working implementations for IFS and SWITCH
please be gentle: I'm a newbie here at poi ;-)
So, it could be that the implementations are not that great.
Comments are welcome!
I've loaded with version 4.1.1 library. When I evaluateCell contain MINIFS, the NotImplemented error occur. Apologise as I'm new to this, so this may be the wrong bug but there is also the new XLOOKUP function added in Excel 2019. |