skip navigation
  • Product Bundles

    DevCraft

    All Telerik .NET tools and Kendo UI JavaScript components in one package. Now enhanced with:

    • NEW: Design Kits for Figma
    • Online Training
    • Document Processing Library
    • Embedded Reporting for web and desktop

    Web

    Kendo UI UI for jQuery UI for Angular UI for React UI for Vue UI for Blazor UI for ASP.NET Core UI for ASP.NET MVC UI for ASP.NET AJAX

    Mobile

    UI for .NET MAUI

    Document Management

    Telerik Document Processing

    Desktop

    UI for .NET MAUI UI for WinUI UI for WinForms UI for WPF

    Reporting

    Telerik Reporting Telerik Report Server

    Testing & Mocking

    Test Studio Test Studio Dev Edition Telerik JustMock

    CMS

    Sitefinity

    UI/UX Tools

    ThemeBuilder Design System Kit Templates and Building Blocks

    Debugging

    Fiddler Fiddler Everywhere Fiddler Classic Fiddler Everywhere Reporter FiddlerCore

    Free Tools

    VB.NET to C# Converter Testing Framework
    View all products
  • Overview
  • Demos
  • Docs & Support
  • Pricing
  • Shopping cart
    • Account Overview
    • Your Licenses
    • Downloads
    • Support Center
    • Forum Profile
    • Payment Methods
    • Edit Profile
    • Log out
  • Login
  • Contact Us
  • Try now

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.

Getting Started
  • Getting Started
Support Resources
  • Documentation
Community
  • Forums
  • Blogs
  • Document Processing Feedback Portal

Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.