Sets the paragraph line spacing. If the value of the sLineRule parameter is either "atLeast" or "exact", then the value of nLine will be interpreted as twentieths of a point. If the value of the sLineRule parameter is "auto", then the value of the nLine parameter will be interpreted as 240ths of a line.
Name | Type | Description |
nLine | twips | line240 | The line spacing value measured either in twentieths of a point (1/1440 of an inch) or in 240ths of a line. |
sLineRule | "auto" | "atLeast" | "exact" | The rule that determines the measuring units of the line spacing. |
builder.CreateFile("xlsx"); 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); var oParaPr = oParagraph.GetParaPr(); oParaPr.SetSpacingLine(3 * 240, "auto"); oParagraph.AddText("Paragraph 1. Spacing: 3 times of a common paragraph line spacing."); oParagraph.AddLineBreak(); oParagraph.AddText("These sentences are used to add lines for demonstrative purposes. "); oParagraph.AddText("These sentences are used to add lines for demonstrative purposes. "); builder.SaveFile("xlsx", "SetSpacingLine.xlsx"); builder.CloseFile();