{"id":3641,"date":"2011-01-11T11:20:50","date_gmt":"2011-01-11T10:20:50","guid":{"rendered":"http:\/\/www.itwriting.com\/blog\/3641-how-microsoft-sharepoint-makes-simple-things-hard.html"},"modified":"2011-01-11T11:20:50","modified_gmt":"2011-01-11T10:20:50","slug":"how-microsoft-sharepoint-makes-simple-things-hard","status":"publish","type":"post","link":"https:\/\/www.itwriting.com\/blog\/3641-how-microsoft-sharepoint-makes-simple-things-hard.html","title":{"rendered":"How Microsoft SharePoint makes simple things hard"},"content":{"rendered":"

When I was asked how to show file extensions in lists of documents on SharePoint sites I thought it would be a simple change to make. I did a quick Google and found several answers; but some of them involved editing core files that instinctively I thought should be left alone. I took a closer look and worked out the steps<\/a>.<\/p>\n

It turns out that you need SharePoint designer, plus you have to convert a web part to XSLT, and then figure out what to change in the rather complex page that is then generated.<\/p>\n

A few observations. <\/p>\n

First, I am surprised that Microsoft did not build in some easy way of showing the file extensions in a document library, which seems an obvious thing to want to do. There are hundreds of much more obscure things you can easily show, but not this one.<\/p>\n

Second, it is nice that Microsoft has made its SharePoint Designer tool free, but I am not sure that the way it is presented is quite right. It is a techie product but I did not find Help particularly helpful. You know the kind of thing; you are in the Formula Editor, you hit F1, and you get a description of the dialog, when what you want of course is a reference to the formulae.<\/p>\n

Third, when I did find the documentation I found it obscure. Here\u2019s the reference for the @LinkFileName formula:<\/p>\n

\n

Returns a GUID that represents the icon that is used to create a link to a file in a document library, where the file can be edited by using a menu. <\/p>\n<\/blockquote>\n

Hmm. I am not sure how many fat SharePoint books you need to read to understand why this particular formula is used as it is in SharePoint, or why String(@LinkFileName) returns the file name with its extension.<\/p>\n

Fourth, I discovered that SharePoint deliberately hides the file extension. You can show the extension by removing the function that strips it off, in the formula that determines the contents of that cell.<\/p>\n

Now I know why SharePoint is such good business for specialists.<\/p>\n","protected":false},"excerpt":{"rendered":"

When I was asked how to show file extensions in lists of documents on SharePoint sites I thought it would be a simple change to make. I did a quick Google and found several answers; but some of them involved editing core files that instinctively I thought should be left alone. I took a closer … Continue reading How Microsoft SharePoint makes simple things hard<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55,67,76],"tags":[586,821],"class_list":["post-3641","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-professional","category-sharepoint","tag-microsoft","tag-sharepoint"],"_links":{"self":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/3641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/comments?post=3641"}],"version-history":[{"count":0,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/3641\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/media?parent=3641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/categories?post=3641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/tags?post=3641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}