Spreadsheet List of format specifiers

3 posts, 1 answers
  1. iFACTS Admin
    iFACTS Admin avatar
    9 posts
    Member since:
    Feb 2017

    Posted 10 Oct 2017 Link to this post


    Please have a look at this demo: notice that rows 5 and 6 have custom format, where I want to add currencies (exotic ones). However, I discover that "S" and "H" seem to be custom format specifiers. 

    Can you provide a list of this special specifiers to know what special characters to escape?


  2. Answer
    Dimitar avatar
    815 posts

    Posted 12 Oct 2017 Link to this post

    Hello Peter,

    Formatting in the Kendo UI Spreadsheet aims to be compatible with the Excel number formats. More information regarding the compatibility and differences can be found in the following Spreadsheet Cell Formatting Article

    The guidelines for escaping characters can be found in the Excel Number Formats Document. Basically, only a certain set of characters ($, +, ^, :) should be used without quotation marks. All other text has to be enclosed by double quotation marks (" "). 

    With the above in mind, if we would like to set Swiss Franc currency format (CHF) for a cell in the Kendo Spreadsheet, we can achieve this by enclosing the the abbreviation in double quotes as follows:
    format: "\"CHF\" ###,##0.00"

    You can also refer to the following Dojo example, where the above is demonstrated.

    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  3. iFACTS Admin
    iFACTS Admin avatar
    9 posts
    Member since:
    Feb 2017

    Posted 26 Oct 2017 in reply to Dimitar Link to this post

    Thanks, your solution works great!

Back to Top