Get Started
Usage API
More information

GetSpacingBefore

GetSpacingBefore() → { twips }

Get the spacing before value of the current paragraph.

Parameters:

This method doesn't have any parameters.

Returns:

Type
twips

Example

Copy code
builder.CreateFile("xlsx");
oWorksheet = Api.GetActiveSheet();
oFill = Api.CreateSolidFill(Api.CreateRGBColor(104, 155, 104));
oStroke = Api.CreateStroke(0, Api.CreateNoFill());
oShape = oWorksheet.AddShape("flowChartOnlineStorage", 200 * 36000, 60 * 36000, oFill, oStroke, 0, 2 * 36000, 0, 3 * 36000);
oDocContent = oShape.GetDocContent();
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.");
oParagraph2 = Api.CreateParagraph();
oParagraph2.AddText("This is the second paragraph and it is one inch away from the first paragraph.");
oDocContent.Push(oParagraph2);
oParaPr = oParagraph2.GetParaPr();
oParaPr.SetSpacingBefore(1440);
nSpacingBefore = oParaPr.GetSpacingBefore();
oParagraph = Api.CreateParagraph();
oParagraph.AddText("Spacing before: " + nSpacingBefore);
oDocContent.Push(oParagraph);
builder.SaveFile("xlsx", "GetSpacingBefore.xlsx");
builder.CloseFile();

Resulting document