Skip to main content

SetCaps

Specifies that any lowercase characters in the text run are formatted for display only as their capital letter character equivalents.

Syntax

expression.SetCaps(isCaps);

expression - A variable that represents a ApiTextPr class.

Parameters

NameRequired/OptionalData typeDefaultDescription
isCapsRequiredbooleanSpecifies that the contents of the current run are displayed capitalized.

Returns

ApiTextPr

Example

Display all text characters as capital letters without changing the underlying content in a spreadsheet.

// How do I make every letter in a text run appear as an uppercase character in a spreadsheet?

// Force a text run to render in all-caps style for a consistent visual look in a spreadsheet.

let worksheet = Api.GetActiveSheet();
let fill = Api.CreateSolidFill(Api.RGB(255, 111, 61));
let stroke = Api.CreateStroke(0, Api.CreateNoFill());
let shape = worksheet.AddShape("flowChartOnlineStorage", 120 * 36000, 70 * 36000, fill, stroke, 0, 2 * 36000, 0, 3 * 36000);
let content = shape.GetContent();
let paragraph = content.GetElement(0);
let run = Api.CreateRun();
let textProps = run.GetTextPr();
textProps.SetFontSize(30);
textProps.SetCaps(true);
paragraph.SetJc("left");
run.AddText("This is a sample text inside the shape set to capital letters using the text properties.");
paragraph.AddElement(run);