Hi, I don't think there is a way that would allow to control this from POI, it actually would render the whole "enable editing" feature of Excel useless if you could build the document in a way to prevent it.
Also doing another request upon "enable editing" is likely built into Excel as part of mandatary locking in Windows as it will only open the file read-only and thus theoretically some other user might have changed it in the meantime. The only thing I can imagine would be to force the user to first save the file locally when it is fetched from your application, then the open/re-open of the local file will not trigger a re-download. Dominik. On Mon, Jan 19, 2015 at 4:28 PM, bhames50 <[email protected]> wrote: > I have written code using Apache POI to create an Excel spreadsheet, and it > appears to create the spreadsheet fine. But, when the user clicks on "Enable > Editing", the spreadsheet does another submit to my application, and since > it is in another session, my application rejects the request, and I end up > with a blank spreadsheet. > > It only happens when the user "opens" the spreadsheet, and then clicks on > "Enable Editing". I realize why it is coming up in protected mode as the > spreadsheet was built in a temporary internet file, and that is regarded as > an "unsafe" place. What I don't understand is why the submit happens when > the user clicks on "Enable Editing". > > Is there a way in POI to handle this, or if not, to turn off the "Open" > button making the user save the spreadsheet before viewing it? > > I know that the protected mode can be turned off in Excel, but my users are > using computers with VERY restricted policies, and this is not an option for > them. I'm using Spring MVC by the way, and the Excel spreadsheet is > submitting back to my controller. > > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/Resubmit-to-application-when-user-clicks-on-Enable-Editing-tp5717689.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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
