Method cellResolver

calc.go:1656–1713

cellResolver calc cell value by given worksheet name, cell reference and context.

(ctx *calcContext, sheet, cell string)

// cellResolver calc cell value by given worksheet name, cell reference and context.
func (f *File) cellResolver(ctx *calcContext, sheet, cell string) (formulaArg, error) {
	var (
		arg   formulaArg
		value string
		err   error
	)
	ref := sheet + "!" + cell
	if cached, ok := f.formulaArgCache.Load(ref); ok {
		return cached.(formulaArg), err
	}

	if formula, _ := f.getCellFormula(sheet, cell, true); len(formula) != 0 {
		ctx.mu.Lock()
		if ctx.entry != ref {
			if ctx.iterations[ref] <= f.options.MaxCalcIterations {
				ctx.iterations[ref]++
				ctx.mu.Unlock()
				arg, _ = f.calcCellValue(ctx, sheet, cell)
				ctx.iterationsCache[ref] = arg
				f.formulaArgCache.Store(ref, arg)
				return arg, nil
			}
			ctx.mu.Unlock()
			return ctx.iterationsCache[ref], nil
		}
		ctx.mu.Unlock()
	}
	if value, err = f.GetCellValue(sheet, cell, Options{RawCellValue: true}); err != nil {
		return arg, err
	}
	arg = newStringFormulaArg(value)
	cellType, _ := f.GetCellType(sheet, cell)
	switch cellType {
	case CellTypeBool:
		arg = arg.ToBool()
	case CellTypeNumber, CellTypeUnset:
		if arg.Value() == "" {
			arg = newEmptyFormulaArg()
		} else {
			arg = arg.ToNumber()
		}
	case CellTypeInlineString, CellTypeSharedString:
	case CellTypeFormula:
		if value == "" {
			arg = newEmptyFormulaArg()
		}
	case CellTypeDate:
		if value, err = f.GetCellValue(sheet, cell); err == nil {
			if num := newStringFormulaArg(value).ToNumber(); num.Type == ArgNumber {
				arg = num
			}
		}
	default:
		arg = newErrorFormulaArg(value, value)
	}
	f.formulaArgCache.Store(ref, arg)
	return arg, err
}