Complete NodeXL Release History

1.0.1.111 (In Progress)

• The Dynamic Filters feature (NodeXL, Analysis, Dynamic Filters) now includes a histogram for each Excel column that can be used for filtering. The histogram shows the distribution of the values in the column.

1.0.1.110 (2010-02-03)

• The Overall Metrics worksheet now includes more information about the degree, in-degree, out-degree, betweenness centrality, closeness centrality, eigenvector centrality, and clustering coefficient metrics when those metrics are computed. The additional information includes the minimum, maximum, average, and median metric values, and a histogram showing the metric value distribution.
• The "Convert Old Workbook" item on the NodeXL, Data, Import menu in the Ribbon is now called "Import from NodeXL Workbook Created on Another Computer." This menu item can be used to work around the following problem: NodeXL workbooks created on a 64-bit Windows computer cannot be opened directly in Excel on a 32-bit Windows computer, and vice-versa. (If you attempt to do so, you will get an error message whose details include "could not find a part of the path.")
• A Clear All Worksheet Columns Now button has been added to the Autofill Columns dialog box (NodeXL, Visual Properties, Autofill). Also, you can now clear an individual worksheet column by clicking a button in the dialog box's Options column.
• Bug fix: On large-font machines, the buttons at the bottom of the Autofill Columns dialog box didn't fit within the dialog box.
• Bug fix: In some circumstances, vertices were drawn below the bottom of the graph pane and were impossible to see. One such circumstance was when the selection was exported to a new workbook (NodeXL, Data, Export, Selection to New NodeXL Workbook). The graph pane in the new workbook acted as if it were taller than its real height, leading to vertices dropping off the bottom.

1.0.1.109 (2010-01-26)

• Overall Metrics (NodeXL, Analysis, Graph Metrics, Miscellaneous, Overall Metrics) now include the graph's maximum geodesic distance (also known as graph diameter) and average geodesic distance.
• Overall Metrics now also include the number of connected components in the graph, the number of connected components that have only one vertex, the maximum number of vertices in a connected component, and the maximum number of edges in a connected component.
• If you are using the graph legend (NodeXL, Show/Hide, Graph Elements, Legend) to show visual properties that have been autofilled from numeric source columns (NodeXL, Visual Properties, Autofill Columns), you can now control the number of decimal places that are shown in the legend. To do so, format the source column in the worksheet as Numeric (Home, Cells, Format, Format Cells) and set Decimal Places to your desired value.
• The setup program has been modified to allow NodeXL to be installed on computers that have Office 2010 Beta. It has been tested only with the "Microsoft Office Professional Plus 2010 Beta" edition and is not guaranteed to work with all Beta editions and configurations.
• The Twitter search network (NodeXL, Data, Import, From Twitter Search Network) has been modified to accommodate a January 18 change in the Twitter search API. The change involved what happens when Twitter rate limiting kicks in.
• Bug fix: On Windows XP machines that have Windows Desktop Search 4.0 installed, subject text searches did not work when importing from an email network (NodeXL, Data, Import, From Email Network). If you checked "Subject Includes text" and specified subject text, no emails would be found.
• Bug fix: When exporting the selection to a new workbook (NodeXL, Data, Export, Selection to New Workbook), the new workbook sometimes contained duplicate edges and vertices, depending on how the edges and vertices in the original workbook were selected.
• Bug fix: When using Autofill Columns, if you autofilled a color column from a source column that contained all zeros, you would get an "ArgumentOutOfRangeException" message that started with "ColorGradientMapper.Initialize: dMaxColorMetric must be > dMinColorMetric."
• Bug fix: If you used an Excel table filter (the down-arrows within the table column headers) to filter out the first row of the Edges or Vertices worksheet and then clicked Show Workbook, an "Assertion Failed" dialog box would pop up with a message that started with "at ExcelUtil.TryGetNonEmptyRange(Range range, Range& usedRange)."

1.0.1.108 (2010/01/14)

• There is a new "Binned" option in the list of layout algorithms (NodeXL, Graph, Layout in the Excel ribbon). The Binned layout places the graph's smaller connected components (those with one, two, or three vertices) at the bottom of the graph pane, then lays out the rest of the vertices in the remaining space.

1.0.1.107 (2010/01/06, Private Release)

• Added an "Auto Layout on Open" row to the hidden PerWorkbookSettings table. When the NodeXL workbook is being filled in by an external program, this allows the program to set the layout algorithm and force the workbook to be automatically read into the graph.

1.0.1.106 (2010/01/06)

