Free Support Forum - aspose.com

How to put dynamic validation?

Received : 2007/11/19 11:38:06
Message : validation.Formula1 = "=INDIRECT(" + namedRange + ")";

if INDIRECT applies to the value that will be selected from another combox, then I should have:

validationList.Formula1 = "=INDIRECT(B14+"List")";

In excel it looks this way:
=INDIRECT($B$14 & "Sections")

I tried this:
workSheet.Cells[1, 0].Name + "& \"Sections\""

But I receive an Invalid Formula Exception


This message was posted using Aspose.Live 2 Forum

Hi,

Well I tested Indirect formula, it works fine.

Could you tell are namedrange, list and sections .net controls and you are utilizing them as place holders?

Could you create a sample test app to show the issue.

Thank you.