Enum WrapStrategy
Stay organized with collections
Save and categorize content based on your preferences.
WrapStrategy
An enumeration of the strategies used to handle cell text wrapping.
To call an enum, you call its parent class, name, and property. For example,
SpreadsheetApp.WrapStrategy.WRAP
.
Properties
Property | Type | Description |
WRAP | Enum | Wrap lines that are longer than the cell width onto a new line. Single words that are longer
than a line are wrapped at the character level. |
OVERFLOW | Enum | Overflow lines into the next cell, so long as that cell is empty. If the next cell over is
non-empty, this behaves the same as CLIP . |
CLIP | Enum | Clip lines that are longer than the cell width. |
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-02 UTC.
[null,null,["Last updated 2024-12-02 UTC."],[[["\u003cp\u003e\u003ccode\u003eWrapStrategy\u003c/code\u003e is used to control how text wraps within a cell in Google Sheets.\u003c/p\u003e\n"],["\u003cp\u003e\u003ccode\u003eWRAP\u003c/code\u003e wraps text to new lines within the cell, \u003ccode\u003eOVERFLOW\u003c/code\u003e extends text to the next cell if empty, and \u003ccode\u003eCLIP\u003c/code\u003e cuts off overflowing text.\u003c/p\u003e\n"],["\u003cp\u003eAccess these options using \u003ccode\u003eSpreadsheetApp.WrapStrategy\u003c/code\u003e followed by the desired property like \u003ccode\u003eWRAP\u003c/code\u003e, \u003ccode\u003eOVERFLOW\u003c/code\u003e, or \u003ccode\u003eCLIP\u003c/code\u003e.\u003c/p\u003e\n"]]],[],null,["# Enum WrapStrategy\n\nWrapStrategy\n\nAn enumeration of the strategies used to handle cell text wrapping.\n\nTo call an enum, you call its parent class, name, and property. For example, `\nSpreadsheetApp.WrapStrategy.WRAP`. \n\n### Properties\n\n| Property | Type | Description |\n|------------|--------|----------------------------------------------------------------------------------------------------------------------------------------------|\n| `WRAP` | `Enum` | Wrap lines that are longer than the cell width onto a new line. Single words that are longer than a line are wrapped at the character level. |\n| `OVERFLOW` | `Enum` | Overflow lines into the next cell, so long as that cell is empty. If the next cell over is non-empty, this behaves the same as `CLIP`. |\n| `CLIP` | `Enum` | Clip lines that are longer than the cell width. |"]]