Blog Archive » “or edit this list” (Quick Edit Part 1)

“or edit this list” (Quick Edit Part 1)

In SharePoint 2013 there’s a “Quick Edit” View Format.  Most people will know this from SharePoint 2010 when it was called the “Datasheet View” View Format.

“Quick Edit” in the Ribbon

There are some scenarios in SP2013 where the “Quick Edit” View Format can not function properly.  There have been a number of posts on this, and in summary they are:

  • After upgrading from SP2010, ensure
    • The view is set to the “Default” view style
    • The view section for ‘Tabular views’ is configured to ‘allow individual item checkboxes’
  • If you have created a new list/library in SP2013, then ensure
    • There is no ‘Grouping’ on the view being used with “Quick Edit”

One uncommon scenario that isn’t on the interjet is the Calculated Column.  If you create a new calculated column, and it’s displayed in the view being used with “Quick Edit”, then you will be able to click on “Quick Edit” in the Ribbon.  However the cells in the body of the page will be grey-ed out.  Simply remove the calculated column to get the “Quick Edit” functionality back.  You may be able to use workflows to get the calculated values you need.

Other than this, I have not encountered any out-of-box column data types that disable the entire “Quick Edit” View Format.  There are some system controlled data types that don’t allow business users to type in values, but these are grey-ed out on a case by case basis and don’t disrupt the overall “Quick Edit” View Format.

“+ new task or edit this list” in Web Parts

In the early days of SP2013 an issue was reported where enabling the web part “Summary View” would hide/disable the “+ new task or edit this list” control in a List web part.  This issue seems to persist even after Service Pack 1, so make a custom view and use that instead of the <Summary View>.

One important difference to note is that Lists get the “+ new task or edit this list” control, and Libraries get the “+ new document or drag files here”.  There’s no quick and easy way to put the List control on a Library.  It would probably just frustrate your business users anyways.

You could try to override this default behavior using some custom javascript, but you should really just consider making your default view a “Quick Edit” view instead.

App Development

I’m not a developer, and I didn’t spend hours tracking down the best MSDN reference ever (sorry).  But if you like peaking at code then check out these standard sharepoint/office app controls (link).  You’ll see our friends: “new item”; “new document”; “…or drag files here”; and “…or edit this list” as individual strings.  You’ll see a bunch of other standardized strings too.

ListViewDefaults.Strings.L_STSRecycleConfirm_Text="Are you sure you want to send the item(s) to the site Recycle Bin?";

ListViewDefaults.Strings.L_STSDelConfirm_Text="Are you sure you want to permanently delete the item(s)?";

ListViewDefaults.Strings.L_STSDelConfirmParentTask="Deleting a summary task will also delete its subtasks.";

ListViewDefaults.Strings.L_Notification_Delete="Deleting...";

ListViewDefaults.Strings.L_Notification_CheckOut="Checking Out...";

ListViewDefaults.Strings.L_NewDocumentCalloutSize="280";

ListViewDefaults.Strings.L_NewDocumentWordImgAlt="Create a new Word document";

ListViewDefaults.Strings.L_NewDocumentWord="Word document";

ListViewDefaults.Strings.L_NewDocumentExcelImgAlt="Create a new Excel workbook";

ListViewDefaults.Strings.L_NewDocumentExcel="Excel workbook";

ListViewDefaults.Strings.L_NewDocumentPowerPointImgAlt="Create a new PowerPoint presentation";

ListViewDefaults.Strings.L_NewDocumentPowerPoint="PowerPoint presentation";

ListViewDefaults.Strings.L_NewDocumentOneNoteImgAlt="Create a new OneNote notebook";

ListViewDefaults.Strings.L_NewDocumentOneNote="OneNote notebook";

ListViewDefaults.Strings.L_NewDocumentExcelFormImgAlt="Create a new Excel survey";

ListViewDefaults.Strings.L_NewDocumentExcelForm="Excel survey";

ListViewDefaults.Strings.L_NewDocumentFolderImgAlt="Create a new folder";

ListViewDefaults.Strings.L_NewDocumentFolder="New folder";

ListViewDefaults.Strings.L_SPStopEditingTitle="Stop editing and save changes.";

ListViewDefaults.Strings.L_SPStopEditingList="{0}Stop{1} editing this list";

ListViewDefaults.Strings.L_SPAddNewItem="new item";

ListViewDefaults.Strings.L_SPAddNewAnnouncement="new announcement";

ListViewDefaults.Strings.L_SPAddNewDocument="new document";

ListViewDefaults.Strings.L_SPAddNewLink="new link";

