Validation data with formula to produce a list #453
Comments
civgio
pushed a commit
to civgio/fastexcel
that referenced
this issue
Aug 5, 2024
Add the possibility to set global visibility to range when a named range is added.
civgio
pushed a commit
to civgio/fastexcel
that referenced
this issue
Aug 16, 2024
rzymek
added a commit
that referenced
this issue
Sep 6, 2024
#453: Add new data validation: ListFormulaDataValidation.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Excel allows the creation of a data validation of "List" type that accepts a formula as value instead of a range. An example is creating a dependency validation list in a multi-column setup using the "INDIRECT" formula.
Fastexcel (writer) accepts only two types of DataValidation:
DataListValidationwhich is a "list" validation type but accepts only aRange.DataCustomValidationwhich accepts a formula as value, but it is a "custom" validation type and does not produce a list.Is there a current mode to produce a "list" validation type that accepts a formula as value? Otherwise, is it possible to introduce a new
DataValidationsuch asDataListFormulaValidation?The text was updated successfully, but these errors were encountered: