Module value 

Cell values and Excel’s coercion and comparison rules.

Structs

Array

A 2-D array of values (row-major). Always at least 1×1.

Enums

CellError

Excel’s error values.

Value

A cell value or an intermediate formula result.

Functions

compare

Excel’s comparison for =, <… operators. Text compares case-insensitively; empty acts as 0, “” or FALSE depending on the other side. Errors are handled by the caller.

compare_numbers

Compares numbers the way Excel does: both are rounded to 15 significant digits first, so binary noise such as 0.1+0.2 versus 0.3 counts as equal.

compare_text

Case-insensitive text order (Unicode lowercase).

number_to_text

Number → text the way Excel converts in & and TEXT(x,"General")-free contexts: up to 15 significant digits, scientific for very large or very small magnitudes.

sci_text

Scientific text like 1.23456789012346E+15 with up to sig significant digits.

sort_compare

Sorting order used by Sort (ascending): numbers, text, booleans, errors, then blanks last.

trim_decimal

Removes trailing zeros (and a trailing point) from a decimal string.