• You can now add a background image to the graph. Go to NodeXL, Visual Properties, Background in the Excel ribbon to specify the image. (Known issue: When the scale of the graph is changed using the Scale slider in the graph pane, the scale of the background image changes as well.)
• You can now set the graph background color for the current workbook only, and the color will get stored within the workbook. To set the background color for the current workbook, go to NodeXL, Visual Properties, Background. To set the default background color for new workbooks, go to Options in the graph pane.
• Bug fix: In the Flickr user's network (NodeXL, Data, Import, From Flickr User's Network), if you check the "Add a vertex for each person who commented on the user's photos" option, the commenters will now appear in the Vertex 1 column instead of the Vertex 2 column. In previous versions, the commenter edges were pointing in the wrong direction.
• Bug fix: In the Flickr user's network, the Comment Time (UTC) column had erratic formatting on computers using the Portuguese language, and probably other languages as well.
• Bug fix: In the YouTube user's network (NodeXL, Data, Import, From YouTube User's Network), the "Joined YouTube Date" column in the Vertices worksheet could be off by one day, and it wasn't clear which time zone the date corresponded to. The column has been renamed "Joined YouTube Date (UTC)."
• Bug fix: In the YouTube video network (NodeXL, Data, Import, From YouTube Video Network), the "Created Date" column in the Vertices worksheet could be off by one day, and it wasn't clear which time zone the date corresponded to. The column has been renamed "Created Date (UTC)."
• Bug fix: On computers that use a "DPI scaling" other than 96 DPI (on Vista, for example, go to Control Panel, Personalization, Adjust font size (DPI), Larger Scale), images would always get scaled, even if you went to Options in NodeXL's graph pane and set Size (images) to "Actual size."

1.0.1.105 (2009/12/16)

• The list of available layouts (NodeXL, Graph, Layout) now includes Polar Absolute. This differs from the older Polar layout (which is still available) in that the Polar R values are in absolute units of 1/96 inch, and there are no value limits. In the older Polar layout, Polar R ranges from 0.0 to 1.0, where 1.0 represents one-half the graph pane's width or height, whichever is smaller.
• The maximum Size value on the Vertices worksheet has been increased from 10 to 100. A Size value of 10 results in the same size vertex as before, so you won't notice this change unless you specify values greater than 10.
• Bug fix: When switching windows while a long-running operation was in progress, and error message starting with "[COMException]: Exception from HRESULT: 0x800AC472" would occasionally pop up.

1.0.1.104 (2009/12/09)

