Indicates whether the font size of the text contained in a cell is automatically adjusted to fit the cell width.
true, if the cell text size should be adjusted; otherwise, false.
If the ShrinkToFit property is enabled, the size of the text font in a cell will be automatically adjusted when the cell text length or column width is changed .
- When adding text in a cell or decreasing the column width, the cell text will be automatically shrunk until it is completely visible within the cell.
- When removing text from a cell or increasing the column width, the cell text will be automatically widened, maxing out at the initial font size applied in a cell.
Note that the size of the font applied in a cell is not changed. If the text contains multiple lines, the ShrinkToFit property is not applicable.
If you wish to adjust the column width to fit the cell content instead of resizing the cell text font, use the Column.AutoFit method.
To set other alignment characteristics for a cell or range of cells (e.g., horizontal and vertical alignment type, indent, text rotation and wrapping), use the corresponding properties of the Alignment object. Access this object via the Formatting.Alignment property.
- To specify the data alignment of an individual cell, access the Alignment object using the cell's Formatting.Alignment property directly.
- To specify the data alignment of a cell range, modify the Alignment object within the CellRange.BeginUpdateFormatting - CellRange.EndUpdateFormatting method pair.
- To share the same alignment settings between multiple cells in one step, apply the style with the specified alignment to the required cells. To specify the alignment for a cell style, access the Style object from the IWorkbook.Styles collection and use this style's Formatting.Alignment property within the Formatting.BeginUpdate-Formatting.EndUpdate paired methods to access and modify the Alignment object.
Currently, the ShrinkToFit option is not taken into account on rendering cell content in the SpreadsheetControl. However, this property value is saved to a file, so you can use Microsoft Excel or another spreadsheet application to view and print a document.
Cell cellA1 = worksheet.Cells["A1"]; cellA1.Value = "Right and top"; cellA1.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Right; cellA1.Alignment.Vertical = SpreadsheetVerticalAlignment.Top; Cell cellA2 = worksheet.Cells["A2"]; cellA2.Value = "Center"; cellA2.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center; cellA2.Alignment.Vertical = SpreadsheetVerticalAlignment.Center; Cell cellA3 = worksheet.Cells["A3"]; cellA3.Value = "Left and bottom, indent"; cellA3.Alignment.Indent = 1; Cell cellB1 = worksheet.Cells["B1"]; cellB1.Value = "The Alignment.ShrinkToFit property is applied"; cellB1.Alignment.ShrinkToFit = true; Cell cellB2 = worksheet.Cells["B2"]; cellB2.Value = "Rotated Cell Contents"; cellB2.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center; cellB2.Alignment.Vertical = SpreadsheetVerticalAlignment.Center; cellB2.Alignment.RotationAngle = 15; Cell cellB3 = worksheet.Cells["B3"]; cellB3.Value = "The Alignment.WrapText property is applied to wrap the text within a cell"; cellB3.Alignment.WrapText = true;