Utility for estimating rendered cell content size based on formatting so you can choose column widths that fit values without truncation.
Definition
Namespace:Telerik.Documents.SpreadsheetStreaming
Assembly:Telerik.Documents.SpreadsheetStreaming.dll
Syntax:
public static class CellContentSizeHelperInheritance: objectCellContentSizeHelper
Methods
Calculates the rendered size of cell content using its formatting so you can derive an appropriate column width for the value.
public static Size GetCellContentSize(string value, SpreadCellFormat spreadCellFormat, double cellWidth = 65)The cell value. If formula is passed the method will throw an ArgumentException.
spreadCellFormatSpreadCellFormatThe format of the cell.
cellWidthdoubleThe width of the cell in pixels. This value is only respected if the value of the WrapText property of the spreadCellFormat is true. The default column width is 65 pixels.
Returns:The size of the cell content.
Calculates the rendered size of cell content using explicit formatting parameters, enabling custom sizing logic outside a worksheet.
public static Size GetCellContentSize(string value, string cellValueFormat, string fontFamily, double fontSize, bool isBold, bool isItalic, SpreadHorizontalAlignment horizontalAlignment, bool isWrapped, int indent, double cellWidth = 65)The cell value. If formula is passed the method will throw an ArgumentException.
cellValueFormatstringThe number format of the cell.
fontFamilystringThe font family.
fontSizedoubleThe size of the font in points.
isBoldboolA value indicating whether the text is bold.
isItalicboolA value indicating whether the text is italic.
horizontalAlignmentSpreadHorizontalAlignmentThe horizontal alignment.
isWrappedboolA value indicating whether the text is wrapped.
indentintThe cell indent.
cellWidthdoubleThe width of the cell in pixels. This value is only respected if the value of isWrapped is true. The default column width is 65 pixels.
Returns:The size of the cell content.