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.
Syncfusion Feedback

Cell format problem

Thread ID:

Created:

Updated:

Platform:

Replies:

99960 Jun 23,2011 12:01 AM UTC Jun 29,2011 06:35 AM UTC ASP.NET Web Forms (Classic) 3
loading
Tags: XlsIO
shrimpy
Asked On June 23, 2011 12:01 AM UTC

Hi All,

In excel, i can apply formula [Red] #,##0 for number,
then the number will have format and color.

can we apply this format onto text and data value as well?

Thanks


John Bowlin Bosco K [Syncfusion]
Replied On June 23, 2011 07:17 AM UTC

Hi Shrimpy,

Thank you very much for your interest in Syncfusion Products.

To format the cell value, conditional formatting can be used by which the contents of a cell are dynamically formatted, based on a value. To illustrate this, we have created a sample in which the cell value containing "0" is formatted with font color as red and the sample has been attached below. Could you please try the sample and let us know if this helps you.

Sample Link:
http://www.syncfusion.com/uploads/redirect.aspx?&team=support&file=ConditionalFormatSample1013321074.zip

Also, please navigate to the attached documentation link to know more about the conditional formatting.

http://help.syncfusion.com/ug_91/Reporting/XlsIO/Windows%20Forms/default.htm?turl=Documents%2Fconditionalformatting.htm

Please let us know if you need any further assistance.

Regards,
Pauline Bosco


shrimpy
Replied On June 28, 2011 08:12 AM UTC

Hi John ,

Great thanks for you reply.

It is not what i want. but still help.
but basicly the numberformat can apply to any type of values
this is what i tried it out.


still thank you for your help.




Sridhar [Syncfusion]
Replied On June 29, 2011 06:35 AM UTC

Hi Shrimpy,

Thank you very much for the update.

In Essential XlsIO we are supporting all the numberformats to the spcified type values as same as in MSExcel.

Please go through the following online documentation link for more deatails on Number Formatting.

http://help.syncfusion.com/ug_92/Reporting/XlsIO/Windows%20Forms/default.htm?turl=Documents%2Fnumberformatting.htm

Could you please let us know your actual requirement in applying the number formats so that we can able to sory out easily. Please update the sample for the same if you have any concerns.

Please let us know if you have any futher clarifications.

Thanks,
Sridhar.S




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.

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

;