c# barcode zebra printer Part 9: Managing Databases and Lists in C#.NET

Encoding QR in C#.NET Part 9: Managing Databases and Lists

Managing Information in Lists SharePoint changes and abandon your own, click Discard My Changes. To force your own changes to be accepted, you ll need to display the list in SharePoint and make the changes there (or delete the other user s changes in SharePoint and then click Retry My Changes in Excel). If you have more than one conflicting cell, Excel will ask you to resolve the first one. Then it will present the second, and so on. You can discard or retry all of your changes at once using the buttons at the bottom of the Resolve Conflicts And Errors dialog box.

Figure 28-6. If your list has been changed both in SharePoint and on the worksheet since your last synchronization, you ll be asked to resolve each conflict in this dialog box.

If you make changes to your copy of the list and then save your workbook without synchronizing, Excel will display a warning dialog box. The next time you open the workbook, however, you will see the following:

If you want to preserve the changes you made earlier and eventually synchronize those changes with the SharePoint copy, click Yes. The changes then will remain pending, and you can perform a synchronization immediately or later, as you choose.

28

If you make changes to your list in Excel but subsequently change your mind about those changes, you can discard your changes and restore a fresh copy of the list as it stands in SharePoint. Choose Data, List, Discard Changes And Refresh, or click the tool for that command on the List toolbar.

Microsoft Office Excel 2003 Inside Out If you do not want to synchronize your changes with SharePoint, click No. Excel will then display your workbook as it was when you last saved it that is, with the unsynchronized changes in place. But if you then try to change the list in any way, you will see the following:

This is Excel s way of saying that your list is currently in an anomalous state: You ve made changes to it, but no synchronizable changes are pending. To restore the list to normal functioning, you can either unlink it (choose Data, List, Unlink List) or revert to the data that exists on the SharePoint server (choose Data, List, Discard Changes And Refresh). If you got to this state by mistake that is, if you really did want to update the SharePoint copy with your previously unsynchronized changes you should do neither. Instead, close your workbook, reopen it, and choose Load Changes instead of Discard Changes. Dealing with Calculated Columns in Lists Linked to SharePoint If you need to develop a shared list that involves calculations, it's best to create it in SharePoint and then export it to Excel, rather than working the other way around. That's because any calculated columns you've set up in Excel will be converted to constants when you publish. But what if you already have an Excel list and you're not eager to recreate it from scratch in SharePoint In that case, the best approach is to publish the list you have and then massage it in SharePoint. The following example will illustrate this. Suppose that in Excel you have created the list of quarterly scores shown in Figure 28-7. You would like to publish this to your SharePoint site so that the various groups can update the list with their fourth-quarter scores. You would also like to be able to synchronize your worksheet and the SharePoint list from time to time as new data arrives. Unfortunately, the SUM formulas in column F will be replaced by the current values in F2:F6 as soon as you publish.