Skip to content

xeq

Excel-style equality (text-aware coercion).

c = xeq(A, B)

Equivalent to Excel’s = comparison. Differs from eq in how it coerces types — xeq('1', 1) returns true in Excel-compat mode (text-to-number coercion). Used internally by the spreadsheet formula engine when the script-mode == semantics aren’t appropriate.

xeq(3, 3.0) % true
xeq('apple', 'apple') % true
  • eq — Element-wise equality test (function form of ==).
  • xne — Excel-style inequality.