Class FormatHelper

Provides utility methods for cell value formatting, date-time conversion, culture handling, and number format string parsing.

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 culture helper used for resolving locale-specific formatting settings such as decimal separators, currency symbols, and list separators.

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

Methods

ConvertDateTimeToDouble(DateTime)

Converts a DateTime instance to a numeric value representing days since 1900-01-01, accounting for Excel's leap year bug.

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

The DateTime instance.
Returns
System.Double

The double number.

ConvertDoubleToDateTime(Double)

Converts a numeric value representing days since 1900-01-01 to a DateTime instance, accounting for Excel's leap year bug, or returns null if the value is invalid.

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 to the specified precision by truncating or rounding based on the digit count.

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 a DateTime to the nearest second by rounding up if milliseconds are 500 or greater.

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 to a DateTime by interpreting the numeric value as days since 1900-01-01, or returns null if the value is invalid.

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

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

The DateTime instance.