Bug 48213 - Support for Shared Workbooks
Summary: Support for Shared Workbooks
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: unspecified
Hardware: PC Windows XP
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2009-11-17 06:39 UTC by Vladimir Savchenko
Modified: 2015-03-18 20:41 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Vladimir Savchenko 2009-11-17 06:39:45 UTC
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
Comment 1 Yegor Kozlov 2009-11-28 07:23:08 UTC
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. 

Comment 2 Dominik Stadler 2015-03-18 20:41:32 UTC
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.