Pending Review
Last Updated: 10 Mar 2020 12:01 by ADMIN
Created on: 09 Mar 2020 18:24
Category: Spreadsheet
Type: Feature Request
Display negative numbers by using parentheses

With Excel when you use a custom number format of #,##0.00 and you enter (10) into the cell it will be displayed as -10.  With the Spreadsheet control the same example yields (10).  How can we get the same behavior as Excel with the Spreadsheet control?


  dojo example:




1 comment
Posted on: 10 Mar 2020 12:01

Hi Ron,

Thank you for the feedback. This is currently not supported. I converted this ticket to a feature request so that we can have this in mind for possible feature improvement.  

Excel does that by using a very concrete translation that is documented here:

Currently, in Kendo Spreadsheet only a minus sign can be used.

Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.