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.

Excel Fill Effect

Thread ID:

Created:

Updated:

Platform:

Replies:

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

Hi there,

I am using version 9.204.0.137 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:
FillPattern
FillBackground (deprecated)
FillForeground (deprecated)
Color
PatternColor

(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.

Cheers,

Mike



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

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:

Xlsiosample1826495382.zip

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:
https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents

Please let us know if you require any further clarifications.

Thanks,
Sridhar.S


Mike Conway
Replied On October 11, 2011 11:50 AM

Thanks for the update. I will have a look.

Mike


Manikandan M [Syncfusion]
Replied On October 12, 2011 10:07 AM

Hi Mike,

Thanks for your update.

Please let us know if you need any clarifications.

Thanks,
Manikandan.M


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.

;