We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Format Cells Like Excel "#,##0_);(#,##0)"

Thread ID:





118357 Mar 2,2015 11:06 AM UTC Apr 24,2015 01:19 PM UTC WPF 3
Tags: GridControl
Mark Li
Asked On March 2, 2015 11:06 AM UTC

Hi ,
   Just like Excel, If I use the format "#,##0_);(#,##0)" in a cell, negative numbers should be displayed in parenthesis without the negative sign.positive numbers should be displayed with a blank on the right side of the number in the cell. But now negative numbers displayed correctly,positive numbers displayed wrong. Like "-23" displayed"(23)", "23" should displayed "23 " not "23_)". If anyone can help me?

Mark Li

Deepak Kumar Nandagopal [Syncfusion]
Replied On March 5, 2015 04:57 AM UTC


Hi Mark,

We were able to reproduce the issue and have logged a defect report regarding this. The fix will be included in our upcoming Volume 1, 2015 release which will be available by the end of March 2015.


Deepak Kumar N

Mark Li
Replied On April 23, 2015 09:15 AM UTC

Hi Deepak,
     I downloaded the latest version of syncfusion(version:, but the problem still exists.
     If have already resolved, could you send me an example?

Kanimozhi Bharathi [Syncfusion]
Replied On April 24, 2015 01:19 PM UTC

Hi Mark,

Sorry about the inconvenience caused.

When our development team moves towards fixing this issue, they found that this is not an issue in our source, becausewe use System.IFormattable Interface to format the values and some of the custom excel formats are not supported in the predefined IFormatable interface . However we have prepared a sample to achieve your requirement. Please find the sample from below location.

Sample: http://www.syncfusion.com/downloads/support/forum/118357/FormatCheckGridControl-718273904.zip

Please let us know if you have any queries.


Kanimozhi B


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon