format strings independent of the cell style.
fmt_txt(
x,
bold = FALSE,
italic = FALSE,
underline = FALSE,
strike = FALSE,
size = NULL,
color = NULL,
font = NULL,
charset = NULL,
outline = NULL,
vertAlign = NULL
)a string or part of a string
bold
italic
underline
strike
the font size
a wbColor color for the font
the font name
integer value from the table below
TRUE or FALSE
baseline, superscript, or subscript
The result is an xml string. It is possible to paste multiple fmt_txt()
strings together to create a string with differing styles.
| "Value" | "Character Set" |
| "0" | "ANSI_CHARSET" |
| "1" | "DEFAULT_CHARSET" |
| "2" | "SYMBOL_CHARSET" |
| "77" | "MAC_CHARSET" |
| "128" | "SHIFTJIS_CHARSET" |
| "129" | "HANGUL_CHARSET" |
| "130" | "JOHAB_CHARSET" |
| "134" | "GB2312_CHARSET" |
| "136" | "CHINESEBIG5_CHARSET" |
| "161" | "GREEK_CHARSET" |
| "162" | "TURKISH_CHARSET" |
| "163" | "VIETNAMESE_CHARSET" |
| "177" | "HEBREW_CHARSET" |
| "178" | "ARABIC_CHARSET" |
| "186" | "BALTIC_CHARSET" |
| "204" | "RUSSIAN_CHARSET" |
| "222" | "THAI_CHARSET" |
| "238" | "EASTEUROPE_CHARSET" |
| "255" | "OEM_CHARSET" |
fmt_txt("bar", underline = TRUE)
Run the code above in your browser using DataLab