dgorissen/pycel

Issues

• NOT does not work in the context of a range context

  #164 opened 2 months ago by heetbeet
  1

• Expression parsing error when referring to a Named Range

  #161 opened 7 months ago by raybsmith
  1

• Formula Parsing Error

  #160 opened a year ago by agoddijn
  1

• Absolute and relative references are converted to identical Python code.

  #159 opened a year ago by manns
  0

• AttributeError: 'Worksheet' object has no attribute 'formula_attributes'

  #129 opened 3 years ago by karolinabirecka
  3

• Formula parsing error

  #158 opened 2 years ago by jt269
  0

• Incorrect formual evaluation

  #149 opened 3 years ago by maneeshkulkarni78
  2

• support for set_value and evaluate with defined names

  #153 opened 2 years ago by codinguncut
  0

• Large excel files are slow to open

  #152 opened 2 years ago by bauerjon
  2

• Can the graph be saved as a simple Excel file?

  #150 opened 3 years ago by charlesdwright
  0

• Wrong result if lookup_value is string for "match" function.

  #148 opened 3 years ago by lhz5166
  1

• Wrong evaluations when creating ExcelCompiler model from openpyxl workbook

  #145 opened 3 years ago by igheorghita
  0

• How to properly use the excel_helper decorator?

  #138 opened 3 years ago by igheorghita
  0

• Minor issue regarding whitespace parsing

  #136 opened 3 years ago by igheorghita
  1

• Order of evaluation matters when a cell contains a nonimplemented function

  #128 opened 3 years ago by igheorghita
  4

• Evaluate Starts Returning None After Successfully Evaluating One Cell in Circular Formula Chain

  #126 opened 3 years ago by JSv4
  3

• Compiling Excel spreadsheets to Python

  #94 opened 3 years ago by LFoglietti
  1

• TypeError on iterative models

  #71 opened 5 years ago
  2

• LINEST function fails w/ Workbook created in LibreOffice

  #97 opened 4 years ago by henrus
  1

• Bug: How to fix isblank is not defined

  #120 opened 4 years ago by hellobiek
  0

• Function TEXT is not implemented. TEXT is in the "Text" group

  #101 opened 4 years ago by lezwon
  0

• _CycleCell and _Cell may have problem

  #118 opened 4 years ago by hellobiek
  1

• Insufficient coverage and testing after recent merges

  #104 opened 4 years ago by andreif
  6

• Incorrect implementation of YEARFRAC

  #111 opened 4 years ago by michaelhays
  3

• `tokenize.TokenError: ('EOF in multi-line statement', (2, 0))` on a SUMIF with escaped double-quotes

  #86 opened 4 years ago by ckp95
  0

• AssertionError during set_value()

  #93 opened 4 years ago by hoffman32
  1

• PV function

  #91 opened 4 years ago by estandiaa-marain
  0

• Pycel raises NotImplementedError on rectangular ranges

  #99 opened 4 years ago by rmorel
  0

• String concatenation fails for particular cases

  #109 opened 4 years ago by bogdan-oprescu-nxp
  0

• Incorrect RPN for expressions with consecutive negations

  #105 opened 4 years ago by victorjmarin
  4

• Fails due to missing `calcPr` property.

  #88 opened 4 years ago by andreif
  0

• NPV function fails when passed range of cashflows

  #89 opened 5 years ago by Twoy519
  1

• High RAM consumption when evaluating a formula

  #90 opened 5 years ago by OysterD3
  0

• AttributeError: 'DiGraph' object has no attribute 'node'

  #80 opened 5 years ago by andreif
  6

• MATCH and VLOOKUP issue

  #81 opened 5 years ago
  1

• TypeError with iferror in special case

  #77 opened 5 years ago
  1

• COUNTIF and COUNTIFS

  #78 opened 5 years ago
  1

• COUNT not working for ranges

  #74 opened 5 years ago
  1

• AVERAGEIF not computing for duplicates

  #73 opened 5 years ago
  5

• VLOOKUP returns last value found

  #75 opened 5 years ago
  1

• Is there a way to get the list of dependent cells?

  #70 opened 5 years ago
  1

• Incorrect evaluated formula result for unbounded column

  #67 opened 5 years ago by zi-l
  9

• Binder Notebook Example not Working

  #60 opened 6 years ago by mfastudillo
  3

• Support for iterative calculation

  #56 opened 6 years ago by GeoJosh
  0

• In normalize_year(), month % 12 can be 0 -> IllegalMonthError

  #54 opened 6 years ago by Dagg-h
  1

• AVERAGEIFS

  #53 opened 6 years ago by Nadim-Safari
  2

• Unbounded Range Addresses (ie: A:B or 1:2) broken

  #45 opened 6 years ago by ftune
  1

• excelformula._parse_to_rpn crashes with space after "=" in formula

  #43 opened 6 years ago by mrludens
  1

• While Process a large xlsx , get 'ReadOnlyWorksheet' object has no attribute 'iter_cols' from Openpyxl

  #42 opened 6 years ago by ftune
  1

• Find a proer version openpyxl ?Cannot import name 'TYPE_FORMULA'/No module named 'openpyxl.worksheet._reader'

  #41 opened 6 years ago by ftune
  2