How can I change the library default for the Mode Menu to Viewing in SPO browser views for Word and Excel docs?

Question

When a Word or Excel doc is opened in SPO, the browser view defaults to Editing in the Mode Menu. This is causing new versions when users accidently make changes. How can I make it so that the docs open in Viewing mode in my document library?

Answer 1

@Smith, Jerry

You could use following JSON codes in the "Name" column.

{  
   "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",  
   "elmType": "a",  
   "txtContent": "@currentField",  
   "attributes": {  
   "target": "_blank",  
   "href": "=if(indexOf([$ContentTypeId], '0x0120') >= 0, '?id=' + [$FileRef], @currentWeb + '/_layouts/15/Doc.aspx?sourcedoc='+ [$UniqueId] + '&action=View')"  
   }  
}  

Result:

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.