ListViewDefaults.Strings.L_SPAddNewEvent="new event";

ListViewDefaults.Strings.L_SPAddNewTask="new task";

ListViewDefaults.Strings.L_SPAddNewPicture="new picture";

ListViewDefaults.Strings.L_SPAddNewWiki="new Wiki page";

ListViewDefaults.Strings.L_SPAddNewDevApp="new app to deploy";

ListViewDefaults.Strings.L_SPAddNewApp="new app";

ListViewDefaults.Strings.L_SPAddNewItemTitle="Add a new item to this list or library.";

ListViewDefaults.Strings.L_SPAddNewAndDrag="{0} or drag files here";

ListViewDefaults.Strings.L_SPAddNewAndEdit="{0} or {1}edit{2} this list";

ListViewDefaults.Strings.L_SPEditListTitle="Edit this list using Quick Edit mode.";

ListViewDefaults.Strings.L_ViewSelectorCurrentView="Current View";

ListViewDefaults.Strings.L_SaveThisViewButton="Save This View";

ListViewDefaults.Strings.L_SPCount="Count";

ListViewDefaults.Strings.L_SPSum="Sum";

ListViewDefaults.Strings.L_SPAvg="Average";

ListViewDefaults.Strings.L_SPMax="Maximum";

ListViewDefaults.Strings.L_SPMin="Minimum";

ListViewDefaults.Strings.L_SPStdev="Std Deviation";

ListViewDefaults.Strings.L_SPVar="Variance";

ListViewDefaults.Strings.L_SPCollapse="collapse";

ListViewDefaults.Strings.L_SPExpand="expand";

ListViewDefaults.Strings.L_SPClientNoTitle="No Title";

ListViewDefaults.Strings.L_OpenMenu="Open Menu";

ListViewDefaults.Strings.L_select_deselect_all="Select or deselect all items";

ListViewDefaults.Strings.L_SPSelection_Checkbox="Selection Checkbox";

ListViewDefaults.Strings.L_OpenMenuKeyAccessible="Click to sort column";

ListViewDefaults.Strings.L_CSR_NoSortFilter="This column type canu0027t be sorted or filtered.";

ListViewDefaults.Strings.L_NODOCSEARCH="Your search returned no results.";

ListViewDefaults.Strings.L_NODOC="There are no files in the view "%0".";

ListViewDefaults.Strings.L_NODOCView="There are no documents in this view.";

ListViewDefaults.Strings.L_AccRqEmptyView="You are all up to date! There are no requests pending.";

ListViewDefaults.Strings.L_SPClientPrevious="Previous";

ListViewDefaults.Strings.L_SPClientNext="Next";

ListViewDefaults.Strings.L_OpenMenu_Text="Open Menu";

ListViewDefaults.Strings.L_ViewSelectorTitle="Change View";

ListViewDefaults.Strings.L_SelectBackColorKey_TEXT="W";

ListViewDefaults.Strings.L_SlideShowPrevButton_Text="Previous";

ListViewDefaults.Strings.L_SlideShowNextButton_Text="Next";

ListViewDefaults.Strings.L_SPClientNew="new";

ListViewDefaults.Strings.L_SPClientNewAK="n";

ListViewDefaults.Strings.L_SPClientNewTooltip="Create a new document in this library.";

ListViewDefaults.Strings.L_ImgAlt_Text="Picture";

ListViewDefaults.Strings.L_SPClientEdit="edit";

ListViewDefaults.Strings.L_SPClientEditAK="e";

ListViewDefaults.Strings.L_SPClientEditTooltip="Open a selected document for editing.";

ListViewDefaults.Strings.L_SPClientUpload="upload";

ListViewDefaults.Strings.L_SPClientUploadAK="u";

ListViewDefaults.Strings.L_SPClientUploadTooltip="Upload a document from your computer to this library.";

ListViewDefaults.Strings.L_SPClientShare="share";ListViewDefaults.Strings.L_SPClientShareAK="s";

ListViewDefaults.Strings.L_SPClientShareTooltip="Invite people to a selected document or folder.";

ListViewDefaults.Strings.L_SPClientManage="manage";

ListViewDefaults.Strings.L_SPClientManageAK="m";

ListViewDefaults.Strings.L_SPClientManageTooltip="Do other activities with selected documents or folders.";

ListViewDefaults.Strings.L_SPClientSync="sync";

ListViewDefaults.Strings.L_SPClientSyncAK="y";

ListViewDefaults.Strings.L_SPClientSyncTooltip="Create a synchronized copy of this library on your computer.";

ListViewDefaults.Strings.L_SPClientNumComments="Number of Comment(s)";

ListViewDefaults.Strings.L_SPEmailPostLink="Email Post Link";

ListViewDefaults.Strings.L_SPSelected="Selected";

ListViewDefaults.Strings.L_SPGroupBoardTimeCardSettingsNotFlex="Normal";

ListViewDefaults.Strings.L_SPView_Response="View Response";

ListViewDefaults.Strings.L_SPYes="Yes";

ListViewDefaults.Strings.L_SPNo="No";

ListViewDefaults.Strings.L_SPRelink="Relink";

ListViewDefaults.Strings.L_SPMerge="Merge";

ListViewDefaults.Strings.L_SPMeetingWorkSpace="Meeting Workspace";

ListViewDefaults.Strings.L_BusinessDataField_Blank="(Blank)";

ListViewDefaults.Strings.L_BusinessDataField_ActionMenuLoadingMessage="Loading...";

ListViewDefaults.Strings.L_BusinessDataField_ActionMenuAltText="Actions Menu";

ListViewDefaults.Strings.L_RelativeDateTime_AFewSecondsFuture="In a few seconds";

ListViewDefaults.Strings.L_RelativeDateTime_AFewSeconds="A few seconds ago";

ListViewDefaults.Strings.L_RelativeDateTime_AboutAMinuteFuture="In about a minute";

ListViewDefaults.Strings.L_RelativeDateTime_AboutAMinute="About a minute ago";

ListViewDefaults.Strings.L_RelativeDateTime_XMinutesFuture="In {0} minute||In {0} minutes";

ListViewDefaults.Strings.L_RelativeDateTime_XMinutes="{0} minute ago||{0} minutes ago";

ListViewDefaults.Strings.L_RelativeDateTime_XMinutesFutureIntervals="1||2-";

ListViewDefaults.Strings.L_RelativeDateTime_XMinutesIntervals="1||2-";

ListViewDefaults.Strings.L_RelativeDateTime_AboutAnHourFuture="In about an hour";

ListViewDefaults.Strings.L_RelativeDateTime_AboutAnHour="About an hour ago";

ListViewDefaults.Strings.L_RelativeDateTime_Tomorrow="Tomorrow";

ListViewDefaults.Strings.L_RelativeDateTime_Yesterday="Yesterday";

ListViewDefaults.Strings.L_RelativeDateTime_TomorrowAndTime="Tomorrow at {0}";

ListViewDefaults.Strings.L_RelativeDateTime_YesterdayAndTime="Yesterday at {0}";

ListViewDefaults.Strings.L_RelativeDateTime_XHoursFuture="In {0} hour||In {0} hours";

ListViewDefaults.Strings.L_RelativeDateTime_XHours="{0} hour ago||{0} hours ago";

ListViewDefaults.Strings.L_RelativeDateTime_XHoursFutureIntervals="1||2-";

ListViewDefaults.Strings.L_RelativeDateTime_XHoursIntervals="1||2-";

ListViewDefaults.Strings.L_RelativeDateTime_DayAndTime="{0} at {1}";

ListViewDefaults.Strings.L_RelativeDateTime_XDaysFuture="{0} day from now||{0} days from now";

ListViewDefaults.Strings.L_RelativeDateTime_XDays="{0} day ago||{0} days ago";

ListViewDefaults.Strings.L_RelativeDateTime_XDaysFutureIntervals="1||2-";

ListViewDefaults.Strings.L_RelativeDateTime_XDaysIntervals="1||2-";

ListViewDefaults.Strings.L_RelativeDateTime_Today="Today";

ListViewDefaults.Strings.L_UserFieldInlineTwo="^1 and ^2";

ListViewDefaults.Strings.L_UserFieldInlineThree="^1, ^2, and ^3";

ListViewDefaults.Strings.L_UserFieldInlineMore="^1, ^2, ^3, and ^4^5 more^6";

ListViewDefaults.Strings.L_SPCheckedoutto="Checked Out To";

ListViewDefaults.Strings.L_viewedit_onetidSortAsc="Sort Ascending";

ListViewDefaults.Strings.L_viewedit_onetidSortDesc="Sort Descending";

If you notice any more nuances to the “Quick Edit” in SP2013, then let us know in the comments below!

Links

2 responses to ““or edit this list” (Quick Edit Part 1)”

  1. Pingback: itgroove Blogs » “or edit this list” (Quick Edit Part 1)

  2. ‘Grouping’ got me… but you have no idea how much searching was required to find your simple checklist.

    Much appreciated.

Comments are closed.