• The way Twitter, Flickr, and YouTube request errors are dealt with has been overhauled. NodeXL used to deal with such an error by retrying the request several times, with pauses between retries. If the retries didn't work, NodeXL would stop the import process and ask whether you wanted to import the partial network obtained before the request failed. Now, NodeXL does not stop. Instead, it attempts to get the rest of the network, and at the end of the process it tells you how many requests failed. Thus, you will always get a network (unless the very first request fails), and it is up to you to decide whether the number of failures is acceptable.
• In the Flickr user's network (NodeXL, Data, Import, From Flickr User's Network), checking "add user information to the Vertices worksheet" now populates the Image File column with a photo of each user.
• In the Twitter search network (NodeXL, Data, Import, From Twitter Search Network), checking "Add a Tweet column to the Vertices worksheet" now also adds a Tweet Date column.
• Similarly, in the Twitter user network (NodeXL, Data, Import, From Twitter User's Network), checking "Add a Latest Tweet column to the Vertices worksheet" now also adds a Latest Tweet Date column.
• You can now fill the Edge Label column using Autofill Columns. (Go to NodeXL, Visual Properties.)

1.0.1.103 (2009/12/01)

• You can now import a network of Flickr users. Go to NodeXL, Data, Import, From Flickr User's Network.
• Some improvements were made to the way Twitter, YouTube, and Flickr server errors are handled.
• Bug fix: When using Autofill Columns (NodeXL, Visual Properties, Autofill Columns) to fill one or more edge columns but zero vertex columns, the graph legend (NodeXL, Show/Hide, Graph Elements, Legend) would show a "Vertex Properties" column header instead of the correct "Edge Properties."

1.0.1.102 (2009/11/26)

• The feature that imports a network of related Flickr tags has been improved. (It's at NodeXL, Data, Import, From Flickr Related Tags Network.) You can now select the number of network levels to include, an optional sample image file can be included for each tag, and the dialog now provides feedback as it requests the various parts of the network from Flickr.

1.0.1.101 (2009/11/24)

• Bug fix: When importing a network of YouTube videos (NodeXL, Data, Import, From YouTube Video Network), you could sometimes get an error message that started with "Namespace prefix 'g' is not defined."

1.0.1.100 (2009/11/18)

• You can now import a network of YouTube videos. Go to NodeXL, Data, Import, From YouTube Video Network.
• When importing a YouTube user's network (NodeXL, Data, Import, From YouTube User's Network), "subscribes to" relationships are now differentiated in the Relationship column on the Edges worksheet. Such relationships are now marked as "subscribes to channel," "subscribes to favorites," or "subscribes to playlist."
• Bug fix: If a problem occurred while getting a Twitter or YouTube user's network and you decided to import the partial network that had already been obtained, you could get this error message: An "edge" XML node references the node id "...", for which there is no corresponding "node" XML node.'
• Bug fix: The Twitter Search Network feature was failing to recognize a reply-to or mentions if the replied-to or mentioned screen name was followed by a colon, as in "@johndoe: Hello".
• Bug fix: The Twitter Search Network feature was not recognizing a reply-to as a mentions. Twitter defines a "mentions" as "any Twitter update that contains @username in the body of the tweet." Therefore, NodeXL now considers a reply-to to be both a reply-to and a mentions.

1.0.1.99 (2009/11/14, private release)

• Added a workaround for the following error encountered on at least one computer when attempting to get a Twitter network: "The request was aborted: The request was canceled."

1.0.1.98 (2009/11/12)

• When computing graph metrics (NodeXL, Analysis, Graph Metrics), betweenness and closeness centralities are now computed simultaneously instead of sequentially, saving significant time when analyzing a large graph.
• You can now import a network of YouTube users. Go to NodeXL, Data, Import, From YouTube User's Network.
• If a problem is encountered while importing a Twitter network (NodeXL, Data, Import, From Twitter Search Network and From Twitter User Network), you are now given the option of importing the partial network that was obtained before the problem occurred. In previous versions, any glitch in the connection to Twitter would result in a failure and you would have to start the import again.
• Additional information on Twitter users is now provided. For the Twitter User Network, the following columns are now added to the Vertices worksheet: Description, Favorites, Time Zone, Time Zone UTC Offset (Seconds), Joined Twitter Date. For the Twitter Search Network, these columns will be added only if "Add statistic columns to the Vertices worksheet (slower)" is checked.
• When importing an email network (NodeXL, Data, Import, From Email Network), you can now filter on the subject text.

1.0.1.97 (2009/10/28)

• Vertices with the shape "Label" can now be resized using the Size column on the Vertices worksheet. Setting the Size column changes the height of the font, and the overall vertex size adjusts accordingly. The default font height is set using Options, Labels in the graph pane.
• You can now set the position of vertex labels that are shown as annotations. To set the default position, use Options, Labels in the graph pane. To set positions on a per-vertex basis, use the new Label Position column on the Vertices worksheet. (The new column is hidden by default, along with the other label columns. To show the label columns, go to NodeXL, Show/Hide, Workbook Columns in the Excel ribbon and check the Labels menu item.)
• You can now truncate long vertex and edge labels in the graph pane. Use Options, Labels.
• Vertex and edge labels can now be hidden. In the Excel ribbon, use NodeXL, Show/Hide, Graph Elements, Vertex Labels and Edge Labels.
• The drop-down lists in the NodeXL workbook have been simplified for readability and ease of typing. In the Shape column on the Vertices worksheet, for example, you can now select or type "Circle" instead of the old "Circle (1)". For backward compatibility, the old options will still be recognized when you read a workbook created with an older version of NodeXL.
• The color of the border drawn around images can now be set using the Color column on the Vertices worksheet. The border also uses any specified Opacity value.
• The Image and Label shapes have been added to the NodeXL, Visual Properties, Vertex Shape menu in the Excel ribbon. They were accidentally omitted in the previous release.
• Bug fix: Custom colors created in the Options dialog box were not retained, and custom colors created from within the workbook weren't available from Options. Now, a custom color created anywhere will be available anywhere else in the same workbook. (Custom colors are not shared between workbooks, however.)
• Bug fix, redux: Dynamically filtering vertices shown as images sometimes left "shadows" of the image outlines on the screen. The alleged fix in version 1.0.1.96 didn't work on all machines. This fix should always work, so long as the filter opacity in the Dynamic Filters dialog box is set to 0%. (If the opacity is greater than 0%, you might still see an outline shadow.)

1.0.1.96 (2009/10/14)

• Using images for vertices has been simplified. To show a vertex as an image, set the Shape cell on the Vertices worksheet to Image, then fill in the new Image File cell. Image IDs have been eliminated and the Images worksheet no longer exists.
• Vertex labels now work differently. Instead of "Primary Label" and "Secondary Label" columns, there is now a single "Label" column, and the list of vertex shapes now includes "Label." To show a vertex as a box containing text, set the Shape cell on the Vertices worksheet to Label, then fill in the Label cell with the text. To "annotate" another vertex shape with text, set the Shape to something else and fill in the Label cell with the annotation text. You cannot annotate a Label shape.
• The "What to Show" column on the Vertices worksheet has been removed. It is no longer needed, because every vertex now has a shape and you control what is shown (image, label, or another shape) via the Shape column.
• The "Primary Label Fill Color" column on the Vertices worksheet is now "Label Fill Color."
• The part of NodeXL that communicates with the Twitter Web service has been updated to accommodate Twitter API changes that go into effect on October 26, 2009. Older versions of NodeXL will not work properly with Twitter starting on that date.
• Although importing from Twitter provided URLs to the Twitter users' photos, the photos were difficult to actually get into the graph. Now if you want to show the photos, just set the Shape column on the Vertices worksheet to Image after importing from Twitter.
• Bug fix: If you used "near:" or "within:" when importing from a Twitter search network, you would get an incorrect error message concerning rate limiting. Now, you will get a message telling you that Twitter doesn't allow "near:" or "within:" to be used when searching from an outside program, such as NodeXL.
• Bug fix: Non-English words were not handled properly when importing from a Twitter search network. This caused a "There are no people in that network" message to be displayed when searching for tweets that contained Korean words, for example.
• Bug fix: If a Twitter user's list of people he is following or are following him included someone who was "suspended" by Twitter, NodeXL sometimes didn't get the complete list.
• Bug fix: Dynamically filtering vertices shown as images sometimes left "shadows" of the image outlines on the screen.

1.0.1.95 (2009/09/28)

• When an email network is analyzed (NodeXL, Data, Import, From Email Network), the resulting graph is now directed. This means that the relationships (John,Mary) and (Mary,John) are no longer combined into a single edge with an edge weight of 2; instead, they are considered unique edges.

1.0.1.94 (2009/09/28)

• When importing a Twitter search network (NodeXL, Data, Import, From Twitter Search Network), you can now add a Tweet column to the Vertices worksheet.
• When importing a Twitter user network (NodeXL, Data, Import, From Twitter User Network), you now have some options for how edges get added to the graph. You can add an edge for each followed/following relationship (which was always done in previous versions), each "replies-to" relationship in the people's latest tweets, and each "mentions" relationship in the latest tweets.
• Ditto for the Twitter search network, although in this case the "replies-to" and "mentions" relationships apply to the tweets that satisfied the search criteria, which aren't necessarily the people's latest tweets.
• Twitter search networks and Twitter user networks now add an Image URL column to the Vertices worksheet. The images are those of the people who wrote the tweets.
• Bug fix: In the Import from Twitter Search Network dialog box, the word "latest" was removed from the text, "Search for people whose latest tweets contain..." Reason: The tweets returned by the search aren't necessarily the people's latest tweets.
• Bug fix: When importing a Twitter search network, a tweet posted by a person with "protected" status in Twitter would bring the search to a halt with a "There is no Twitter user with that screen name" error. Now, such people are skipped.
• Bug fix: Using any of the NodeXL, Data, Import items in the ribbon failed to clear the Images worksheet before importing the new data.

1.0.1.93 (2009/9/18)

• You can now import a Twitter network of users who have tweeted a specified term. For example, you can create a graph with a vertex for each person who has included the hashtag "#chi2010" in a tweet, with an edge between the people who follow each other. In the Excel Ribbon, go to NodeXL, Data, Import, From Twitter Search Network.
• When including an image in a graph, you can now specify an URL to an image on the Internet.
• When an image file isn't available, an error message is no longer displayed. Instead, a small red X is shown in the graph in place of the missing image.
• Images can now be resized using the Size column on the Vertices worksheet. There are new options in the Options dialog box for setting the default image size. (Known bug: Changing the default image size doesn't update the graph pane until the workbook is refreshed.)
• When importing from a Twitter user's network (NodeXL, Data, Import, From Twitter User's Network), a Relationship column is added to the Edges worksheet. This gets set to Followed or Follower.
• The Twitter dialog boxes now provide feedback on what they're doing as they assemble the requested network.
• Bug fix: Attempting to get a Twitter user network that included someone who "protected" her Twitter identity would cause a failure. Now, that user is skipped and the rest of the network is obtained.
• Bug fix: There was a rounding error with very small numbers (on the order of 1.0E-22) that could cause some vertices or edges to always be filtered out by Dynamic Filters, even if the filters were reset to their entire range.

1.0.1.92 (2009/9/4)

• In the Autofill Columns dialog box (NodeXL, Visual Properties, Autofill Columns), you can now specify a logarithmic mapping instead of a linear mapping when autofilling Edge Color, Edge Width, Edge Opacity, Vertex Color, Vertex Size, Vertex Opacity, Vertex Primary Label Fill Color, Vertex Layout Order, Vertex X, Vertex Y, Vertex R, or Vertex Polar Angle. Click one of the Options buttons, then check "use a logarithmic mapping."
• You can now import a network of Flickr tags related to a specified tag. Use NodeXL, Import, From Network of Related Flickr Tags. You will need what Flickr calls an "API key." There is a link in the Import dialog box for requesting a key from Flickr.
• The Twitter import feature has been expanded. (It's at NodeXL, Import, From Twitter User's Network.) You can now import the network of people followed by a user, people following a user, or both. There is a new option for selecting a 1, 1.5, or 2-level network, and you can limit the network to a specified number of people. New columns are added to the Vertices worksheet: Followed, Followers, Tweets, and (optionally) Latest Tweet. Also, you can right-click a vertex in the graph pane and select the new Open Twitter Page for This Person menu item.
• Bug fix: When using dynamic filters, a filtered edge's label obscured what was under it even though the edge itself was hidden.
• For programmers only: The IGraphDataProvider interface used by data provider plug-ins for the Excel Template has changed. The GetGraphData() method is now called TryGetGraphData() and it now returns a Boolean. (The original design failed to accommodate failures while getting graph data.)

1.0.1.91 (2009/8/19)

• You can now label edges by filling in a new Label column on the Edges worksheet. The Label column is hidden by default. To make it visible, use NodeXL, Show/Hide, Workbook Columns, Labels in the Excel Ribbon.
• You can now import a graph from a GraphML file. GraphML is an XML-based file format used by a variety of graph applications and libraries, including Pajek, "R," and JUNG. NodeXL will import all edge and vertex attributes in a GraphML file, including those that correspond to standard NodeXL columns such as Edge Color and Vertex Size. Use NodeXL, Data, Import, From GraphML File.
• Importing from a Twitter network (NodeXL, Data, Import, From Twitter Network) is now more reliable, thanks to automatic retries that will occur if a request to Twitter fails.
• Of possible interest to developers: NodeXL now supports custom "plug-in" .NET assemblies that will import graphs from custom data sources. For details, see the IGraphDataProvider Interface topic in the NodeXLApi.chm help file and the sample implementation in SampleGraphDataProvider.cs.
• The graph legend is now more compact. (To show the legend, use NodeXL, Show/Hide, Graph Elements, Legend.)
• Bug fix: When importing from an open edge workbook (NodeXL, Data, Import, From Open Edge Workbook), columns in the open edge workbook that have the same name as standard NodeXL columns will be copied to those NodeXL columns. Before, a column named "Color" was copied to "Color 2," for example.
• Bug fix: Your settings, such as those entered in the Options dialog box, are now stored in a single file in your local Windows profile. Before, each named NodeXL workbook got its own settings file.

1.0.1.90 (2009/7/24)

• When you import data into the workbook (NodeXL, Data, Import), you now have the option to append the imported data to the workbook's contents instead of clearing the workbook first. Check or uncheck the NodeXL, Data, Import, Clear NodeXL Workbook First checkbox to control this.
• The Closeness Centrality graph metric (NodeXL, Analysis, Graph Metrics) is now computed much more quickly. For example, with a graph containing about 1,000 vertices and 1,000 edges, the computation time went from 31 seconds to 3 seconds, and with a larger graph containing 5,000 vertices and 8,000 edges, the time went from 63 minutes to 2 minutes.
• The graph legend is now hidden by default.
• Your settings for showing or hiding the graph legend and axes (NodeXL, Show/Hide, Graph Elements) are now saved along with the rest of your settings.
• If you autofill the X and Y columns in the Vertices worksheet (NodeXL, Visual Properties, Autofill Columns), the Locked column is no longer automatically set to Yes. Instead, the Layout (NodeXL, Graph, Layout) is set to None, which achieves the same effect but is easier to undo. If you no longer want the autofilled X and Y values, just set the Layout to something else.
• In the options dialog boxes within the Autofill Columns dialog box, there is now a "Swap" button that will quickly swap the colors or numbers you are autofilling.
• You can now change the font used for the graph axes. In the graph pane, go to Options, Axis Font.
• The Auto Refresh checkbox that used to be in the NodeXL, Visual Properties Ribbon group is now in the Options dialog box, reachable from the graph pane.
• Bug fix: In the Import From Twitter Network feature, the screen name and password were not being correctly sent to Twitter. This caused Twitter rate limiting to kick in even if your rate limit had been lifted by Twitter.

1.0.1.89 (2009/7/9)

• There are now X and Y axes in the graph pane. To show them, check the NodeXL, Show/Hide, Graph Elements, Axes checkbox in the Excel Ribbon. If you autofill the X and Y columns in the Vertices worksheet (NodeXL, Visual Properties, Autofill Columns), the axes will show the range of autofilled values. Otherwise, the axes simply show NodeXL's full range of coordinate values (0 to 9,999).
• You can now export the NodeXL workbook's edges to a UCINET file. The file format is what UCINET calls "full matrix DL." Go to NodeXL, Data, Export, To UCINET Full Matrix DL File in the Ribbon.
• You can also import a UCINET full matrix DL file. Go to NodeXL, Data, Import, From UCINET Full Matrix DL File in the Ribbon. If you have a file in a different UCINET format, you will need to use the UCINET program to convert it to full matrix DL. Click on the "What if my file is not in full matrix DL format?" link in the Import dialog box for instructions.
• You can now export the NodeXL workbook's edges to a Pajek file. Go to NodeXL, Data, Export, To Pajek File in the Ribbon. The vertex coordinates are exported, but no other edge or vertex attributes are.

1.0.1.88 (2009/6/18)

• A new graph layout algorithm is available. In the Ribbon, select NodeXL, Graph, Layout, Harel-Koren Fast Multiscale.
• You can now save a graph image in a vector graphics format, in addition to the raster formats that have always been available. Right-click the graph pane; select Save Image to File, Save Image; and select XPS in Save As Type. XPS is Microsoft's vector file format, similar in concept to PDF. (If you need a graph image in PDF format, save the image as an XPS, then use a third-party application to convert the XPS to a PDF. Adobe Acrobat Pro can be used for this, and there are several free alternatives as well.)
• In the Import from Email Network dialog box (NodeXL, Data, Import, From Email Network), any email addresses you enter are now ORed together. They were ANDed before. This is explained in a new About Email Addresses link in the dialog box.
• In the Autofill Columns dialog box, the Vertex column now appears at the top of the lists for the Vertex Primary Label, Vertex Secondary Label, and Vertex ToolTip drop-downs. It used to be at the bottom.
• Bug fix: Locked vertices are now honored when using the Sugiyama graph layout algorithm.
• Bug fix: The color dialog box (NodeXL, Visual Properties, Color and elsewhere) now remembers any custom colors you define within one Excel session. (The dialog box's custom colors are lost when you close the workbook, however.)
• Bug fix: If you change the default font via the Options button in the graph pane, you can now use italic and bold fonts. The italic and bold options were ignored before.
• Bug fix: When saving a graph image or copying it to the clipboard, the image may not have been properly centered, depending on how the graph was zoomed and dragged.
• Bug fix: When analyzing email, an "[InvalidCastException]: Row handle is invalid" error could occur if your mailbox contained mail with unrecognized To, From, CC, or BCC fields. Such emails are now skipped.

1.0.1.86 (2009/6/4)

• There is now a legend at the bottom of the graph pane. The legend displays any dynamic filters that are in effect, along with a description of any visual properties that have been set via Schemes or Autofill Columns. To hide the legend, uncheck the NodeXL, Show/Hide, Graph Legend checkbox in the Ribbon.
• For table columns that were formatted as Text to prevent Excel from performing unwanted conversions, the Text formatting is now extended below the table to include the entire worksheet column.
• Additional columns are now formatted as Text: Cluster on the Clusters worksheet, and Cluster and Vertex on the Cluster Vertices worksheet.
• Several default settings for AutoFill columns were changed. Outliers are no longer ignored, minimum Opacity is now 10 instead of 1, and minimum Vertex Size is now 1.5 instead of 1.0.
• Bug fix: The Schemes dialog box no longer closes after it displays an error message.
• Bug fix: Opening the Options dialog box could change the selected Layout under certain conditions.
• Bug fix: Running Find Clusters when there was a vertex named "5-1", for example, resulted in a vertex named "5/1/2009" being inserted into the Cluster Vertices worksheet, which broke the Find Clusters feature. Excel has now been told in no uncertain terms that vertex names are not to be converted to something else.

1.0.1.85 (2009/5/21)

• The Visual Properties group in the Node XL Ribbon tab has been expanded. New buttons let you easily set a visual property, such as edge width or vertex color, and have the graph automatically refreshed. If you have a large graph and automatically refreshing it takes a long time, you can turn off the automatic refreshes.
• Turning off automatic refreshes also affects the Schemes and Autofill Columns features.
• The Edit Selected Vertex Attributes feature (available when right-clicking a vertex in the graph pane) is now called Edit Selected Vertex Properties.
• The Import Open Edge Workbook dialog box (NodeXL, Data, Import, From Open Edge Workbook) now automatically selects the first two columns in the selected workbook.
• Workbook columns formatted as Text, such as the vertex names, now include a comment in the column header explaining that the format must be changed to General if you want to use Excel formulas in the column. (Why are some columns formatted as Text? To avoid unwanted automatic conversions performed by Excel on General cells. Enter "1-1" in a General cell, for example, and it will turn into something like "Jan 1.")
• Bug fix: The Autofill Columns feature wouldn't autofill the vertex Radius column in old workbooks. ("Radius" was changed to "Size" in version 1.0.1.81.) Now, an old Radius column is changed to Size when the workbook is opened.

1.0.1.84 (2009/4/30)

• The Read Workbook button in the graph pane is now called Show Graph. You can show or refresh the graph by clicking either Show Graph button -- the one in the graph pane or the one in the NodeXL Ribbon (NodeXL, Graph, Show Graph).
• When you apply a visual property scheme (NodeXL, Visual Properties, Schemes), the graph is automatically refreshed.
• When you autofill one or more columns (NodeXL, Visual Properties, Autofill Columns), the graph is automatically refreshed.
• You can now delete the subgraph image thumbnails created by NodeXL, Analysis, Subgraph Images. Click the down-arrow on the Subgraph Images button and click Delete Thumbnails.
• Image file paths specified in the Images worksheet can now be either relative to the workbook's folder ("Images\Image.jpg") or absolute ("C:\MyImages\Image.jpg"). Prior to this change, an absolute path was required.
• Bug fix: Computing graph metrics on an empty workbook caused an error. The error message started with "Assertion Failed at <SplitRange>d 0.MoveNext."
• Bug fix: Hiding the Other Columns column group (NodeXL, Show/Hide, Workbook Columns) didn't hide subgraph image thumbnails.
• Bug fix: Using one of the NodeXL, Data, Import items didn't delete subgraph image thumbnails.

1.0.1.81 (2009/4/24)

• The worksheet columns are now arranged in groups that can be hidden. In the NodeXL Ribbon tab, go to Show/Hide, Workbook Columns.
• The column headers are now frozen and will remain in place as you scroll the worksheet.
• Insertion of your own columns within a NodeXL table is no longer recommended. Add them to the right end of the table instead. (Hover over "Add Your Own Columns Here" for details.)
• You can now apply a "scheme" of visual properties to your graph in one step. For example, the Weighted Graph Scheme applies edge widths based on an edge weight column you specify.
• The Radius column on the Vertices worksheet is now called Size. NodeXL will still read the Radius column in old workbooks, however.
• In the Autofill Columns dialog box, right-clicking Vertex X or Vertex Y and selecting "Clear Vertex X (or Y) Worksheet Column Now" will also clear the Locked column. (Bet you didn't know you could do that, did you?)
• Bug fix: If you manually hid an Excel column and clicked Read Workbook, an error occurred. The error message started with "[IndexOutOfRangeException]: Index was outside the bounds of the array."
• Bug fix: One of the images in the setup program was incorrect.
• New known bug: If you create subgraph images (NodeXL, Analysis, Subgraph Images) and then hide the "Other Columns" column group (NodeXL, Show/Hide, Workbook Columns), the Subgraph column on the Vertices worksheet will be hidden but the images won't.

1.0.1.80 (2009/4/5)

• There are no new features in this release, but it does introduce the first phase of the user interface redesign we're working on. Please see NodeXL Redesign for more information.

1.0.1.79 (2009/3/22)

• You can now import a graph that is stored as an adjacency matrix in another Excel workbook. In the Excel Ribbon, go to NodeXL, Graph, Import, From Open Matrix Workbook.
• You can also export a NodeXL graph to a new Excel workbook as an adjacency matrix. Go to NodeXL, Graph, Export, To New Matrix Workbook.
• The term "Tie Strength" has been replaced with "Edge Weight."
• Bug fix: Certain sequences could lead to an assertion. The assertion message started with "at ExcelUtil.TryGetSelectedTableRange(..." Here is one such sequence: Use Excel's table filtering to filter the Edges table, select the Vertices worksheet, and click Read Worksheet. Another such sequence: Filter the Edges table, select the Vertices worksheet, and click Calculate Graph Metrics.
• Bug fix: Vertex tooltips in the graph pane, which can be added to the graph with the Tooltips column in the Vertices worksheet, were partially obscured by the mouse cursor.

1.0.1.78 (2009/3/10)

• You can now read the workbook for the first time even if the Layout Type is set to None. You'll still be notified that the results won't be what you want if the graph has never been laid out, but you won't be prevented from reading the workbook, which is what happened in the previous release. You can turn off the notification if you don't want it.

1.0.1.77 (2009/3/8)

• The Autofill Columns dialog box, which is accessible via NodeXL, Graph, Autofill Columns, is now modeless. That means it can stay on the screen while you work elsewhere within Excel. Also, the specified columns get autofilled when you click a new Autofill button in the dialog box, not when you click Read Workbook in the graph pane, and a new right-click menu on the worksheet column names within the dialog box lets you immediately clear a column in the worksheet and perform other tasks.
• There is a new "None" option in the Layout Type drop-down in the graph pane. This lets you edit vertex and edge attributes in the workbook, then read the workbook again without affecting the layout.
• There is a new Polar option in the Layout Type drop-down, and new Polar R and Polar Angle columns in the Vertices worksheet. These let you place your vertices within a polar coordinate space. Hover over the new column headers for details.
• A new Layout Order column in the Vertices worksheet lets you specify the vertex order when using the Circle, Spiral, Sine Wave, and Grid layouts.
• When you save a graph image to a file using the right-click menu in the graph pane, you can now set the image size. Previously the saved image was always the same size as the graph pane, which is still an option.
• Vertex degree graph metrics no longer get inserted into the Edges worksheet.
• Bug fix: Using dynamic filters on a column that had an "#N/A" value caused an exception. The exception message started with "[InvalidCastException]: Specified cast is not valid."
• Bug fix: When NodeXL inserted a column into a worksheet, the widths of the columns to the right were messed up.
• Bug fix: An extraneous input message was removed from the first empty cell in row 2 of the Vertices worksheet.

1.0.1.76 (2009/2/18)

• For new users, there are now no graph metrics selected by default, and you will get a message explaining how to select them the first time you attempt to calculate graph metrics. This is to make the Select Graph Metrics dialog box more discoverable.
• In the Select Graph Metrics dialog box, some metrics are now marked as "slow."
• Each graph metric in the Select Graph Metrics dialog box now has a Details link that explains the metric and how it is calculated.
• The graph metrics are now divided into groups.
• Graph metrics now get inserted near the left edge of the worksheets. They used to get appended to the right edge.
• For application developers, graph metrics are now available in a separate assembly. They used to be part of the Excel Template code.
• Bug fix: Saving the graph image to the clipboard or a file via the right-click menu in the graph pane didn't work properly if the scale of the graph was changed.
• Bug fix: If an edge or vertex color was specified in the workbook, the opacity specified in the Options dialog was ignored.
• Bug fix: If a graph had a self-loop (an edge connecting a vertex to itself), switching to and from another workbook caused an error. (The first line of the error message was "at WpfGraphicsUtil.GetFarthestRectangleEdge...")

1.0.1.74 (2009/2/13)

• Eigenvector centrality was added to the list of available graph metrics, which is accessible by going to NodeXL, Analysis in the Excel ribbon and clicking the down-arrow to the right of the Calculate Graph Metrics button. Eigenvector centrality is defined at http://en.wikipedia.org/wiki/Eigenvector_centrality#eigenvector_centrality. The accelerated power method is used to obtain the dominant eigenvector.
• Closeness centrality was also added to the list. The closeness centrality of a vertex is the mean geodesic distance (shortest path) between it and all other vertices reachable from it.

1.0.1.73 (2009/2/10)

• Bug fix: With regional options in Windows set to Slovak (and some other languages as well), selecting vertices in the graph pane caused an exception. The exception message started with "[COMException]: Exception from HRESULT: 0x800A03EC."
• The default strength of the repulsive force between vertices in the Layout Options dialog box (accessible from the Options dialog box) is now 3.0. (It was 6.0.)

1.0.1.72 (2009/2/8)

• Bug fix: If you attempted to open the NodeXL template on a machine whose regional options specified a comma instead of a period for the decimal character, an exception would occur. The exception message was "The property 'LayoutUserSettings' could not be created from it's [sic] default value. Error message: Input string was not in a correct format."
• The mouse wheel now zooms the graph more quickly.

1.0.1.71 (2009/2/3)

• You can now zoom into the graph and set the size of the canvas the graph is drawn on. Click the "About Zoom and Scale" link in the graph pane for details.
• You can now move a group of vertices by selecting them and dragging any one of them with the mouse. You used to be able to move only one vertex at a time.
• The Layout Type that you select in the graph pane is now saved in your options.
• The default dynamic filter opacity in the Options dialog box is now 0. (It was 0.5.) This will hide dynamically filtered vertices and edges.
• The default strength of the repulsive force between vertices in the Layout Options dialog box (accessible from the Options dialog box) is now 6.0. (It was 1.0.)
• Bug fix: The Create Subgraph Images feature was always using the Fruchterman Reingold layout instead of the Layout Type selected in the graph pane.
• Bug fix: Directed edges that ended on an image didn't have an arrowhead.
• Bug fix: The Merge Duplicate Edges feature raised an assertion if a worksheet other than the Edges worksheet was active.

1.0.1.68 (2009/1/2)

• There are new options for controlling how the Fruchterman-Reingold layout algorithm works. Click Options in the graph pane, then click the Layout button.
• Editing the settings in the Options dialog box no longer results in the graph being laid out again. The edited settings still get applied to the graph when you click OK, but the vertices don't move.

1.0.1.67 (2008/12/28)

• You can now control the opacity of dynamically-filtered vertices and edges. Click Options in the graph pane, then modify the Dynamic Filter Opacity setting.

1.0.1.66 (2008/12/17)

• Bug fix: If you used the Microsoft NodeXL, Excel Template shortcut on the Start menu, the shortcut would look for the NodeXL setup files and fail if they had been removed.
• Bug fix: A few remnants of our old product name were removed.

1.0.1.65 (2008/12/16)

• Bug fix: If you used the Vertex Shape option in AutoFill Columns to set the vertex shape to Solid Square, Solid Diamond, or Solid Triangle, you got an error when attempting to read the workbook into the graph.
• Bug fix: In AutoFill Columns, numbers you entered retained only one decimal place of precision.
• Bug fix: The dynamic filter for Clustering Coefficient didn't include any decimal places, so you could set the filter range only to 0 or 1. This was true for some other dynamic filters as well.
• Bug fix: All references to nodexl@microsoft.com, which was an email address that didn't exist, were replaced with links to the CodePlex discussion page.
• When you register, the NodeXL version and current time are now registered along with your email address.

1.0.1.64 (2008/12/13)

• The first version with our new name, NodeXL. We used to be called .NetMap.