I am happy to report that this idea was reviewed and accepted for development. I will update this ticket again when this functionality has development started and a release date is clear.
Thank you for your idea.
I apologize for late reply to your question. I didn't notice it earlier unfortunately. Thanks for asking.
Actually, I would not like to terminate a report generation if a value is outside the range. Excel allows to keep a value out of range in case the validation is set later. Only when a user updates the value of the cell it enforces to choose from the list.
Maybe this could be an option in tag settings - terminate or not - to offer a flexible solution.
I refer here to Data Validation feature of Excel available under Data ribbon tab.
Particularly I'd like to set up validation criteria using a List. Meaning, in a cell where the validation is applied I can enter only values from within a list. The list of allowed values comes from a specified cell range.
Unfortunately this settings done in a template Excel spreadsheet are lost during a document generation with AutoTag.
Yes, I'd like to see Data Validation propagated from a template to a generated document. We often use validation based on Lists. In my case it could just be a fixed cells range, nothing related to tags. Data Validation settings somehow get lost while a document is generated.
I am happy to update the status of this idea to planned! I have been collecting similar ideas and have determined that their is sufficient demand for us to accept this suggestion. I will update this ticket again when development has started on this functionality. Thank you for your idea, and please submit any other suggestions you have to improve our product.