TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

GetSpacing

GetSpacing() → { twips }

Gets the text spacing from the current text properties measured in twentieths of a point.

Parameters:

This method doesn't have any parameters.

Returns:

Type
twips

Example

Copy code
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 oRun = Api.CreateRun();
oRun.AddText("This is just a sample text. ");
oRun.AddText("The text properties are changed and the style is added to the paragraph. ");
oRun.AddLineBreak();
oParagraph.AddElement(oRun);
var oTextPr = oRun.GetTextPr();
oTextPr.SetSpacing(80);
oParagraph = Api.CreateParagraph();
var nSpacing = oTextPr.GetSpacing();
oParagraph.AddText("Text spacing: " + nSpacing);
oDocContent.Push(oParagraph);
builder.SaveFile("xlsx", "GetSpacing.xlsx");
builder.CloseFile();

Resulting document