Pycel

=====================

Changed
-------

- Better handle indirect cells in compiled workbooks
- Better handle numpy floats in compiled workbooks

=====================

Added
-----

- Add support for openpyxl >= 3.0.8

=====================

Added
-----

- Add support for networkx 2.6

Changed
-------

- Some minor improvements for Iterative Calculations

=====================

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

=====================

Added
-----

* Python 3.9 now supported
* Add bitwise functions: bitand, bitor, bitxor, bitlshift and bitrshift (Thanks, bogdan-oprescu-nxp)
* Add PV function (Thanks, estandiaa-marain)

Changed
-------

* Allow plugins to be passed to the deserialization function from_file() (Thanks, nanaposo)

Removed
-------

* Drop support for Python 3.5

Fixed
-----
* Fix openpyxl >= 3.0.4 (Thanks, ckp95)
* Fix HLOOKUP row_index_num validation to use num rows (Thanks, nanaposo)
* Fix 86, tokenize.TokenError: ('EOF in multi-line statement',
* Fix 88, Handle calcPR in workbook (Thanks, andreif)
* Fix 89, NPV function fails when passed range of cashflows (Thanks, jpp-0)
* Fix 93, AssertionError during set_value(), by adding a better error message
* Fix 99, Pycel raises NotImplementedError on rectangular ranges (Thanks, rmorel)
* Fix 103, build_operator_operand_fixup() throws VALUE error when concatenating AddressCell objects (Thanks, nboukraa)
* Fix 104, Insufficient coverage and testing after recent merges
* Fix 105, Incorrect RPN for expressions with consecutive negations (Thanks, victorjmarin)
* Fix 109, String concatenation fails for particular cases (Thanks, bogdan-oprescu-nxp)
* Fix issue in =IF() when comparing to numpy result
* Fix MID() and REPLACE() and LEN() in a CSE context
* Fix INDEX() error handling
* Fix error handling for lookup variants

=====================

Fixed
-----
* Fix 80, incompatible w/ networkx 2.4