openpyxl icon indicating copy to clipboard operation
openpyxl copied to clipboard

Not a valid coordinate or range

Open lindev0915 opened this issue 3 years ago • 0 comments

=IFERROR(VLOOKUP(A8,temptb!$A$1:$Z$37,temptb!H$1,FALSE),"")

def compute_cell_value(input: Union[Cell, Tuple]):
    if isinstance(input, Tuple):
        return tuple(map(compute_cell_value, input))
    if not has_formula(input):
        return input.value

    func = formulas.Parser().ast(input.value)[1].compile()
    args = []
    sheet = input.parent

    for key in func.inputs.keys():
        args.append(compute_cell_value(sheet[key]))
    return func(*args)

Please check this formula and function. The error is occur from args.append(compute_cell_value(sheet[key])) It's not getting the value from other sheet.

lindev0915 avatar Aug 06 '21 06:08 lindev0915