search

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

Upstream #123

Closed stephenrauch closed 3 years ago

stephenrauch commented 3 years ago

Implement parser for complete format language used by TEXT() Add handling for missing references in INDIRECT() and OFFSET() Implement INDEX() Reference form Implement IFNA() & extend IFS() to support array context Improve lookup functions with blank cells Fix serialize ranges with formulas Add ExcelCompiler.validate_serialized() to compare serialized vs actual sheet Add helpers: is_array_arg() and has_array_arg() Cleanup to use more F-strings Update Openpyxl link

codecov-commenter commented 3 years ago

Codecov Report

Merging #123 (8260afc) into master (4043693) will not change coverage. The diff coverage is 100.00%.

Impacted file tree graph

@@            Coverage Diff             @@
##            master      #123    +/-   ##
==========================================
  Coverage   100.00%   100.00%            
==========================================
  Files           17        17            
  Lines         3420      3733   +313     
  Branches       822       908    +86     
==========================================
+ Hits          3420      3733   +313
Impacted Files Coverage Δ
src/pycel/excelcompiler.py 100.00% <100.00%> (ø)
src/pycel/excelformula.py 100.00% <100.00%> (ø)
src/pycel/excellib.py 100.00% <100.00%> (ø)
src/pycel/excelutil.py 100.00% <100.00%> (ø)
src/pycel/excelwrapper.py 100.00% <100.00%> (ø)
src/pycel/lib/date_time.py 100.00% <100.00%> (ø)
src/pycel/lib/function_helpers.py 100.00% <100.00%> (ø)
src/pycel/lib/function_info.py 100.00% <100.00%> (ø)
src/pycel/lib/logical.py 100.00% <100.00%> (ø)
src/pycel/lib/lookup.py 100.00% <100.00%> (ø)
... and 1 more

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 4043693...8260afc. Read the comment docs.