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

Excel Fill Effect

Thread ID:





101208 Oct 6,2011 10:03 PM UTC Oct 12,2011 02:07 PM UTC General Discussion 3
Tags: General Discussion
Mike Conway
Asked On October 6, 2011 10:03 PM UTC

Hi there,

I am using version of essential studio.

I need to apply a 2 colour vertical gradient fill effect to a cell in Excel.

Currently, the properties of CellStyle that seem available to me are:
FillBackground (deprecated)
FillForeground (deprecated)

(There are the RGB versions of some of those too)

Of those, the Color one seems to effectively set the cell colour (Captain Obvious strikes again). Then the only option that makes any sense for the FillPattern one is Gradient, which does nothing.

I assumed that it would be in tandem with another property, perhaps PatternColor. But that did nothing as well.

Can someone tell me what to do including code samples please?

Ideally it would be from a dark grey to a lighter one. RGB 128,128,128 to 216,216,216. But that I can do later with a good example.



Sridhar [Syncfusion]
Replied On October 10, 2011 10:52 AM UTC

Hi Mike,

Thank you for using Sycnfusion products.

Currently, in xlsio we do not have support to set the two color gradient style for an cell. The MS Excel 2003 does not support with this fill style and Excel 2007 & Excel 2010 are supported.We have logged an feature request for this and forwarded to the development team for further analysis.

We are able to set the two color gradient using IFill interface for the shapes in XlsIO. We have created the sample for the same at our side and placed in the below link for your reference.

Sample Link:


And so we request you to open a new direct-trac incident with a simple issue reproducing sample for further follow up on this feature.

Direct-Trac Link:

Please let us know if you require any further clarifications.


Mike Conway
Replied On October 11, 2011 03:50 PM UTC

Thanks for the update. I will have a look.


Manikandan M [Syncfusion]
Replied On October 12, 2011 02:07 PM UTC

Hi Mike,

Thanks for your update.

Please let us know if you need any clarifications.



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