Hello
I've got the problem to get defined
NamedReferences
to apply as "validation dropdown"-lists into another worksheet.
I tried ... ".ApplyFormula("=Name_User");
But when i open the excel workbook i could only found the first entry of the NamedReference as value in the applied cell.
Can someone help me on the right way.
Greetings from germany
Dietrich
Hello Dietrich,
Did Mike's post help to resolve your issue?
Dietrich, I believe I know what you are trying to do, but correct me if I am wrong. It sounds like you have a named reference, called Name_User, which points to one or more possible values and you would like those values to appear as a drop down list on a cell. If so, WorksheetCell.ApplyFormula is not the way to go. This will set the formula of the cell directly, which only determines the cell's value. So you would be setting the cell value to the values referenced by Name_User, which probably evaluates to a #VALUE! error.
Currently, there is no way to apply a list of possible values to a cell. But this support has been added to our upcoming 11.2 release. When it becomes available, you would want to create a ListValidationRule and set it's formula to "=Name_User". Then you would set that ListValidationRule instance on the WorksheetCell.DataValidationRule property.
I'm trying to create a sample, but I need some more information about what it is you're doing and trying to do. First of all, are the NamedReferences being created in Excel or through our Excel library? Also, when you open the Excel workbook, are you opening it in Excel or are you loading it with our Excel library?
Would it be possible for you to attach a sample project which reproduces the issue? You can attach a file by selecting the Options tab when creating a post.