Skip Ribbon Commands
Skip to main content

Helpdesk

:

FAQ: Copy and paste a ShPt "List" into Excel et al.

Version HistoryVersion History

Title

Copy and paste a ShPt "List" into Excel et al.

Answer

With Windows and Microsoft products, there is an option "Export to Excel file" in the Ribbon, which works. It will need some time to make this function compatible with other OS and non-MS spreadsheet appplications. Here is a workaround, which is faster in any case:

solution screencast (Click on picture for screencast sequence [1'17"]!)

Description:

  1. Select a convenient View for your List, containing all necessary columns and lines. Eventually create your personal View.
  2. Use mouse to select all or part of the displayed table. Use copy function of your browser.
    (Only Firefox has been tested by us. Probably others work as well.)
  3. Open your spreadsheet application.
  4. Depending on your application, use the appropriate copy function to insert the table content into a new spreadsheet:
    1. Excel (as in screencast): Right-click and Special Paste. Choose "Text" format.
    2. OpenOffice Calc: Use the standard paste function (Ctrl-V key or Edit::Paste menu).
  5. Adapt contents and columns in spreadsheet as usual.
Please report other flavours or applications, if you can test them!

Link

 

Date

30/12/2011

Rating (0-5)

Item is currently unrated. Press SHIFT+ENTER to rate this item.1 star selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+ESCAPE to leave rating submit mode.2 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.3 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.4 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.5 stars selected. Press SHIFT+ENTER to submit. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.

Number of Ratings

0

Topic, related to

SharePoint
Approval Status Approved
Yes!

Attachments

ShPt-CopyNPaste-Table.wmv    
Content Type: Item
Version: 2.0
Created at 30/12/2011 09:10 by Dirk Hoffmann
Last modified at 04/01/2012 13:55 by Dirk Hoffmann