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.
Unfortunately, activation email could not send to your email. Please try again.

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

Thread ID:

Created:

Updated:

Platform:

Replies:

118357 Mar 2,2015 06:06 AM Apr 24,2015 09:19 AM WPF 3
loading
Tags: GridControl
Mark Li
Asked On March 2, 2015 06:06 AM

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?

thanks,
Mark Li

Deepak Kumar Nandagopal [Syncfusion]
Replied On March 4, 2015 11:57 PM

 

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.

Regards,

Deepak Kumar N



Mark Li
Replied On April 23, 2015 05:15 AM

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

Kanimozhi Bharathi [Syncfusion]
Replied On April 24, 2015 09:19 AM

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.

Thanks

Kanimozhi B


CONFIRMATION

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.

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.

;