New to Telerik Document Processing? Start a free 30-day trial

FormatHelper

Class

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

Definition

Namespace:Telerik.Windows.Documents.Spreadsheet.Formatting

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public static class FormatHelper

Inheritance: objectFormatHelper

Fields

StartDate

DateTime

Defines the earliest date the RadSpreadsheet recognizes.

public static readonly DateTime StartDate

Methods

ConvertDateTimeToDouble(DateTime)

double

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

public static double ConvertDateTimeToDouble(DateTime dateTime)

Parameters:dateTimeDateTime

The DateTime instance.

Returns:

double

The double number.

ConvertDoubleToDateTime(double)

DateTime?

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.

public static DateTime? ConvertDoubleToDateTime(double doubleValue)

Parameters:doubleValuedouble

The double value.

Returns:

DateTime?

The DateTime instance.

RoundMilliseconds(DateTime, int)

DateTime

Rounds the milliseconds of a DateTime to the specified precision by truncating or rounding based on the digit count.

public static DateTime RoundMilliseconds(this DateTime dateTimeValue, int precision)

Parameters:dateTimeValueDateTime

The DateTime value.

precisionint

The precision.

Returns:

DateTime

The DateTime instance with rounded milliseconds.

RoundMinutes(DateTime)

DateTime

Rounds a DateTime to the nearest second by rounding up if milliseconds are 500 or greater.

public static DateTime RoundMinutes(this DateTime dateTimeValue)

Parameters:dateTimeValueDateTime

The DateTime value.

Returns:

DateTime

The DateTime instance with rounded minutes.

ToDateTime(NumberCellValue)

DateTime?

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.

public static DateTime? ToDateTime(this NumberCellValue numberCellValue)

Parameters:numberCellValueNumberCellValue

The number cell value.

Returns:

DateTime?

The DateTime instance.

Properties

CultureHelper

SpreadsheetCultureHelper

Gets or sets the culture helper used for resolving locale-specific formatting settings such as decimal separators, currency symbols, and list separators.

public static SpreadsheetCultureHelper CultureHelper { get; set; }