SetSpacingBefore(nBefore, [isBeforeAuto])

Sets the spacing before the current paragraph. If the value of the isBeforeAuto parameter is true, then any value of the nBefore is ignored. If isBeforeAuto parameter is not specified, then it will be interpreted as false.


Name Type Default Description
nBefore twips

The value of the spacing before the current paragraph measured in twentieths of a point (1/1440 of an inch).

isBeforeAuto boolean false

The true value disables the spacing before the current paragraph.


This method doesn't return any data.


Copy code
var oWorksheet = Api.GetActiveSheet();
var oFill = Api.CreateSolidFill(Api.CreateRGBColor(255, 111, 61));
var oStroke = Api.CreateStroke(0, Api.CreateNoFill());
var oShape = oWorksheet.AddShape("flowChartOnlineStorage", 120 * 36000, 70 * 36000, oFill, oStroke, 0, 2 * 36000, 0, 3 * 36000);
var oDocContent = oShape.GetContent();
var oParagraph = oDocContent.GetElement(0);
oParagraph.AddText("This is an example of setting a space before a paragraph. ");
oParagraph.AddText("The second paragraph will have an offset of one inch from the top. ");
oParagraph.AddText("This is due to the fact that the second paragraph has this offset enabled.");
oParagraph = Api.CreateParagraph();
var oParaPr = oParagraph.GetParaPr();
oParagraph.AddText("This is the second paragraph and it is one inch away from the first paragraph.");
builder.SaveFile("xlsx", "SetSpacingBefore.xlsx");

Resulting document