Hi,
When replacing merged fields in an Excel templates, rows are inserted. When using dropdownlists in Excel (Data Validation) in order to specify the possible values of a cell, even if the validation is defined for the entire column, when inserting a row, the validation is not extended for this row. As a result, the dropdownlist is available for the first record and for all the cells under the last inserted row but not for all the other rows.
A work around is to extend the validation in the code after the report generation but could you take this functionnality into account in your next version?
Thank you.