Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-20871

Edit in Microsoft has pop-up when path length is long for Excel files

    Details

    • Hot Fix Version:
      5.2.3.9
    • ACT Numbers:

      00993245

    • Sprint:
      Repo 69 - Product changes, Repo 70, Repo 71, Repo 72 - MNT sprint
    • Story Points:
      13
    • Epic Link:
    • Delivery Team:
      Feature Teams

      Description

      Problem Description:
       
      When opening an MS Excel document using 'Edit in Microsoft Office' from SHARE, the user is prompted with the message:
       
      "There's a newer version of this document on the server.  Would you rather work with that one?"
       
      This pop-up occurs even though the document has not been updated within Alfresco.  The problem is specific to Excel documents that have a long 'path'.  Further, the issue seems to be related to when Alfresco uses a shortened path to accommodate Microsoft Office issues with handling long paths.  For example, using a Fiddler trace, we can see the URL that is provided to Excel in each case:
       
      LOCK /alfresco/aos/_aos_nodeid/1ca058be-0787-420c-8632-c2925bf3cf64/20characters123.xlsx HTTP/1.1
       
      LOCK /alfresco/aos/Sites/josie-site/documentLibrary/50characters12345678123456789012345678901234567890/50characters12345678123456789012345678901234567890/50characters12345678123456789012345678901234567890/10characte/19characters12.xlsx HTTP/1.1
       
      Reproduction Steps:
       
      1/. Install OOTB ACS v5.2.5
       - add a user 'josie'
       - login to SHARE as 'josie'
       - create a site 'josie-site'.
      2/. Create a nested folder structure
       - 50characters12345678123456789012345678901234567890
       - 50characters12345678123456789012345678901234567890
        - 50characters12345678123456789012345678901234567890
         - 10characte
      3/. Upload 2 excel documents to folder '10characte'
       - 19characters12.xlsx
       - 20characters123.xlsx
      4/. Open file '19characters12.xlsx' using 'Edit in Microsoft Office'.
       - document opens in READ-ONLY mode.
       - select 'Edit Workbook'.
       - file can be edited and saved.
      5/. Open file '20characters123.xlsx' using 'Edit in Microsoft Office'.
       - document opens in READ-ONLY mode.
       - select 'Edit Workbook'.
       - pop-up appears "There's a newer version of this document on the server.  Would you rather work with that one?" (see attached screenshot)
       - select 'yes' and file can be edited and saved back to ALfresco.

      Observed Behaviour:
       
      When opening an MS Excel file that has a long path, a pop-up is presented which tells the user that the document has been changed on the server.
       
      Expected Behaviour:
       
      When opening an MS Excel file that has a long path, no po-up should be presented UNLESS the document has actually changed on the server.

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedbugs Closed Bugs
                  Reporter:
                  pbateman Paul Bateman
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  10 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Structure Helper Panel