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

Conditional Formats, relative references

Thread ID:





89630 Aug 31,2009 10:52 PM UTC Oct 9,2009 09:10 AM UTC ASP.NET Web Forms (Classic) 3
Tags: XlsIO
James Norman
Asked On August 31, 2009 10:52 PM UTC

I'm trying to set Conditional Formatting for an entire column except the first row ("F2:F65535") with a formula that I want to active relatively. For example if my formula is


in F2, I want it to be


in F3.

Aspose and Spreadsheet gear appear to support this functionality... for example here is the same thing in ASPOSE.Cells..it knows to adjut the formula in formula1 appropriately.

dvRange = new CellArea();
dvRange.StartRow = 1;
dvRange.EndRow = 65535;
dvRange.StartColumn = 5;
dvRange.EndColumn = 5;

dvCurrentIndex = _this.Worksheets["DataEntry"].Validations.Add();
v = _this.Worksheets["DataEntry"].Validations[dvCurrentIndex];
v.AlertStyle = ValidationAlertType.Information;
v.Type = ValidationType.List;
v.Formula1 = "=OFFSET(StateListDropdown,MATCH(SUBSTITUTE(UPPER(A2),\" \",\"\"),StateValidator,0)-1,0,COUNTIF(StateValidator, SUBSTITUTE(UPPER(A2),\" \",\"\")),1)";
v.InCellDropDown = true;
v.IgnoreBlank = false;
v.ShowInput = false;
v.InputTitle = "Mock Entry";
v.InputMessage = "Enter or choose a color";
v.ShowError = false;
v.Operator = OperatorType.None;


Geetha M [Syncfusion]
Replied On September 1, 2009 07:20 AM UTC

Hi James,

Thank you for your interest in Syncfusion products.

Currently it is not possible to add DataValidation relatively to have the formula adjusted based on the Cell value. However I have forwarded this to our development team for more analysis. Could you please create a new direct trac incident so that I could send you more details.


James Norman
Replied On September 1, 2009 05:36 PM UTC

Well I'm not an existing customer, I am evaluating the product of which this is an unfortunate showstopper for us.

Geetha M [Syncfusion]
Replied On October 9, 2009 09:10 AM UTC


The problem of DataValidation does not add formula as relative reference is fixed and it will be available in our next public release.

Please let us know if you have any further questions.



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

or the page will be automatically redirected to 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