ExcelScript.ShapeAutoSize enum
Determines the type of automatic sizing allowed.
Remarks
Examples
/**
* This script creates a star shape with the value from cell A1.
*/
function main(workbook: ExcelScript.Workbook) {
// Get the value of A1 from the worksheet named Sheet1.
const sheet = workbook.getWorksheet("Sheet1");
const value = sheet.getRange("A1").getValue();
// Create a Shape object that looks like a 5-pointed star.
const star = sheet.addGeometricShape(ExcelScript.GeometricShapeType.star5);
// Set the text of star and make sure the shape fits the text.
const textFrame = star.getTextFrame();
textFrame.getTextRange().setText(value.toString());
textFrame.setAutoSizeSetting(ExcelScript.ShapeAutoSize.autoSizeShapeToFitText);
}
Fields
autoSizeMixed | A combination of automatic sizing schemes are used. |
autoSizeNone | No autosizing. |
autoSizeShapeToFitText | The shape is adjusted to fit the text. |
autoSizeTextToFitShape | The text is adjusted to fit the shape. |