There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Strings with single quotes
The shared string implementation does not properly escape singel quotes (and other special characters in xml) in the xpath that it uses to search, so if you try to set a cell's value to "Dave's Project", it fails.
I'm attaching one possible solution to this, though it may not be the best.