Hey, I have VS 2003 at work and I tested it. It works so here is the
entire
HTML. It should work on your machine.
<%@ Page language="c#" Codebehind="WebForm1.aspx.cs"
AutoEventWireup="false"
Inherits="WebApplication10.WebForm1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm1</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema"
content="
http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<OBJECT style="Z-INDEX: 101; LEFT: 80px; POSITION: absolute; TOP: 24px"
classid="clsid:0002E559-0000-0000-C000-000000000046" VIEWASTEXT>
<PARAM NAME="DataType" VALUE="XMLDATA">
<PARAM NAME="XMLData" VALUE='<?xml version="1.0"?>
<ss:Workbook xmlns:x="urn:schemas-microsoft-com
ffice:excel"
xmlns:ss="urn:schemas-microsoft-com
ffice:spreadsheet"
xmlns:c="urn:schemas-microsoft-com
ffice:component:spreadsheet">
<x:ExcelWorkbook>
<x
rotectStructure>False</x
rotectStructure>
<x:ActiveSheet>0</x:ActiveSheet>
</x:ExcelWorkbook>
<ss:Styles>
<ss:Style ss:ID="Default">
<ss:Alignment ss:Horizontal="Automatic" ss:Rotate="0.0"
ss:Vertical="Bottom"
ss:ReadingOrder="Context"/>
<ss:Borders>
</ss:Borders>
<ss:Font ss:FontName="Arial" ss:Size="10" ss:Color="Automatic"
ss:Bold="0"
ss:Italic="0" ss:Underline="None"/>
<ss:Interior ss:Color="Automatic" ss
attern="None"/>
<ss:NumberFormat ss:Format="General"/>
<ss
rotection ss
rotected="1"/>
</ss:Style>
</ss:Styles>
<c:ComponentOptions>
<c:Label>
<c:Caption>Microsoft Office Spreadsheet</c:Caption>
</c:Label>
<c:MaxHeight>80%</c:MaxHeight>
<c:MaxWidth>80%</c:MaxWidth>
<c:NextSheetNumber>4</c:NextSheetNumber>
</c:ComponentOptions>
<x:WorkbookOptions>
<c:OWCVersion>11.0.0.8001 </c:OWCVersion>
<x:Height>7620</x:Height>
<x:Width>15240</x:Width>
</x:WorkbookOptions>
<ss:Worksheet ss:Name="Sheet1">
<x:WorksheetOptions>
<x:Selected/>
<x:ViewableRange>R1:R262144</x:ViewableRange>
<x:Selection>R1C1</x:Selection>
<x:TopRowVisible>0</x:TopRowVisible>
<x:LeftColumnVisible>0</x:LeftColumnVisible>
<x
rotectContents>False</x
rotectContents>
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
<ss:Table ss
efaultColumnWidth="48.0" ss
efaultRowHeight="12.6">
</ss:Table>
</ss:Worksheet>
<ss:Worksheet ss:Name="Sheet2">
<x:WorksheetOptions>
<x:ViewableRange>R1:R262144</x:ViewableRange>
<x:Selection>R1C1</x:Selection>
<x:TopRowVisible>0</x:TopRowVisible>
<x:LeftColumnVisible>0</x:LeftColumnVisible>
<x
rotectContents>False</x
rotectContents>
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
<ss:Table ss
efaultColumnWidth="48.0" ss
efaultRowHeight="12.6">
</ss:Table>
</ss:Worksheet>
<ss:Worksheet ss:Name="Sheet3">
<x:WorksheetOptions>
<x:ViewableRange>R1:R262144</x:ViewableRange>
<x:Selection>R1C1</x:Selection>
<x:TopRowVisible>0</x:TopRowVisible>
<x:LeftColumnVisible>0</x:LeftColumnVisible>
<x
rotectContents>False</x
rotectContents>
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
<ss:Table ss
efaultColumnWidth="48.0" ss
efaultRowHeight="12.6">
</ss:Table>
</ss:Worksheet>
</ss:Workbook>
'>
<PARAM NAME="AllowPropertyToolbox" VALUE="-1">
<PARAM NAME="AutoFit" VALUE="0">
<PARAM NAME="Calculation" VALUE="-4105">
<PARAM NAME="Caption" VALUE="Microsoft Office Spreadsheet">
<PARAM NAME="DisplayColumnHeadings" VALUE="-1">
<PARAM NAME="DisplayGridlines" VALUE="-1">
<PARAM NAME="DisplayHorizontalScrollBar" VALUE="-1">
<PARAM NAME="DisplayOfficeLogo" VALUE="-1">
<PARAM NAME="DisplayPropertyToolbox" VALUE="0">
<PARAM NAME="DisplayRowHeadings" VALUE="-1">
<PARAM NAME="DisplayTitleBar" VALUE="0">
<PARAM NAME="DisplayToolbar" VALUE="-1">
<PARAM NAME="DisplayVerticalScrollBar" VALUE="-1">
<PARAM NAME="DisplayWorkbookTabs" VALUE="-1">
<PARAM NAME="EnableEvents" VALUE="-1">
<PARAM NAME="MaxHeight" VALUE="80%">
<PARAM NAME="MaxWidth" VALUE="80%">
<PARAM NAME="MoveAfterReturn" VALUE="-1">
<PARAM NAME="MoveAfterReturnDirection" VALUE="-4121">
<PARAM NAME="RightToLeft" VALUE="0">
<PARAM NAME="ScreenUpdating" VALUE="-1">
<PARAM NAME="LockedDown" VALUE="0">
<PARAM NAME="ConnectedToChart" VALUE="0">
<PARAM NAME="DefaultQueryOnLoad" VALUE="-1">
<PARAM NAME="EnableUndo" VALUE="-1">
</OBJECT>
</form>
</body>
</HTML>
Alvin Bruney said:
I simply don't know. I don't have VS 2003 anymore so I can't help
further. I
know the components work in design-mode with that version. You may try
opening a windows form and dragging the object there. If it doesn't
render,
you have an issue with Visual Studio
--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
OWC Black Book 2nd Edition coming soon.
message
I tried opening a page containing the owc11 spreadsheet in the vs2003
IDE
but
failed to perform any operations like editing the spreadsheet in the
design
mode. Following is the code which I tried with:
<HTML>
<HEAD>
</HEAD>
<form id="PriceChartDetail" name="PriceChartDetail">
<BODY>
<H3>SPREAD SHEET TEST</H3>
<TABLE>
<tr>
<span>
<td id="tHideData" name="tHideData">
<a href="javascript:test()">
<span id="tHideData1" name="tHideData1" class="TitlebarAnchor">|Show
Data</span></a>
</td>
</span>
</tr>
<tr>
<%'0002E500-0000-0000-C000-000000000046%>
<td>
<OBJECT id="ChartSpace1" style="FONT-SIZE: 8pt; LEFT: 0px; WIDTH:
700px; FONT-FAMILY: verdana; POSITION: relative; TOP: 0px; HEIGHT:
400px"
classid="clsid:0002E55D-0000-0000-C000-000000000046" VIEWASTEXT>
<PARAM NAME="XMLData" VALUE='<xml
xmlns:x="urn:schemas-microsoft-com
ffice:excel">
<x:WebChart>
<x:OWCVersion>9.0.0.6430</x:OWCVersion>
<x:Width>18521</x:Width>
<x:Height>10583</x:Height>
</x:WebChart>
</xml>'>
<PARAM NAME="ScreenUpdating" VALUE="-1">
</OBJECT>
</td>
</tr>
<TR>
<TD>
</TD>
</TR>
<TR>
<TD>
<OBJECT class="objHide" id="Spreadsheet2" style="FONT-SIZE: 8pt;
LEFT:
0px; WIDTH: 900px; FONT-FAMILY: verdana; POSITION: relative; TOP:
0px;
HEIGHT: 400px"
width="900" classid="clsid:0002E510-0000-0000-C000-000000000046"
VIEWASTEXT>
<PARAM NAME="HTMLURL" VALUE="">
<PARAM NAME="HTMLData" VALUE="<html
xmlns:x="urn:schemas-microsoft-com
ffice:excel"
xmlns="
http://www.w3.org/TR/REC-html40">
<head>
<style type="text/css">
<!--tr
{mso-height-source:auto;}
td
{white-space:nowrap;}
.wc8A88BF1
{white-space:nowrap;
font-family:Arial;
mso-number-format:General;
font-size:auto;
font-weight:auto;
font-style:auto;
text-decoration:auto;
mso-background-source:auto;
mso-pattern:auto;
mso-color-source:auto;
text-align:general;
vertical-align:bottom;
border-top:none;
border-left:none;
border-right:none;
border-bottom:none;
mso-protection:locked;}
-->
</style>
</head>
<body>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:OWCVersion>9.0.0.6430</x:OWCVersion>
<x:Label Style='border-top:solid .5pt silver;border-left:solid
.5pt
silver;
border-right:solid .5pt silver;border-bottom:solid .5pt silver'>
<x:Caption>Microsoft Office Spreadsheet</x:Caption>
</x:Label>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
<x:Selected/>
<x:Height>10583</x:Height>
<x:Width>23813</x:Width>
<x:TopRowVisible>0</x:TopRowVisible>
<x:LeftColumnVisible>0</x:LeftColumnVisible>
<x
rotectContents>False</x
rotectContents>
<x
efaultRowHeight>255</x
efaultRowHeight>
<x:StandardWidth>2340</x:StandardWidth>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:MaxHeight>80%</x:MaxHeight>
<x:MaxWidth>80%</x:MaxWidth>
</x:ExcelWorkbook>
</xml><![endif]-->
<table class=wc8A88BF1 x:str>
<col class=wc8A88BF1 width="64">
<tr height="17">
<td class=wc8A88BF1></td>
</tr>
</table>
</body>
</html>
">
<PARAM NAME="DataType" VALUE="HTMLDATA">
<PARAM NAME="AutoFit" VALUE="0">
<PARAM NAME="DisplayColHeaders" VALUE="-1">
<PARAM NAME="DisplayGridlines" VALUE="-1">
<PARAM NAME="DisplayHorizontalScrollBar" VALUE="-1">
<PARAM NAME="DisplayRowHeaders" VALUE="-1">
<PARAM NAME="DisplayTitleBar" VALUE="-1">
<PARAM NAME="DisplayToolbar" VALUE="-1">
<PARAM NAME="DisplayVerticalScrollBar" VALUE="-1">
<PARAM NAME="EnableAutoCalculate" VALUE="-1">
<PARAM NAME="EnableEvents" VALUE="-1">
<PARAM NAME="MoveAfterReturn" VALUE="-1">
<PARAM NAME="MoveAfterReturnDirection" VALUE="0">
<PARAM NAME="RightToLeft" VALUE="0">
<PARAM NAME="ViewableRange" VALUE="1:65536">
</OBJECT>
</TD>
</TR>
</TABLE>
<input type="button" class="btnClass" name="btnData" value="View
Data">
<input type="checkbox" name="checkbox1" value="1">
</BODY>
</form>
</HTML>
I can edit the spreadsheet succuessfully in Interdev but not in VS
2003.
May
be I am missing some of the settings or I need the latest patch.
The version of the VS 2003 IDE I am using is : Microsoft Development
Environment 2003 Version 7.1.3088.
Can you please let me know what I am missing?