Remaining SharePoint/OneDrive issue

[fzumstein]

There are still some issues with SharePoint:

• capitalized dummies are "folders" though AAA is probably a "site-collection" ? see https://sharepointmaven.com/the-anatomy-of-a-sharepoint-url/). Also note the German variant to /Documents, see also: https://stackoverflow.com/a/65967886/918626

  This is SharePoint

  ActiveWorkbook.FullName:
  https://mycompany.sharepoint.com/sites/AAA/Freigegebene Dokumente/BBB/CCC/DDD/myfile.xlsm
  
  Local Path:
  C:\Users\myuser\my company\AAA - BBB\CCC\DDD\myfile.xlsm
  
  OneDrive Env var:
  C:\Users\myuser\my company
  

  The issue here is that AAA/Freigegebene Dokumente/BBB becomes AAA - BBB locally. This seems to be a Office 365 Groups Site Collections, see: https://sharepointmaven.com/site-collections-sharepoint/

  Note: if the code is embedded via xlwings PRO, it fails (but shouldn't), but can be worked around for the time being by providing a dummy value in the settings for ONEDRIVE_WIN, e.g. %ONEDRIVE%.

• mybook.fullname in the Python package hasn't been handled so far which can trip you off if you use it to find files that are next to the workbook

[fzumstein]

More samples:

This is a OneDrive URL according to https://sharepointmaven.com/the-anatomy-of-a-sharepoint-url/

https://mycompany.sharepoint.com/personal/user_company_com/Documents/Documents/BBB/CCC/DDD/myfile.xlsm
C:\Users\myuser\my company\Documents\BBB\CCC\DDD\myfile.xlsm