P
patrickjcollins
Greetings
I created a spreadsheet within Microsoft Excel 2003, which I then saved
as an XML file. I attempted to open that file through the Office Web
Component Spreadsheet object by setting the XMLURL property and the
component crashed with the following error:
System.Runtime.InteropServices.COMException (0x80004005): Unspecified
Error
I discovered that if the original spreadsheet had cell validation using
a list of possible values, then the error would occur. If I manually
removed any <DataValidation> tags with a <Type> of "List" then the OWC
component could read the file without error.
<DataValidation xmlns="urn:schemas-microsoft-com
ffice:excel">
<Range>R2C3</Range>
<Type>List</Type>
<Value>R2C2:R3C2</Value>
</DataValidation>
Has anyone else noticed this problem? Is it an OWC bug?
Regards
Patrick Collins
Paris
I created a spreadsheet within Microsoft Excel 2003, which I then saved
as an XML file. I attempted to open that file through the Office Web
Component Spreadsheet object by setting the XMLURL property and the
component crashed with the following error:
System.Runtime.InteropServices.COMException (0x80004005): Unspecified
Error
I discovered that if the original spreadsheet had cell validation using
a list of possible values, then the error would occur. If I manually
removed any <DataValidation> tags with a <Type> of "List" then the OWC
component could read the file without error.
<DataValidation xmlns="urn:schemas-microsoft-com
ffice:excel"><Range>R2C3</Range>
<Type>List</Type>
<Value>R2C2:R3C2</Value>
</DataValidation>
Has anyone else noticed this problem? Is it an OWC bug?
Regards
Patrick Collins
Paris