2.9.3 Cut, Copy and Paste

<< Click to Display Table of Contents >>

Navigation:  2. ShipWeight Basics > 2.9 The Item window: Entering Weight Information >

2.9.3 Cut, Copy and Paste

ShipWeight Basics > The Item Window: Entering Weight Information

The Item Window box has Cut, Copy and Paste functionality for the items listed in the table. Items can be cut or copied from ShipWeight and pasted into a spreadsheet, e.g. Excel. Select one or several rows in the table. Click the Cut or Copy button on the toolbar or from the Edit menu select Cut or Copy. Alternatively, press CTRL+X to cut or CTRL+C to copy.

Seemingly, large numbers are rounded when copying from ShipWeight to Excel. For example, the unit weight 7777777.7777 in ShipWeight will display as 7777778 in Excel.

To display the correct value in Excel, the proper Cell-formatting must be set. Mark all the cells containing numbers, right-click the mouse, and select Format Cells…. In the Format Cells window, the cells are of the category General. This should be changed to Number. Also set Decimal places to 4. Excel will now correctly display 7777777.7777.

Data can be copied from a spreadsheet to ShipWeight. Before copying data into ShipWeight, make sure the item numbers are not duplicated. Also verify that the order of the data in the spreadsheet is the same as the order of the columns in the table of the Items window. To check that the order of the data is correct, it can be useful to use the Copy Heading option from the Edit menu of the Items window. Now, the heading of the table view can be pasted into the spreadsheet to verify the order of the data.

To copy the data back into ShipWeight, select and copy the data in the spreadsheet. In ShipWeight, select Paste either on the toolbar, the Edit menu or by pressing CTRL+V. The items will now be pasted into the table.

Please note that it is not advisable to copy very large figures from Excel to ShipWeight without first formatting the cells in Excel to Number with a proper number of decimal places.