Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Excel Functions implementation I #821

Closed
tonyqus opened this issue Apr 27, 2022 · 2 comments
Closed

Excel Functions implementation I #821

tonyqus opened this issue Apr 27, 2022 · 2 comments

Comments

@tonyqus
Copy link
Member

tonyqus commented Apr 27, 2022

Github 107 Add AREAS function
POI 61063 Use of arrays of values leads to non empty stack
POI 63984 AND / OR should treat missing parameters as FALSE
POI 62254 OFFSET function fails when 2nd or 3rd arguments are missing
POI 63819 Support DateValue function
POI 62857 DOLLAR function not implemented entirely
POI 65606 Bug in evaluating WEEKNUM
POI 65846 Add support for NUMBERVALUE function
POI 65879 Add support for WORKDAY.INTL functions
POI 65871 Add support for DOLLARDE and DOLLARFR functions
POI 65870 Add support for BESSELJ function
POI 49202 add support for the function 'PERCENTRANK'
POI 64258 Provide implementation for TDIST function
POI 65850 Add support for Normal Distribution functions
POI 60029 Fix problem with Days360 method for the month of february
POI Github 69 Numeric Array Formula and Matrix Function Patch
POI 64238 Make LOOKUP functions deal with empty last arg correctly
POI 64393 Handle MissingArgEval in relational operators

@tonyqus tonyqus added this to the NPOI 2.6.0 milestone Apr 27, 2022
@tonyqus
Copy link
Member Author

tonyqus commented May 30, 2022

POI 66047 Fix rounding issue in MROUND function
POI 65988 RATE function fails in some cases
POI Github 330 Support AVERAGEIF function
POI 66083 Support CEILING.MATH and FLOOR.MATH functions
POI 66090 add support for DCOUNT, DCOUNTA, DAVERAGE, DSTDEV, DSTDEVP, DVAR, DVARP and DPRODUCT functions
POI 66093 add support for unimplemented subfunctions to SUBTOTAL function
POI 66094 add support for STDEV.S, STDEV.P, VAR.S and VAR.P functions
POI 65915 Fix issue where Boolean functions (AND, OR) do not work properly in array context
POI 62373 Support FREQUENCY function

@tonyqus tonyqus closed this as completed Feb 24, 2023
@tonyqus tonyqus changed the title Excel Functions implementation Excel Functions implementation I Feb 24, 2023
@tonyqus
Copy link
Member Author

tonyqus commented Feb 24, 2023

Move the rest to #1023

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant