{"id":6589,"date":"2014-02-26T10:27:13","date_gmt":"2014-02-26T02:27:13","guid":{"rendered":"http:\/\/www.boostsolutions.com\/blog\/?p=6589"},"modified":"2023-07-31T11:38:18","modified_gmt":"2023-07-31T03:38:18","slug":"things-know-sharepoint-2013-quick-edit-part-2","status":"publish","type":"post","link":"https:\/\/www.boostsolutions.com\/blog\/things-know-sharepoint-2013-quick-edit-part-2\/","title":{"rendered":"Things to Know about SharePoint 2013 Quick Edit – Part 2"},"content":{"rendered":"

In my last post, I mentioned several enhancements and features of Datasheet view in SharePoint 2013 Quick Edit. In this post, I will outline some major issues and complaints about Quick Edit and list some bulk editing tools that could be helpful.<\/p>\n

No Support for Mass Change of Content Types <\/b><\/p>\n

In SharePoint 2013 Quick Edit view, when you click on the content type field, it is greyed out. This means the content type is not editable in Quick Edit mode.<\/p>\n

\"content<\/p>\n

In SharePoint 2010, you can find a way to bulk edit content types in Datasheet view, but it is not so ideal (see: Datasheet view and edit content type<\/a>).<\/p>\n

It is possible to make mass changes in content types with SharePoint 2007 Datasheet view, where you can select content type from a drop-down list.<\/p>\n

\"content<\/p>\n

No Support for Custom Column Types<\/b><\/p>\n

Custom field types are read-only in both SharePoint 2010 and 2013 Datasheet view.<\/p>\n

If you do need to bulk change content types and custom field types in SharePoint 2013, you can turn to some third party tools.<\/p>\n

Inability to Edit Rich Text Column <\/b><\/p>\n

In SharePoint 2007 and 2010, when you create a “Multiple lines of text” column in a list, you have a choice of three text types: Plain text, Rich text and Enhanced rich text. You can edit both Plain text and Rich text columns in datasheet mode, but not the Enhanced rich text column.<\/p>\n

In SharePoint 2013, when you create a “Multiple lines of text” column in a list, you can only select from two text types: Plain text and Enhanced rich text. When you go to the editing page of the column, you can change the Enhanced rich text type to Rich text type. You can edit Plain text and Enhanced rich text column in the Quick Edit mode. But after changing to Rich text, you cannot edit this Rich Text column in Quick Edit mode. This seems weird but Microsoft says it is by design (see: SharePoint 2013: can’t edit Rich Text column in Quick Edit mode<\/a>).<\/p>\n

Unavailable for Grouped View <\/b><\/p>\n

Quick Edit is not available for view where Group By is used. The option at the top of the list disappears and the command gets greyed out on the ribbon.<\/p>\n

\"grouped<\/p>\n

You might hate this as you have to stop, set the grouping to None, use Quick Edit and then set the grouping back again. This function works perfectly in SharePoint 2010.<\/p>\n

Unavailable for Views with Styles other than Default<\/b><\/p>\n

Another limitation is that Quick Edit only works with a view in Default style. If you change to a style (Basic Table, “Boxed, no labels”, Boxed, Newsletter, “Newsletter, no Lines” , Shaded and Preview Pane) other than Default, the Quick Edit option at the top of the list disappears and the Quick Edit command on the ribbon is disabled. If you modify the view and change the style back to Default, then the Quick Edit will once again be available.<\/p>\n

Loss of Some Excel-like Features <\/b><\/p>\n

Quick Edit mode does not support all the “Excel-like” features that SharePoint 2007 and 2010 Datasheet View provide. The following features are not supportable in Quick Edit mode:<\/p>\n