Add HTML field editing to Excel for Work Items
When viewing/editing TFS work items in Excel, fields that are HTML type fields are read-only for existing work items. See the following blog: http://blogs.msdn.com/b/team_foundation/archive/2010/05/26/change-in-html-field-behavior-in-the-2010-tfs-excel-integration.aspx
Please modify TFS or Excel to allow cells to contain and allow editing of this HTML data in the next Visual Studio release.
We don’t want to allow the user to modify the actual HTML in Excel. We have considered this scenario, but we think that the validity of the data is more important than the bulk update scenario.
Program Manager, Team Foundation Server
Tony Danza commented
This is insane logic. This effectively blocks my ability to bulk upload requirements into TFS, since many are multi-line.
Peter Johnson commented
Please consult with the community about this one. I think the data is invalid if you strip the most basic formatting from the text being edited.
Can you at least maintain line feeds (New Lines, Carriage Returns) in the formatting?
Ideally it would minimally support Bold, Italic, Underline, Line Feeds.
The behavior is very inconsistent, on first bulk loading of the data line feeds are maintained but on subsequent edits it strips all of the line feeds out.