OptionalformulaA reference to the cell that the text comes from, for example Sheet1!$B$1.
OptionaltextPlain text. Paragraphs are separated by line feeds (\n), which count toward run offsets.
When formula is present, this is only an optional cache of the cell's text.
Text shown in a chart, such as a title or a series name.
The text is either literal, in
text, or taken from a cell throughformula. With a formula,textis only an optional cache of the cell's text, which can be missing or out of date: a renderer evaluates the formula.