Adjust text overflow in cells
When Spreadsheet is rendered overflowed text inside the cell overlays subsequent cells until it meets non-empty cell. GroupDocs.Viewer provides a setting to configure the mode which will be used for rendering overflowed text:
- To set the overflowed text to be hidden, set SpreadsheetOptions.TextOverflowMode of HtmlViewOptions class to HideText as shown in the example below.
- To set the overflowed text to overlay subsequent cells until it meets non empty cell, set SpreadsheetOptions.TextOverflowMode of HtmlViewOptions object to OverlayIfNextIsEmpty. This is a default value.
- To set the overflowed text to overlay subsequent cells even they are not empty, set SpreadsheetOptions.TextOverflowMode of HtmlViewOptions objectto Overlay.
- To expand the cell width to fit overflowed text, set SpreadsheetOptions.TextOverflowMode of HtmlViewOptions object to AutoFitColumn.
NOTE: The same workflow is applicable for JpgViewOptions, PngViewOptions, and PdfViewOptions classes;
How to adjust text overflow in cells
The following steps are required to manage text-overflow:
- Instantiate the HtmlViewOptions (or JpgViewOptions, or PngViewOptions, or PdfViewOptions) object;
- Set HtmlViewOptions.SpreadsheetOptions.TextOverflowMode to HideText;
- Call View method.
The following code sample shows how to hide text in case it overflows cell.
using (Viewer viewer = new Viewer("sample.xlsx"))
{
HtmlViewOptions viewOptions = HtmlViewOptions.ForEmbeddedResources();
viewOptions.SpreadsheetOptions.TextOverflowMode = TextOverflowMode.HideText;
viewer.View(viewOptions);
}