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.

How to use "fill effects" in Xlsio

Thread ID:

Created:

Updated:

Platform:

Replies:

90788 Oct 19,2009 12:40 AM Oct 29,2009 05:53 PM ASP.NET Web Forms (Classic) 4
loading
Tags: XlsIO
Stephen Sawyer
Asked On October 19, 2009 12:40 AM

Hello

Could someone please show me how to apply a simple gradient to cell using "fill effects" ether in a quick example or point me to where it is in the documentation?

Thanks Stephen

Ashish Pillai [Syncfusion]
Replied On October 19, 2009 03:02 AM

Hi Stephen,

Thank you for your interest in Syncfusion products.

You can refer to our documentation in the below link for how to apply a simple gradient to cell using "fill effects".

http://help.syncfusion.com/ug_73/xlsio/PatternSettings.html

Please try this and let me know if you have any questions.

Regards,
Ashish Pillai

Stephen Sawyer
Replied On October 26, 2009 08:01 PM

Hello Ashish,

Sorry if I have taken my time to respond. Thank for providing the link but I don’t think this is what I want. By using the metods in the link I can achieve a gradient if I have set IRange.CellStyle.FillPattern = ExcelPattern.Gradient; and I can use the obsolete CellStyle.FillForeground and CellStyle.FillForeground but I can’t seem to control the gradient direction. It is always vertical.

The image in of the dialog in the link is from Excel2003. Excel2007 has a button ‘Fill Effect’s that brings up the dialog with the gradient effects attached that has the features I want to use with Syncfusion.

In the api there is an interface call IFill with methods like TwoColorGradient, GradientStyle which seem to access these features, but I cannot find how IFill is used.

Hope you can help

Thanks

Stephen




FillEffectsDialog_3cbdcd98.rar

Ashish Pillai [Syncfusion]
Replied On October 27, 2009 07:01 AM

Hi Stephen,

Thank you for your interest in Syncfusion products.

We have created a sample based on your requirements. Please find the sample from the below link.

http://www.syncfusion.com/uploads/redirect.aspx?file=FormatCells_2008_ea52313e.zip&team=development

Please let me know if you have any questions.

Regards,
Ashish Pillai.

Stephen Sawyer
Replied On October 29, 2009 05:53 PM

Thanks Ashish, This is great!

Stephen

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.

;