dgorissen / pycel

A library for compiling excel spreadsheets to python code & visualizing them as a graph

GNU General Public License v3.0

565 stars 147 forks source link

1.0b27 (2021-07-10) #124

Closed stephenrauch closed 3 years ago

stephenrauch commented 3 years ago

[x] tests added / passed
[x] passes tox

Added

Added CHOOSE() function
Added FORECAST() function
Added INTERCEPT() function
Added IFNA() function
Added ISBLANK() function
Added ISLOGICAL() function
Added ISNONTEXT() function
Added N() function
Added NA() function
Added SLOPE() function
Added SUBSTITUTE() function
Added TEXT() function (Thanks, Luckykarter)
Added TREND() function
Added Reference Form for INDEX()
Added str_params to excel_helper()
Added ExcelCompiler.validate_serialized()

Changed

Improve LINEST() compatibilty w/ Excel
Improve TEXT() compatibilty w/ Excel
Improve error and number handling in some Text functions
Improve IFS() to support array context
Missing references from INDIRECT() and OFFSET() resolve more often

Fixed

Fix #111, Incorrect implementation of YEARFRAC
Fixed some exceptions in LINEST()
Fix serialize ranges with formulas
Fixed a minor bug in DATE()
Fixed TIMEVALUE() parsing for elapsed times

codecov-commenter commented 3 years ago

Codecov Report

Merging #124 (d91c99b) into master (baf9476) will not change coverage. The diff coverage is 100.00%.

@@            Coverage Diff            @@
##            master      #124   +/-   ##
=========================================
  Coverage   100.00%   100.00%           
=========================================
  Files           17        17           
  Lines         3733      3733           
  Branches       908       908           
=========================================
  Hits          3733      3733

Impacted Files	Coverage Δ
src/pycel/version.py	`100.00% <100.00%> (ø)`

Continue to review full report at Codecov.

Legend - Click here to learn more Δ = absolute <relative> (impact), ø = not affected, ? = missing data Powered by Codecov. Last update baf9476...d91c99b. Read the comment docs.