Documentation

Class CellContentSizeHelper

Represents a helper class for measuring the cell content size.

Inheritance
System.Object
CellContentSizeHelper
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Telerik.Documents.SpreadsheetStreaming
Assembly: Telerik.Documents.SpreadsheetStreaming.dll

Syntax

public static class CellContentSizeHelper

Methods

GetCellContentSize(String, String, String, Double, Boolean, Boolean, SpreadHorizontalAlignment, Boolean, Int32, Double)

The method calculates the cell content size based on the cell formatting. The result can be used to set the column width so the values can fit in the columns.

Declaration
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)
Parameters
System.String value

The cell value. If formula is passed the method will throw an ArgumentException.
System.String cellValueFormat

The number format of the cell.
System.String fontFamily

The font family.
System.Double fontSize

The size of the font in points.
System.Boolean isBold

A value indicating whether the text is bold.
System.Boolean isItalic

A value indicating whether the text is italic.
SpreadHorizontalAlignment horizontalAlignment

The horizontal alignment.
System.Boolean isWrapped

A value indicating whether the text is wrapped.
System.Int32 indent

The cell indent.
System.Double cellWidth

The 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
System.Windows.Size

The size of the cell content.

GetCellContentSize(String, SpreadCellFormat, Double)

The method calculates the cell content size based on the cell formatting. The result can be used to set the column width so the values can fit in the columns.

Declaration
public static Size GetCellContentSize(string value, SpreadCellFormat spreadCellFormat, double cellWidth = 65)
Parameters
System.String value

The cell value. If formula is passed the method will throw an ArgumentException.
SpreadCellFormat spreadCellFormat

The format of the cell.
System.Double cellWidth

The 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
System.Windows.Size

The size of the cell content.