column "{colId}" has mixed or ambiguous values and was inferred as "text". Declare `type` on the column to get correct sorting, filtering and export.

Warnings reference › infer:*

Identifier

infer:*

Raised by

The grid (core)

Since

1.0.1

What happened

Informational. The grid sampled the column's values and none of the candidate types matched all of them, so it fell back to text. A text column sorts lexically (so 10 comes before 9), filters with text operators, and exports as a string - which is rarely what a column of mixed numbers and blanks was meant to do.

The fix

Declare the column's type. The inference is only ever a convenience for data whose shape is not known in advance.

The smallest fix

columns: [{ id: 'qty', type: 'number' }]

Reference

Covered in full at the API reference.