And one more thing ... the behavior seems to still be dependent on whether your database column's datatype is char or varchar. If you use varchar and your column is truly empty (no extra spaces), you won't see the xml:space="preserve" get added to the XML. But if your column is char, then it's never really empty ... it's always padded with spaces no matter what you do and so you'll get the stuff added to the XML. This is how it works in SQL Server anyway, I'm not sure if it's different or not for other databases.
~~Bonnie
>>On further experimentation, it seems this is something extra that's been added to 2.0 when you use a DataAdapter.Fill(). I don't know how to turn it off. Further experimentation may be necessary. I don't know if this is a good thing or not (I hate things that aren't backwards compatible).
>
>Well, personally, I don't think this is a good idea. Basically, if you don't trim, you end up with extra fields in the spreadsheet and this just doesn't make any sense to me.
>
>So, I'll keep those trim in there until a fix is done.
>
>Thanks for having done some research on the topic. At least, we know this is something to 2.0.