Issue 95405

Summary: [Collaboration] Spreadsheet Collaboration Through Workbook Sharing seems not to work on UNIX
Product: Calc Reporter: tora3
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: dtardon, issues, kyoshida, thomas.benisch
Version: OOo 3.0   
Target Milestone: ---   
Hardware: All   
OS: Unix, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description tora3 2008-10-24 11:18:52 UTC
Reproduction:

Please use one of the UNIX variants such as Linux or Solaris. 

(User A)
 1. File / New / Spraedsheet
 2. Tools / Share Document...
 3. Mark a check box "Share this spreadsheet with other users."
 4. Leave the Dialog by using ok
 5. File / Save to save it in a world-writable directory: /tmp/test.ods
 6. File / Close

    Expectation: File permission is appropriately set so that the file 
                 can be shared.

    Fact: File permission is set to such as rw-r--r--, rw-r-----, rw-------, 
          depending on the value of 'umask'

 7. Change its permission to rw-rw-rw by such as chmod a+w /tmp/test.ods 
    so that other users can overwrite it. 
 8. File / Open to load the file.

(User B)
 9. File / Open to load the same file.
10. Tools / Share Document...

    Expectation: User A and B are listed in the dialog.
    Fact: "No user data available."

10. Make modifications.
11. File / Save.

    Expectation: The document is successfully saved.
    Fact: "This spreadsheet is no longer in shared mode."

Workaround:
(User B)
12. File / Close.

(User A)
13. chmod a+w /tmp/.~sharing.test.ods#

(User B)
14. File / Open to load the document file.
15. Tools / Share Document...

    Fact: Now that both user A and B are listed in the dialog.

16. Make modifications.
17. File / Save. 

    Fact: The document is successfully saved. 

(User A)
18. Make modifications.
19. File / Save.

    Fact: The function works well as expected. 

References:
 Issue 8811
Comment 1 tora3 2008-10-24 17:32:45 UTC
Revised the Summary to imply this issue could be a bug and include full name of 
the feature.
Changed the issue type from Enhancement to Defect.
Comment 2 thomas.benisch 2008-10-27 11:31:21 UTC
TBE->MAV: Please have a look.
Comment 3 tora3 2008-10-27 17:41:11 UTC
For this issue, one of the ideas: 

 Step 6) File / Close
  Expectation: File permission is appropriately set so that the file 
               can be shared.

   This could be done by a user, not by OpenOffice.org.

   It could be better that OpenOffice.org shows a dialog window 
   notifying that granting a write permission properly by hand 
   will be needed to share the document file among other users.
   It, however, might not be mandatory for right upcoming release. 


 Step 13) chmod a+w /tmp/.~sharing.test.ods#

   This could be implemented by the following instructions:

    - Obtain a set of permission bits of the base document file.
    - Open a file named ".~sharing." + file name + "#" in write mode.
    - Write something to the file.
    - Close it.
    - Apply the set of permission bits same as its base document file 
      to the hidden file.
Comment 4 mikhail.voytenko 2008-12-03 12:12:32 UTC
I agree, that an ideal solution would be that the sharing control file has just
the same permissions as the shared document.
Comment 5 Marcus 2017-05-20 11:11:40 UTC
Reset assigne to the default "issues@openoffice.apache.org".