Function evaluateFilter

buffer.go:851–912

evaluateFilter checks if a cell value matches the filter query based on the operator.

(cellValue string, options FilterOptions, colType int)

// evaluateFilter checks if a cell value matches the filter query based on the operator.
func evaluateFilter(cellValue string, options FilterOptions, colType int) bool {
	query := options.Query
	operator := options.Operator

	// Handle numeric comparisons first
	if colType == colTypeFloat || colType == colTypeDate {
		isNumericOperator := false
		switch operator {
		case ">", "<", ">=", "<=":
			isNumericOperator = true
		}

		if isNumericOperator {
			cellVal := parseNumericValueFast(cellValue)
			thresholdVal, err := strconv.ParseFloat(strings.TrimSpace(query), 64)
			if err != nil {
				return false // Cannot compare if query is not a number
			}

			switch operator {
			case ">":
				return cellVal > thresholdVal
			case "<":
				return cellVal < thresholdVal
			case ">=":
				return cellVal >= thresholdVal
			case "<=":
				return cellVal <= thresholdVal
			}
		}
	}

	// Prepare strings for comparison
	cell := cellValue
	q := query
	if !options.CaseSensitive {
		cell = strings.ToLower(cell)
		q = strings.ToLower(q)
	}

	// Handle string-based operators
	switch operator {
	case "contains":
		return strings.Contains(cell, q)
	case "equals":
		return cell == q
	case "starts with":
		return strings.HasPrefix(cell, q)
	case "ends with":
		return strings.HasSuffix(cell, q)
	case "regex":
		// When using regex, the user has full control over case sensitivity in the pattern.
		re, err := regexp.Compile(options.Query)
		if err != nil {
			return false // Invalid regex
		}
		return re.MatchString(cellValue)
	default: