Hi, I am new POI, I have created an excel template and I am writing data in that tempate dyanamically from the server and it is getting downloaded properly. Also I am creating drop down values using HSSFDataValidation, I am putting formula in that so that I can have maximum data in that dropdown as POI has limitaion for 255 string literals.
I am facing issue when I re-downloads file......suppose I have downloaded a template and after some time template formula changes (changed in web site by user as it is dynamic file) so it is not overriting that formula. (It is kind of caching done by excel)..instead I need to remove that formula manuallly (Data Validation>Seeting>List>Source>Clear All). Can you please help me out from this. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Are-data-validations-applicable-on-copying-data-tp3377250p3397180.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]
