Hi,
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!
MS
Mischa Spelt
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.
SR
Sridhar
Syncfusion Team
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.
Regards,
Sridhar.S
