Spreadsheet List of format specifiers

[iFACTS Admin]

Hi!

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?

Thanks!

[Dimitar]

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.

Regards,
Dimitar
Progress Telerik

[iFACTS Admin]

Thanks, your solution works great!