1. We looked at allowing the editing of the rich-text ‘Notes’ fields in Excel, but have decided not to in the current release. The HTML which is stored in EA for this attribute is not well-formed, so needs lots of processing to make readable, and Excel does seem to be a good way of editing textual data which is this complicated.
We may change our minds one day, but I doubt it…
2. Interesting. We have debated this internally many times. ‘What would we expect?’
We did think about doing things the way you suggested, but found that we were constantly creating tagged values in elements where we didn’t mean to – it’s quite easy here I want to create one or two TVs, but end up creating lots and lots, each with no value. So, in the end, we decided that if the cell was empty, not to create the TV.
If you feel really strongly about this, we might make it a configurable option, but it’s something which users seem to have got used to : if you want to create the TV for all elements, just print “none” or “n/a” in the cell, and the TV will get created.
