Excel.ShapeAutoSize enum

Package:

excel

Determines the type of automatic sizing allowed.

Remarks

[ API set: ExcelApi 1.9 ]

Examples

TypeScript

// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/44-shape/shape-textboxes.yaml

await Excel.run(async (context) => {
    const shapes = context.workbook.worksheets.getItem("Shapes").shapes;
    const textbox = shapes.getItem("Textbox");
    textbox.textFrame.autoSizeSetting = Excel.ShapeAutoSize.autoSizeShapeToFitText;
    await context.sync();
});

Fields

autoSizeMixed = "AutoSizeMixed"	A combination of automatic sizing schemes are used. [ API set: ExcelApi 1.9 ]
autoSizeNone = "AutoSizeNone"	No autosizing. [ API set: ExcelApi 1.9 ]
autoSizeShapeToFitText = "AutoSizeShapeToFitText"	The shape is adjusted to fit the text. [ API set: ExcelApi 1.9 ]
autoSizeTextToFitShape = "AutoSizeTextToFitShape"	The text is adjusted to fit the shape. [ API set: ExcelApi 1.9 ]