We have a website built on Java and WebSphere. We offer a spread sheet download which contains macros and data retrieved from the site. I have used POI to populate the sheet with success. First I used POI 3.5 beta and now I have plugged in 3.7 instead. Up to now we have supported Excel 2000. We are moving to Office 2010 and the download no longer works as well. Now when opening the downloaded spread sheet there is a 4-step process where as before users simply clicked enable macros. In order Users get 1. Excel has detected a problem with this file. Opening may be dangerous. Click Open 2. Users see a Red Banner, Protected View - Office has detected a problem...Editing it may harm your computer. Click for more details. Click on red bar 3. Document is in protected View.. same warnings, option to Edit Anyway. Click Edit Anyway 4. Security warning - some active content has been disabled. Click for more details. Enable Content Link Click Enable Content Finally, the sheet can be opened and used. It works correctly. The tool Microsoft offers to examine VBA code found issues but they seem to be red herrings as they point to objects we don't use.
I do not want to rewrite this process if it works but I must do something to get rid of the barrage of messages. I will rewrite it if need be. AS AN ASIDE, Just downloading the file from web-content one has to only go through the Enable Content step. However we have to process the file adding data to it. It seems this processing and the downloading triggers all these messages. Any help at all on this would be appreciated. Is there anything specific I need to change or look out for? Is there a better API? -- View this message in context: http://apache-poi.1045710.n5.nabble.com/POI-from-Excel-2000-to-Excel-2010-issues-tp3365053p3365053.html Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
