• office
• outlook
  • profiles
• word
  • logs
  • disable animations
• powerpoint
  • create and add new template
  • import new template
• excel
  • shortcuts
• sharepoint
  • download from sharepoint
• microsoft cli
  • install
  • setup in entra
  • login with m365

office

uninstall completely

If you still meet the issue, I suggest you try the following steps and resign into Office to check the result: Navigated to Library folder and open Group Containers. Ctrl+click each of these folders if present, and Move to Trash.

UBF8T346G9.ms
UBF8T346G9.Office
UBF8T346G9.OfficeOsfWebHost

Warning: Outlook data will be removed when you move the three folders listed in this step to Trash. You should back up these folders before you delete them.

$ ls -1d ~/Library/Group\ Containers/UBF8T346G9.*/
/Users/marslo/Library/Group Containers/UBF8T346G9.Office/
/Users/marslo/Library/Group Containers/UBF8T346G9.OfficeOneDriveSyncIntegration/
/Users/marslo/Library/Group Containers/UBF8T346G9.OfficeOsfWebHost/
/Users/marslo/Library/Group Containers/UBF8T346G9.OneDriveStandaloneSuite/
/Users/marslo/Library/Group Containers/UBF8T346G9.com.microsoft.rdc/
/Users/marslo/Library/Group Containers/UBF8T346G9.ms/

outlook

profiles

• profile

  $ ls ~/Library/Group Containers/UBF8T346G9.Office/Outlook/Outlook 15 Profiles/
  

• reset outlook profile

  $ open "/Applications/Microsoft Outlook.app/Contents/SharedSupport/Outlook Profile Manager.app"
  

word

[!TIP|label:references]

• office软件出现输入字延迟，点击延迟的现象
• * Show document content (text animation, drawings and text boxes) in Word
• How to disable the smooth moving cursor in Office 2016
• Typing Animation - Unbelievably annoying and can't turn off
• How to Disable the Typing Animation Feature in Office 2013
• How to Disable the Typing Animation in Office 2016 or Office 2013

logs

• word: ~/Library/Containers/com.microsoft.Word /Data/Library/Caches/Microsoft/uls/ Com.microsoft.Word /logs

  $ tail -f ~/Library/Containers/com.microsoft.Word/Data/Library/Caches/Microsoft/uls/com.microsoft.Word/logs/apple-device-log-20210114-2301.log
  

disable animations

> cat DisableAnimations.reg
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Common\Graphics]
"DisableAnimations"=dword:00000001

powerpoint

[!TIP|label:references]

• template location in mac (Version 16.94 (25020927)): "$HOME/Library/Group Containers/UBF8T346G9.Office/User Content.localized/Templates.localized"

create and add new template

• open pptx file with PowerPoint
• File -> Save As -> PowerPoint Template (*.potx)
• restart the PowerPoint

import new template

• copy the template file ( .potx ) to "$HOME/Library/Group Containers/UBF8T346G9.Office/User Content.localized/Templates.localized"
• open PowerPoint -> File -> New from Template -> Personal -> choose the template

excel

shortcuts

[!NOTE|label:references:]

• Excel Shortcuts “Cheat Sheet”
• Excel Shortcuts PC Mac
• 三种方法，教你在Excel里面给字体添加删除线

sharepoint

download from sharepoint

URL

• visit in web: https://domain.sharepoint.com/sites/<site>/<library>/<folder>/<file>?web=1
• download link: https://domain.sharepoint.com/sites/<site>/<library>/<folder>/<file>?download=1

if the file in Shared Documents library, the URL will be like:

• visit in web: https://domain.sharepoint.com/sites/<site>/Shared%20Documents/<folder>/<file>?web=1
• download link: https://domain.sharepoint.com/sites/<site>/Shared%20Documents/<folder>/<file>?download=1

get cookie

[!TIP|label:references] chrome extension

• Get cookies.txt Clean
• Get cookies.txt LOCALLY
• EditThisCookie (fork)

1. open the the file link in Chrome
2. F12 to open Developer Tools -> Network tab
3. refresh the page, and filter the filename
4. select the request, and copy the Request Headers -> Cookie

download

1. copy the rtFa=...; and FedAuth=...;

   $ curl -L -OJ --cookie "rtFa=...; FedAuth=..." "https://domain.sharepoint.com/sites/<site>/Shared%20Documents/<folder>/<file>?download=1"
   

2. create cookie.txt with whole cookie string

   $ curl -L -OJ -H "Cookie: $(cat cookie.txt)" "https://domain.sharepoint.com/sites/<site>/Shared%20Documents/<folder>/<file>?download=1"
   

3. create cookie.txt with rtFa and FedAuth only

   [!TIP|label:references] cookie.txt format ( using tab to separate fields ), using Netscape HTTP Cookie File

   <DOMAMIN>.sharepoint.com  TRUE  /sites/<site>  TRUE  0 rtFa  <value>
   <DOMAMIN>.sharepoint.com  TRUE  /sites/<site>  TRUE  0 FedAuth <value>
   

   $ cat coookie.txt
   domain.sharepoint.com TRUE  / TRUE  0 rtFa  <value>
   domain.sharepoint.com TRUE  / TRUE  0 FedAuth <value>
   
   $ curl -L -OJ -b cookie.txt "https://domain.sharepoint.com/sites/<site>/Shared%20Documents/<folder>/<file>?download=1"
   

microsoft cli

install

[!TIP|label:references]

• pnp/cli-microsoft365
• CLI for Microsoft 365

$ npm i -g @pnp/cli-microsoft365

# verify
$ m365 version
"v11.3.1"

setup in entra

create new app

1. login to https://entra.microsoft.com/#home

2. go to App registrations -> + New registration

   

3. Add information as below:

   • Name: CLI for M365
   • Supported account types: Accounts in this organizational directory only
   • Redirect URI:
     • Public client/native (mobile & desktop)
     • https://login.microsoftonline.com/common/oauth2/nativeclient

   

4. click Register and final result as below

   

configure API permissions

1. go to application page -> API permissions -> + Add a permission

   

2. select SharePoint -> Delegated permissions -> ALLSites -> check AllSites.Read

   • other options:
     • EnterpriseResource.Read
     • MyFile.Read
     • Project.Read
     • Sites.Selected

   

login with m365

$ export CLIMICROSOFT365_ENTRAAPPID="<CLIENT-ID>/<APPLICATION-ID>"
$ export CLIMICROSOFT365_TENANT="<TENANT-ID>"

$ m365 logout 2>/dev/null || true
$ m365 login --authType browser
$ m365 status

$ m365 spo set --url "https://domain.sharepoint.com"

# try list files
$ m365 spo list list \
       --webUrl "https://domain.sharepoint.com" \
       --properties "Title,RootFolder/ServerRelativeUrl"

# download file
$ m365 spo file get \
       --webUrl "https://domain.sharepoint.com" \
       --url "/Shared Documents/path/to/file.zip" \
       --asFile \
       --path "./file.zip"