Hi, I've tried to work with a shared XSSF Workbook, and nothing happend. The api does not recognize that this is a shared WB. Is this feature missing? Can it be implemented? Or is it implemented for a diffrent version of the API? If it is missing just because it is not implemented - i would like to contribute it's implementation to the team. I just would like somebody with more experience in this API to confirm that this is technically possible? Thanks, Vladimir
Vladimir, you are very much welcome to contribute! Shared workbooks are not yet supported. XSSF treats shared workbooks just like any others - it ignores changes made by other users, does not write changes, etc. I'm pretty much sure it is technically feasible to implement. Can you post a use case? It would help us to better understand what functionality is required and design the API appropriately. What did you expect to happen 'automatically' when you were working with a shared XSSF workbook? At least three use-cases come to my mind: - turn on the "shared mode" on a .xlsx file. This will allow multiple external users to edit the workbook at the same time. By 'external' I mean Excel 2007 clients. - programmatically work with the Revision Table - read changes made by other users and update the workbook with those changes. A potentially tricky part is resolving conflicts. - track changes made by XSSF and update the Revision History part so that other users will see / merge them. The first one seems trivial, it should be a flag somewhere in workbook.xml. The other two can take efforts. Please see http://poi.apache.org/guidelines.html for initial guidelines how to contribute. Regards, Yegor
No update for a long time and obviously no plans on providing this soon, therefore I am resolving this as LATER, please reopen this if you still plan to work on this functionality.