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

Apply data validation to column

Thread ID:





100677 Aug 24,2011 11:56 AM UTC Aug 25,2011 07:31 AM UTC ASP.NET Web Forms (Classic) 2
Tags: XlsIO
Mischa Spelt
Asked On August 24, 2011 11:56 AM UTC


Is it possible to apply data validation to an entire column at once, using relative references?
E.g. I have a set of values in column B, and I would like to apply the condition "=B1 > 2.5" to B1, "=B2 > 2.5" to B2, etc.

When I add a new value somewhere in the column the formatting should also apply, so applying it cell-by-cell is not sufficient as the Rows property in XlsIO only loops through existing rows - it must be applied to the whole column.

Ideally, I would like to set
conditionalFormatting.FormulaR1C1 = "=RC > 2.5"
but unfortunately that property is read-only.

Thanks for your quick response!

Mischa Spelt
Replied On August 25, 2011 07:29 AM UTC

FYI, found some more evidence that this is a bug, so I created an issue in Direct-Trac.

Sridhar [Syncfusion]
Replied On August 25, 2011 07:31 AM UTC

Hi Mischa,

Thank you very much for the udpate.

Please follow up on the incident 84057 for further updates on this forum.

Please let us know if you require a ny further assitance on this.



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