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.