Hello, I am fairly new to apache POI. I have been using it to create an excel Sheet that can be downloaded by a user and filled with data. The sheet gets generated dynamically, when the user attempts to download it, with data validations for cell ranges based on what needs to be filled in those cells.
Now, the cells that have numeric constraints. show the error message when I type in a non-numeric value and move out of the cell. However, if, instead of typing, I were to copy a text from another cell and paste it in the numeric cell, the data validation is not triggered. If a delete this copied value and type in text again, the error message is triggered again. Are data validations rendered invalid when data is pasted on to a cell? If, yes, is there any way by which I can retain the validations even after a copy-paste? Regards Swati -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Are-data-validations-applicable-on-copying-data-tp3377250p3377250.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
