ClassFormatHelper
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 FormatHelperInheritance: objectFormatHelper
Fields
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
Methods
ConvertDateTimeToDouble(DateTime)
Converts a DateTime instance to a numeric value representing days since 1900-01-01, accounting for Excel's leap year bug.
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.
RoundMilliseconds(DateTime, int)
Rounds the milliseconds of a DateTime to the specified precision by truncating or rounding based on the digit count.
RoundMinutes(DateTime)
Rounds a DateTime to the nearest second by rounding up if milliseconds are 500 or greater.
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
The number cell value.
Returns
The DateTime instance.