Class RichTextValueBuilder

// Creates a Rich Text value for the text "foo no baz" with "foo" pointing to // "https://bar.foo" and "baz" to "https://abc.xyz". // "foo" is underlined with the default link color, whereas "baz" has its text // style overridden by a call to `setTextStyle`, and is therefore black and bold // with no underlining. const boldStyle = SpreadsheetApp.newTextStyle()                       .setUnderline(false)                       .setBold(true)                       .setForegroundColor('#000000')                       .build(); const value = SpreadsheetApp.newRichTextValue()                   .setText('foo no baz')                   .setLinkUrl(0, 3, 'https://bar.foo')                   .setLinkUrl(7, 10, 'https://abc.xyz')                   .setTextStyle(7, 10, boldStyle)                   .build();

// Creates a Rich Text value for the text "Foo" which points to // "https://bar.foo". const value = SpreadsheetApp.newRichTextValue()                   .setText('Foo')                   .setLinkUrl('https://bar.foo')                   .build();

// Creates a Rich Text value for the text "HelloWorld", with "Hello" bolded, and // "World" italicized. const bold = SpreadsheetApp.newTextStyle().setBold(true).build(); const italic = SpreadsheetApp.newTextStyle().setItalic(true).build(); const value = SpreadsheetApp.newRichTextValue()                   .setText('HelloWorld')                   .setTextStyle(0, 5, bold)                   .setTextStyle(5, 10, italic)                   .build();

// Creates a Rich Text value for the text "HelloWorld" with "Hello" bolded and // italicized, and "World" only italicized. const bold = SpreadsheetApp.newTextStyle().setBold(true).build(); const italic = SpreadsheetApp.newTextStyle().setItalic(true).build(); const value = SpreadsheetApp.newRichTextValue()                   .setText('HelloWorld')                   .setTextStyle(0, 5, bold)                   .setTextStyle(italic)                   .build();