Hi all,
I have a problem with Excel 2007: it crashes when importing certain xml
data, exported from another software
This is the smallest file which reproduces the problem:
<?xml version="1.0" standalone="yes "?>
<ds_S3 xmlns="http://tempuri.org/ds_S3.xsd">
<tblTags>
<StartDateAndTi me>2000-01-01T00:00:00+01: 00</StartDateAndTim e>
</tblTags>
</ds_S3>
The problem is caused by the StartDateAndTim e value: importing this file
works:
<?xml version="1.0" standalone="yes "?>
<ds_S3 xmlns="http://tempuri.org/ds_S3.xsd">
<tblTags>
<StartDateAndTi me>this works...</StartDateAndTim e>
</tblTags>
</ds_S3>
I don't expect Excel to interpret the date - just to show it as a string!
Anyone confirm or deny this? any solutions?
Info:
OS: Vista Business SP1, English
Excel 2007 SP1, English
Regional settings: Italian (tried US but no difference)
Thanks,
James
I have a problem with Excel 2007: it crashes when importing certain xml
data, exported from another software
This is the smallest file which reproduces the problem:
<?xml version="1.0" standalone="yes "?>
<ds_S3 xmlns="http://tempuri.org/ds_S3.xsd">
<tblTags>
<StartDateAndTi me>2000-01-01T00:00:00+01: 00</StartDateAndTim e>
</tblTags>
</ds_S3>
The problem is caused by the StartDateAndTim e value: importing this file
works:
<?xml version="1.0" standalone="yes "?>
<ds_S3 xmlns="http://tempuri.org/ds_S3.xsd">
<tblTags>
<StartDateAndTi me>this works...</StartDateAndTim e>
</tblTags>
</ds_S3>
I don't expect Excel to interpret the date - just to show it as a string!
Anyone confirm or deny this? any solutions?
Info:
OS: Vista Business SP1, English
Excel 2007 SP1, English
Regional settings: Italian (tried US but no difference)
Thanks,
James