Change in HTML Field Behavior in the 2010 TFS Excel Integration


TFS has changed how Excel interacts with HTML fields to only allow HTML fields to be editable on creation of a work item but read only when editing existing work items.

What was the old behavior?

With the 2008 TFS Excel Add-In you were able to edit work item HTML fields in Excel, but all of the formatting tags were stripped out, publishing any changes as plain text.

Why was it changed?

This behavior prevented teams from using the full power of the HTML fields because they were concerns about data loss. In addition to formatting being lost, html links and other tags were stripped out as well.

What out of the box work items use HTML fields?

There are many work item fields that use HTML fields, for example: Repro Steps, Test Steps, System Info, etc. Beyond this set the fields are used to provide refinement information like in a Change Request such as Impact to Arch, Impact to Test, etc. Several customers have proposed we change the Description field type for the Task work item type from ‘PlainText’ to ’HTML’ in a future TFS release.


Comments (2)

  1. Hussar says:

    And how can I do bulk copy of the HTML field now? I need to update my v4 WIT to v5 and need to move data from "Steps to reporduce" to "Repro Steps" for exsisting bugs?

  2. Simon Jones says:

    See this article for a description of how to add an HTML Comments field to the Task item and copy all data from Comments to HTMLComments. You may be able to adapt this to Bugs.

    msmvps.com/…/using-rich-html-descriptions-instead-of-plain-text.aspx