Skip to main content

CreateNumbering

Creates a bullet for a paragraph with the numbering character or symbol specified with the numType parameter.

Syntax

expression.CreateNumbering(numType, startAt);

expression - A variable that represents a Api class.

Parameters

NameRequired/OptionalData typeDefaultDescription
numTypeRequiredBulletTypeThe numbering type the paragraphs will be numbered with.
startAtRequirednumberThe number the first numbered paragraph will start with.

Returns

ApiBullet

Example

Add sequential numbered markers to paragraphs to form a numbered list in a spreadsheet.

// How do I automatically number each paragraph in a list inside a shape in a spreadsheet?

// Turn separate paragraphs into an ordered list by attaching numbered labels to each one 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, 35 * 36000, fill, stroke, 0, 2 * 36000, 0, 3 * 36000);
let docContent = shape.GetContent();
let paragraph = docContent.GetElement(0);
let bullet = Api.CreateNumbering("ArabicParenR", 1);
paragraph.SetBullet(bullet);
paragraph.AddText(" This is an example of the numbered paragraph.");
paragraph = Api.CreateParagraph();
paragraph.SetBullet(bullet);
paragraph.AddText(" This is an example of the numbered paragraph.");
docContent.Push(paragraph);