Module display 

How cells look as text: number formats applied, for the grid, clipboard, CSV and agents.

Structs

Stats

Status-bar statistics for a selection: average, count (non-empty), numerical count, min, max, sum.

Functions

cell_text

The text a cell shows (full precision General; the grid narrows General to fit the column).

edit_text

What the cell editor and the formula bar start from. Same as Cell::input_text, except that a constant number in a date or time format is shown as a date (as the grid shows it), not as its serial. When the formatted text would not read back as the same date (for example dddd, mmmm d), an ISO yyyy-mm-dd (with hh:mm:ss for a time of day; just hh:mm:ss for a time alone) is used instead, and if even that would not read back, the serial.

format

Formats a value with a format code.

formula_hidden

Whether c has a formula or Python code that must not be shown: its cell is formatted Hidden on a protected sheet. A spilled cell follows its anchor.

number_format

range_text

Tab-separated text of a range, as the system clipboard gets it.

stats

value_text

A cell’s value with its number format applied, independent of column width: no ##### and no General narrowing (Save As CSV/Text writes this). Formulas give their result.

value_text_as

value_text for a value and a format code given apart from a cell (print takes the code from the cell’s effective look, which a conditional format can override).