[Bug 60924] New Excel 2016 Statements Not Supported

2021-12-02 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924

--- Comment #15 from PJ Fanning  ---
added partial implementation of xlookup using
https://github.com/apache/poi/pull/243 - still lots of scenarios to be done -
if anything is intetested in helping out

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 60924] New Excel 2016 Statements Not Supported

2021-07-28 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924

PJ Fanning  changed:

   What|Removed |Added

 Resolution|--- |FIXED
 Status|NEW |RESOLVED

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 60924] New Excel 2016 Statements Not Supported

2021-07-28 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924

--- Comment #14 from PJ Fanning  ---
thanks Pieter - added patch using r1891856

will close this - additional functions will need new issues

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 60924] New Excel 2016 Statements Not Supported

2021-07-28 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924
Bug 60924 depends on bug 64633, which changed state.

Bug 64633 Summary: [PATCH] Support of function TEXTJOIN
https://bz.apache.org/bugzilla/show_bug.cgi?id=64633

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 60924] New Excel 2016 Statements Not Supported

2021-02-07 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924

Anthony V  changed:

   What|Removed |Added

 CC||anthonyv...@outlook.com

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 60924] New Excel 2016 Statements Not Supported

2021-01-07 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924

Matafagafo  changed:

   What|Removed |Added

 CC||matafag...@yahoo.com

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 60924] New Excel 2016 Statements Not Supported

2020-12-30 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924

Dominik Stadler  changed:

   What|Removed |Added

 Depends on||64633


Referenced Bugs:

https://bz.apache.org/bugzilla/show_bug.cgi?id=64633
[Bug 64633] [PATCH] Support of function TEXTJOIN
-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 60924] New Excel 2016 Statements Not Supported

2020-03-27 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924

--- Comment #13 from markfrancis2...@yahoo.co.uk ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 60924] New Excel 2016 Statements Not Supported

2019-12-09 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924

leon...@yahoo.com changed:

   What|Removed |Added

 Status|NEEDINFO|NEW

--- Comment #12 from leon...@yahoo.com ---
I've loaded with version 4.1.1 library. When I evaluateCell contain MINIFS, the
NotImplemented error occur.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 60924] New Excel 2016 Statements Not Supported

2019-12-09 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924

leon...@yahoo.com changed:

   What|Removed |Added

Version|unspecified |4.1.1-FINAL

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 60924] New Excel 2016 Statements Not Supported

2018-06-05 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924

--- Comment #11 from Pieter Degraeuwe  ---
Created attachment 35955
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=35955=edit
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!

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 60924] New Excel 2016 Statements Not Supported

2018-06-01 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924

--- Comment #10 from Nick Burch  ---
(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!

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 60924] New Excel 2016 Statements Not Supported

2018-06-01 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924

--- Comment #9 from Pieter Degraeuwe  ---
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?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 60924] New Excel 2016 Statements Not Supported

2018-06-01 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924

Pieter Degraeuwe  changed:

   What|Removed |Added

 CC||p...@systemworks.be

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 60924] New Excel 2016 Statements Not Supported

2017-03-27 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924

Adrian B.  changed:

   What|Removed |Added

Summary|Excel 2016 SWITCH Statement |New Excel 2016 Statements
   |Not Supported   |Not Supported

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org