{"record":{"id":"12cf869e930f2920","repo":"qax-os/excelize","slug":"the-operator-q-in-expression-q-is-not-valid-in-r","errorCode":null,"errorMessage":"the operator %q in expression %q is not valid in relation to Blanks/NonBlanks","messagePattern":"the operator %q in expression %q is not valid in relation to Blanks/NonBlanks","errorType":"validation","errorClass":null,"httpStatus":null,"severity":"error","filePath":"errors.go","lineNumber":267,"sourceCode":"\treturn fmt.Errorf(\"field %s must be less than or equal to 255 characters\", name)\n}\n\n// newInvalidAutoFilterColumnError defined the error message on receiving the\n// incorrect index of column.\nfunc newInvalidAutoFilterColumnError(col string) error {\n\treturn fmt.Errorf(\"incorrect index of column %q\", col)\n}\n\n// newInvalidAutoFilterExpError defined the error message on receiving the\n// incorrect number of tokens in criteria expression.\nfunc newInvalidAutoFilterExpError(exp string) error {\n\treturn fmt.Errorf(\"incorrect number of tokens in criteria %q\", exp)\n}\n\n// newInvalidAutoFilterOperatorError defined the error message on receiving the\n// incorrect expression operator.\nfunc newInvalidAutoFilterOperatorError(op, exp string) error {\n\treturn fmt.Errorf(\"the operator %q in expression %q is not valid in relation to Blanks/NonBlanks\", op, exp)\n}\n\n// newInvalidCellNameError defined the error message on receiving the invalid\n// cell name.\nfunc newInvalidCellNameError(cell string) error {\n\treturn fmt.Errorf(\"invalid cell name %q\", cell)\n}\n\n// newInvalidColumnNameError defined the error message on receiving the\n// invalid column name.\nfunc newInvalidColumnNameError(col string) error {\n\treturn fmt.Errorf(\"invalid column name %q\", col)\n}\n\n// newInvalidExcelDateError defined the error message on receiving the data\n// with negative values.\nfunc newInvalidExcelDateError(dateValue float64) error {\n\treturn fmt.Errorf(\"invalid date value %f, negative values are not supported\", dateValue)","sourceCodeStart":249,"sourceCodeEnd":285,"githubUrl":"https://github.com/qax-os/excelize/blob/f2483381fbfbe432a6baa98d48a1c277183f3285/errors.go#L249-L285","documentation":"Error from newInvalidAutoFilterOperatorError, raised by parseFilterTokens when a criteria uses the Blanks/NonBllanks operand with an operator that cannot combine with it (e.g. >, <, >= with blanks); at fault is the operator/operand pair in the filter expression.","triggerScenarios":"Thrown at errors.go:267 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":["Use '=' or '!=' style operators with Blanks/NonBlanks","Express blank tests via the equals operator only"],"exampleFix":null,"handlingStrategy":"validation","validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"f2483381fbfbe432a6baa98d48a1c277183f3285","analyzedAt":"2026-09-02T01:26:19.299Z","contentChangedAt":null,"schemaVersion":2},"datasetVersion":"2026-09-09T06:17:21.866Z"}