Documentation

Class FormatHelper

Defines auxiliary formatting methods.

Inheritance
System.Object
FormatHelper
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.Windows.Documents.Spreadsheet.Formatting
Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public static class FormatHelper

Fields

StartDate

Defines the earliest date the RadSpreadsheet recognizes.

Declaration
public static readonly DateTime StartDate
Field Value
System.DateTime

Properties

CultureHelper

Gets or sets the spreadsheet culture helper.

Declaration
public static SpreadsheetCultureHelper CultureHelper { get; set; }
Property Value
SpreadsheetCultureHelper

Methods

ConvertDateTimeToDouble(DateTime)

Converts a DateTime instance to double.

Declaration
public static double ConvertDateTimeToDouble(DateTime dateTime)
Parameters
System.DateTime dateTime

The DateTime instance.
Returns
System.Double

The double number.

ConvertDoubleToDateTime(Double)

Converts a double number to DateTime.

Declaration
public static DateTime? ConvertDoubleToDateTime(double doubleValue)
Parameters
System.Double doubleValue

The double value.
Returns
System.Nullable<System.DateTime>

The DateTime instance.

RoundMilliseconds(DateTime, Int32)

Rounds the milliseconds of a DateTime instance.

Declaration
public static DateTime RoundMilliseconds(this DateTime dateTimeValue, int precision)
Parameters
System.DateTime dateTimeValue

The DateTime value.
System.Int32 precision

The precision.
Returns
System.DateTime

The DateTime instance with rounded milliseconds.

RoundMinutes(DateTime)

Rounds the minutes of a DateTime instance.

Declaration
public static DateTime RoundMinutes(this DateTime dateTimeValue)
Parameters
System.DateTime dateTimeValue

The DateTime value.
Returns
System.DateTime

The DateTime instance with rounded minutes.

ToDateTime(NumberCellValue)

Converts a NumberCellValue instance to DateTime.

Declaration
public static DateTime? ToDateTime(this NumberCellValue numberCellValue)
Parameters
NumberCellValue numberCellValue

The number cell value.
Returns
System.Nullable<System.DateTime>

The DateTime instance.