8. Changelog¶
8.2. v0.1.3 (2018-10-09)¶
8.2.2. Fix¶
- (functions) #18: Enable check_error in IF function just for the first argument.
- (functions) #18: Disable input_parser in IF function to return any type of values.
- (rtd): Define fpath from prj_dir for rtd.
- (rtd): Add missing requirements openpyxl for rtd.
- (setup): Patch to use sphinxcontrib.restbuilder in setup long_description.
8.2.3. Other¶
- Update documentation.
- Replace excel with Excel.
- Create PULL_REQUEST_TEMPLATE.md.
- Update issue templates.
- Update copyright.
- (doc): Update author mail.
8.3. v0.1.2 (2018-09-12)¶
8.3.1. Feat¶
- (functions) #14: Add ROW and COLUMN.
- (cell): Pass cell reference when compiling cell + new function struct with dict to add inputs like CELL.
8.3.2. Fix¶
- (ranges): Replace system max size with excel max row and col.
- (tokens): Correct number regex.
8.4. v0.1.1 (2018-09-11)¶
8.4.1. Feat¶
- (contrib): Add contribution instructions.
- (setup): Add additional project_urls.
- (setup): Update Development Status to 4 - Beta.
8.6. v0.0.10 (2018-06-05)¶
8.6.1. Feat¶
- (look): Simplify _get_type_id function.
8.6.2. Fix¶
- (functions): Correct ImportError for FUNCTIONS.
- (operations): Correct behaviour of the basic operations.
8.7. v0.0.9 (2018-05-28)¶
8.7.1. Feat¶
- (excel): Improve performances pre-calculating the range format.
- (core): Improve performances using DispatchPipe instead SubDispatchPipe when compiling formulas.
- (function): Improve performances setting errstate outside vectorization.
- (core): Improve performances of range2parts function (overall 50% faster).
8.8. v0.0.8 (2018-05-23)¶
8.8.1. Feat¶
- (functions): Add MATCH, LOOKUP, HLOOKUP, VLOOKUP functions.
- (excel): Add method to compile ExcelModel.
- (travis): Run coveralls in python 3.6.
- (functions): Add FIND,`LEFT`,`LEN`,`LOWER`,`MID`,`REPLACE`,`RIGHT`,`TRIM`, and`UPPER` functions.
- (functions): Add IRR function.
- (formulas): Custom reshape to Array class.
- (functions): Add ISO.CEILING, SQRTPI, TRUNC functions.
- (functions): Add ROUND, ROUNDDOWN, ROUNDUP, SEC, SECH, SIGN functions.
- (functions): Add DECIMAL, EVEN, MROUND, ODD, RAND, RANDBETWEEN functions.
- (functions): Add FACT and FACTDOUBLE functions.
- (functions): Add ARABIC and ROMAN functions.
- (functions): Parametrize function wrap_ufunc.
- (functions): Split function raise_errors adding get_error function.
- (ranges): Add custom default and error value for defining ranges Arrays.
- (functions): Add LOG10 function + fix LOG.
- (functions): Add CSC and CSCH functions.
- (functions): Add COT and COTH functions.
- (functions): Add FLOOR, FLOOR.MATH, and FLOOR.PRECISE functions.
- (test): Improve log message of test cell.
8.8.2. Fix¶
- (rtd): Update installation file for read the docs.
- (functions): Remove unused functions.
- (formulas): Avoid too broad exception.
- (functions.math): Drop scipy dependency for calculate factorial2.
- (functions.logic): Correct error behaviour of if and iferror functions + add BroadcastError.
- (functions.info): Correct behaviour of iserr function.
- (functions): Correct error behaviour of average function.
- (functions): Correct iserror and iserr returning a custom Array.
- (functions): Now xceiling function returns np.nan instead Error.errors[‘#NUM!’].
- (functions): Correct is_number function, now returns False when number is a bool.
- (test): Ensure same order of workbook comparisons.
- (functions): Correct behaviour of min max and int function.
- (ranges): Ensure to have a value with correct shape.
- (parser): Change order of parsing to avoid TRUE and FALSE parsed as ranges or errors as strings.
- (function):Remove unused kwargs n_out.
- (parser): Parse error string as formulas.
- (readme): Remove downloads_count because it is no longer available.
8.9. v0.0.7 (2017-07-20)¶
8.9.2. Fix¶
- (install): Force update setuptools>=36.0.1.
- (functions): Correct iserror iserr functions.
- (ranges): Replace ‘#N/A’ with ‘’ as empty value when assemble values.
- (functions) #4: Remove check in ufunc when inputs have different size.
- (functions) #4: Correct power, arctan2, and mod error results.
- (functions) #4: Simplify ufunc code.
- (test) #4: Check that all results are in the output.
- (functions) #4: Correct atan2 argument order.
- (range) #5: Avoid parsing function name as range when it is followed by (.
- (operator) #3: Replace strip with replace.
- (operator) #3: Correct valid operators like ^- or *+.
8.9.3. Other¶
- Made the ufunc wrapper work with multi input functions, e.g., power, mod, and atan2.
- Created a workbook comparison method in TestExcelModel.
- Added MIN and MAX to the test.xlsx.
- Cleaned up the ufunc wrapper and added min and max to the functions list.
- Relaxed equality in TestExcelModel and made some small fixes to functions.py.
- Added a wrapper for numpy ufuncs, mapped some Excel functions to ufuncs and provided tests.
8.10. v0.0.6 (2017-05-31)¶
8.10.1. Fix¶
- (plot): Update schedula to 0.1.12.
- (range): Sheet name without commas has this [^Wd][w.] format.