Skip to main content

SetSpacingAfter

Sets the spacing after the current paragraph.

If the value of the isAfterAuto parameter is true, then any value of the nAfter is ignored. If isAfterAuto parameter is not specified, then it will be interpreted as false.

Inherited from ApiParaPr.SetSpacingAfter.

Syntax​

expression.SetSpacingAfter(nAfter, isAfterAuto);

expression - A variable that represents an ApiParagraph class.

Parameters​

NameRequired/OptionalData typeDefaultDescription
nAfterRequiredtwipsThe value of the spacing after the current paragraph measured in twentieths of a point (1/1440 of an inch).
isAfterAutoOptionalbooleanfalseThe true value disables the spacing after the current paragraph.

Returns​

boolean

Example​

Add extra space below a paragraph inside a shape in a spreadsheet.

// How do I increase the gap between a paragraph and the one that follows it in a spreadsheet?

// Push the next paragraph down by setting a bottom margin on the current paragraph 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);
paragraph.AddText("This is an example of setting a space after a paragraph. ");
paragraph.AddText("The second paragraph will have an offset of one inch from the top. ");
paragraph.AddText("This is due to the fact that the first paragraph has this offset enabled.");
paragraph.SetSpacingAfter(1440);
paragraph = Api.CreateParagraph();
paragraph.AddText("This is the second paragraph and it is one inch away from the first paragraph.");
content.Push(paragraph);