Modifying Older Workbooks to Get Them to Work With Version 1.0.1.96 and Later

Oct 15, 2009 at 4:18 AM
Edited Oct 15, 2009 at 6:42 AM

Version 1.0.1.96 of NodeXL made some changes in the way vertex images and labels are specified.  If you use 1.0.1.96 or a later version only to create new workbooks, or if you haven’t used images or labels in your older NodeXL workbooks, you can ignore this topic.  This is for people who want to open older NodeXL workbooks that used images or labels, which won’t appear in version 1.0.1.96’s graph pane unless you modify the older workbooks.

 

If your old workbook used secondary labels (text annotations next to the vertices), do the following:

1. Rename the Secondary Label column on the Vertices worksheet to Label.

 

If your old workbook used primary labels (vertices drawn as boxes containing text), do the following:

1. Rename the Primary Label column on the Vertices worksheet to Label.

2. Disable Excel’s data validation on the Shape column on the Vertices worksheet.

    A. Select all the data in the Shape column.

    B. In Excel’s ribbon, select Data, Data Tools, Data Validation, Data Validation.

    C. On the Settings tab of the Data Validation dialog box, set Allow to "Any value".

3.  For each vertex row that used a primary label, enter “Label” into the Shape cell.

 

If your old workbook used primary label fill colors, do the following:

1.  Rename the Primary Label Fill Color column on the Vertices worksheet to Label Fill Color.

 

If your old workbook used images, do the following:

1.  Add an “Image File” column to the right edge of the vertex table on the Vertices worksheet.

2.  Set the Image File column contents to this formula:

    =VLOOKUP(Vertices[[#This Row],[Image ID]], Images, 2, FALSE)

3.  Disable Excel’s data validation on the Shape column on the Vertices worksheet.  (See above.)

4.  For each vertex row that used an image, enter “Image” into the Shape cell.

 

If your old workbook used the What to Show column, do the following:

1.  Disable Excel’s data validation on the Shape column on the Vertices worksheet.  (See above.)

2.  For each vertex row that had What to Show set, set the Shape cell to one of the old shapes, or enter “Label” or “Image”.