Pycel

Latest version: v1.0b30

Safety actively analyzes 682361 Python packages for vulnerabilities to keep your Python projects secure.

Scan your dependencies

Page 3 of 5

1.0b15

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

Changed
-------
* Implement AVERAGEIFS()
* Take Iterative Calc Parameter defaults from workbook

Fixed
-----
* 60, Binder Notebook Example not Working

1.0b14

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

Changed
-------
* Added method to evaluate the conditional format (formulas) for a cell or cells
* Added ExcelCompiler(..., cycles=True) to allow Excel iterative calculations

1.0b13

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

Changed
-------
* Implement VALUE()
* Improve compile performance reversion from CSE work

Fixed
-----
* 54, In normalize_year(), month % 12 can be 0 -> IllegalMonthError

1.0b12

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

Changed
-------
* Add library plugin support
* Improve evaluate of unbounded row/col (ie: A:B)
* Fix some regressions from 1.0b11

1.0b11

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

Added
-----

* Implement LEFT()
* Implement ISERROR()
* Implement FIND()
* Implement ISNUMBER()
* Implement SUMPRODUCT()
* Implement CEILING()
* Implement TRUNC() and FLOOR()
* Add support for LOG()
* Improve ABS(), INT() and ROUND()

* Add quoted_address() method to AddressRange and AddressCell
* Add public interface to get list of formula_cells()
* Add NotImplementedError for "linked" sheet names
* Add reference URL to function info
* Added considerable extensions to CSE Array Formula Support
* Add CSE Array handling to excelformula and excelcompiler
* Change Row, Column & Index to rectangular arrays only
* Add in_array_formula_context
* Add cse_array_wrapper() to allow calling functions in array context
* Add error_string_wrapper() to check for excel errors
* Move math_wrap() to function_helpers.
* Handle Direct CSE Array in cell
* Reorganize CSE Array Formula handling in excelwrapper
* For CSE Arrays that are smaller than target fill w/ None
* Trim oversize array results to fit target range
* Improve needed addresses parser from python code
* Improve _coerce_to_number() and _numerics() for CSE arrays
* Remove formulas from excelwrapper._OpxRange()

Changed
-------

* Refactored ExcelWrapper, ExcelFormula & ExcelCompiler to allow...
* Refactored function_helpers to add decorators for excelizing library functions
* Improved various messages and exceptions in validate_calcs() and trim_graph()
* Improve Some NotImplementedError() messages
* Only build compiler eval context once

Fixed
-----

* Address Range Union and Intersection need sheet_name
* Fix function info for paired functions from same line
* Fix Range Intersection
* Fix Unary Minus on Empty cell
* Fix ISNA()
* Fix AddressCell create from tuple
* Power(0,-1) now returns DIV0
* Cleanup index()

1.0b8

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

Added
-----

* Implement operators for Array Formulas
* Implement concatenate and concat
* Implement subtotal
* Add support for expanding array formulas
* Add support for table relative references
* Add function information methods

Changed
-------

* Improve messages for validate_calcs and not implemented functions

Fixed
-----
* Fix column and row for array formulas

Page 3 of 5

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.