Thanks Dave, Yes, I understand that the Microsoft Sharing thing is beyond the scope of POI. I will get the users to close their copy which will be far easier than doing all those changes manually like before anyway.
Thanks! Alexandre -----Original Message----- From: Dave Fisher [mailto:[email protected]] Sent: July 7, 2011 3:08 PM To: POI Users List Subject: Re: Shared workbook support for XLS documents POI works with the file in Java without any concern for issues like Microsoft Sharing which is really beyond the scope of the project. Here are a couple of ideas: If you can segregate the part you want POI to update as another workbook and have the shared user maintained part separate. Try having that use a formula to pull from the POI maintained workbook. That way refresh calculations in the Shared book will pull your changes. If your POI application is cleaning the workbook, then you'll need to get the users to close their copy before you update. Regards, Dave On Jul 7, 2011, at 11:54 AM, Thouin, Alexandre wrote: > Hi again, > > > > I realized that my first message might not be very well detailed and I > just found an old thread about the same problem with no solution: > > > > http://mail-archives.apache.org/mod_mbox/poi-user/200405.mbox/%3C02F8EC1 > [email protected]%3E > > > > To the question asked in the old thread: if the person in the excel > client closes/reopens the spreadsheet, do they see the reflected > automatic changes? > > The answer is: yes, it will see the reflected changes if he does NOT > save the document before exiting. > > > > Thanks again, > > Alexandre > > > > ________________________________ > > From: Thouin, Alexandre > Sent: July 7, 2011 11:09 AM > To: '[email protected]' > Subject: Shared workbook support for XLS documents > > > > Hi all, > > > > First, I just want to thank you for giving us the opportunity to work > with XLS files from Java. This is great! > > > > So the question, I'm trying to modify a shared XLS file with POI but it > does not work as expected. Instead of "participating" to the shared > workbook, it overwrites the file (overwriting changes from other people) > when I'm saving the XLS file from Java. Is there a way to "push" the > modified data and then participate to the shared workbook? > > > > Thanks! > > Alexandre > --------------------------------------------------------------------- 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]
