RIGHTB Function (Gnumeric)

• Introduced: Introduced in Gnumeric 1.9.10 release notes.
• Supported in: Registered in Gnumeric 1.12.62; no retirement is established.
• Last functioning version: Selected calculations are verified in 1.12.57. The newest functioning release is unverified; source registration in 1.12.62 does not establish newer runtime results.
• Scope: Desktop Gnumeric with its String Functions plugin. English comma-separated formulas are shown.
• Checked: October 14, 2026. Tables use 1.12.57 ssconvert under C.UTF-8; 1.12.62 was source-inspected only.

RIGHTB returns complete characters from the end of a UTF-8 string, using at most the specified byte budget. If the proposed start lies inside a multibyte character, the result starts after that character. The function does not return a fragment of its encoding. Versioned function help.

=RIGHTB(text[,num_bytes])

• text: Required source text.
• num_bytes: Optional maximum bytes to retain; default 1. Negative counts give #VALUE!; positive fractions are truncated in the selected tests.

Brackets indicate optional arguments; do not type them. Current worksheet implementation.

The native column records recalculated CSV field content. Quotes delimit readable text; "" means an empty field expected to be text from the callback. They do not certify the exported cell type. The independent column checks the stated character mapping, UTF-8 byte operation or decimal conversion.

For Lévy, the suffix vy uses two bytes. Both =RIGHTB("Lévy",2) and =RIGHTB("Lévy",3) return vy: the three-byte budget cannot fit the two-byte é plus v and y. Four bytes are enough for évy. This is useful only when a receiving field’s limit is expressed in UTF-8 bytes.

The saved =LEFTB("A中B",1)&RIGHTB("A中B",4) reconstructs A中B. The first part is the one-byte A; the second is the three-byte 中 plus the one-byte B. The boundary is deliberate.

For A😀B, a four-byte suffix budget returns B, while five bytes return 😀B. Bytes 2–5 all belong to the same emoji. Check whether the shortened suffix still distinguishes records before using it as an identifier.

A missing count means one byte, not one Unicode character: =RIGHTB("é") returns empty text. Use RIGHT for a character-based requirement. Zero gives empty text and a budget beyond the source length returns the whole string. The selected 3.9-byte case uses three bytes.

F2 contains Lévy; F5 is genuinely blank. The boundary protection covers code points, not complete visual grapheme clusters. A separately encoded combining accent can still be separated from its base letter.

The source snapshots and native results below were retained from October 14, 2026. The recovered guide was checked against those saved records on October 15; neither the application nor a newer release was executed again.

• Current worksheet callback
• Tested-version worksheet callback

The complete RIGHTB callback is byte-identical between the two inspected releases. Both stale and uncached SUM controls recalculated correctly. Saved native XML retains the function identities. No GUI result display, other locale, native output-type certification or newer-release execution is claimed.

RIGHT, LEFT, LEN.