Formulas

-------------------

Feat
~~~~
- (core): Update Copyright.

- (functions) :gh:`109`, :gh:`111`, :gh:`124`, :gh:`125`: Update test
cases.

- (stat) :gh:`111`: Add `PERCENTILE`, `PERCENTILE.INC`, and
`PERCENTILE.EXC` functions.

- (stat) :gh:`111`: Add `NORM.S.DIST`, `NORM.S.INV`, `NORM.DIST`,
`NORM.INV`,`NORMDIST`, `NORMINV`,`NORMSINV` functions.

- (stat) :gh:`111`: Add `NORMSDIST` function.

- (stat) :gh:`124`: Correct implementation `QUARTILE` and add
`QUARTILE.INC` and `QUARTILE.EXC`.

- (functions) :gh:`124`: Add `QUARTILE` to stat functions.

- (functions) :gh:`125`: Add `SUMSQ` to stat functions.

- (tokens) :gh:`139`: Allow last parameters to be empty in a function
call.

- (tokens) :gh:`139`: Allow first param to be empty.

- (core): Update `.gitignore` settings.

- (text): Add `CODE` function.

- (text): Add `CHAR` function.

- (test): Update coverage python version.


Fix
~~~
- (test) :gh:`111`: Correct test case for windows.

- (excel) :gh:`109`: Correct parser for named range with backslash in
name.

- (functions) :gh:`125`: Move `SUMSQ` function to math.

- (core): Correct repr formatting of ranges for numpy version 2.x.

- (tokens) :gh:`145`: Correct handling of `REF!` when compiling
functions.

- (text): Correct `CODE` function.

- (text): Add `CODE` text case.

- (excel) :gh:`132`: Correction on how to handle the empty values used
within a formula.

- (excel): Add `EMPTY` value to save correctly the model as dict.

- (excel) :gh:`134`, :gh:`135`: Correct `inverse_references` handling
when model defined with `from_dict`.

- (excel): Correct tolerance.

- (setup): Correct setup config file.

-------------------

Feat
~~~~
- (builder) :gh:`104`: Allow custom reference definition.

- (test): Update test cases.

- (operand) :gh:`106`: Accept number like `.3` to be parsed.

- (text) :gh:`113`: Add `TEXT` function without fraction formatting.

- (logic): Update logic functions according to new excel logic.

- (text) :gh:`113`: Add `VALUE` function.

- (math) :gh:`121`: Improve performances of `SUMPRODUCT`, `PRODUCT`,
`SUM`, and `SUMIF`.

- (setup): Update requirements.

- (core): Change development status.

- (core): Add support for python 3.10 and 3.11.

- (functions) :gh:`121`: Improve handling of EMPTY values.

- (excel): Avoid using `flatten` function in basic routines.

- (doc): Add Read the Docs configuration file.

- (excel): Add tolerance when comparing two excels.

- (excel): Add compare method to verify if formulas is able to replicate
excel values.


Fix
~~~
- (doc): Remove broken badge.

- (excel) :gh:`100`: Correct reading rounding from excel.

- (math) :gh:`100`: Correct `TRUNC` defaults.

- (tokens) :gh:`113`: Correct `sheet_id` definition.

- (functions): Correct dill pickling error.

- (excel): Correct reference parsing when loading from JSON.

- (functions): Use an alternative method of vectorize when more than 32
arguments are provided.

- (look): Correct `MATCH`, `LOOKUP`,`HLOOKUP`, and `VLOOKUP` behaviour
when empty values are given.

- (date): Correct `DATEDIF` behaviour when unit is lowercase.

- (test): Use regex for unstable tests due to changes in last digits.

- (doc): Correct documentation bug due to new `sphinx`.

- (excel) :gh:`114`: Update reading code according to `openpyxl>=3.1`.

-------------------

Fix
~~~
- (setup): Update `schedula` requirement.

-------------------

Fix
~~~
- (parser): Correct missing raise.

- (excel): Skip hidden named ranges.

-------------------

Feat
~~~~
- (core): Improve speed performance.

- (cell): Improve speed `RangesAssembler` definition.


Fix
~~~
- (cell): Correct range assembler defaults when no `sheet_id` is
defined.

- (math) :gh:`99`: Convert args into np.arrays in func `xsumproduct`.

- (look): Correct lookup parser for float and strings.

-------------------

Feat
~~~~
- (test): Add more error logs.

- (test): Improve code coverage.

- (builder): Add `compile_class` attribute to `AstBuilder`.

- (info): Add `ISODD`, `ISEVEN`, `ISBLANK`, `ISTEXT`, `ISNONTEXT`, and
`ISLOGICAL` functions.


Fix
~~~
- (excel): Correct file path excel definition.

- (logic): Correct `SWITCH` error handling.

- (actions): Rename workflow name.

- (readme): Correct badge link for dependencies status.

- (excel): Correct `basedir` reference to load files.

- (date): Correct `YEARFRAC` and `DATEDIF` formulation.

- (cell): Enable R1C1 notation for absolute and relative references.

- (cell): Correct RangeAssembler value assignment.