Editing OWC spreadsheets in Visual Studio .NET

A

Amol Rajimwale

HI,

I would like to know whether it is possible to edit the owc spreadsheet
object in Visual Studio .net the way we do in visual interdev within a web
page(asp or aspx).

I can easily perform operations on the spreadsheet embedded in a page when
opened in Visual interdev(like adding and deleting rows & columns,
resizing,formatting etc ) in the design mode.

However the same is not possible when the same page is opened in Visual
Studio.net IDE. I have to go to the HTML view and perform all the actions
manually.

Can anyone tell how it will be done in VS.NET.

Thanks,
 
A

Alvin Bruney [MVP]

That functionality is disabled in VS 2005.NET. I don't know of a work-around
for it.
 
A

Alvin Bruney [MVP]

Yup it works in VS 2003. What i would suggest is do it in 2003, then copy
the object over to 2005 when you have it properly customized.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
OWC Black Book 2nd Edition coming soon.

Amol Rajimwale said:
Thanks for the reply.

Is it possible in VS.NET 2003?
--
Amol Rajimwale
Tata Consultancy Services,Kolkata
mail:[email protected]
 
A

Amol Rajimwale

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:eek: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:eek: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:protectContents>False</x:protectContents>
<x:DefaultRowHeight>255</x:DefaultRowHeight>
<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?
--
Amol Rajimwale
Tata Consultancy Services,Kolkata
mail:[email protected]
 
A

Alvin Bruney [MVP]

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.


Amol Rajimwale said:
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:eek: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:eek: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:protectContents>False</x:protectContents>
<x:DefaultRowHeight>255</x:DefaultRowHeight>
<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?
--
Amol Rajimwale
Tata Consultancy Services,Kolkata
mail:[email protected]


Alvin Bruney said:
Yup it works in VS 2003. What i would suggest is do it in 2003, then copy
the object over to 2005 when you have it properly customized.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
OWC Black Book 2nd Edition coming soon.

message
 
V

vapor

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:eek:ffice:excel"
xmlns:ss="urn:schemas-microsoft-com:eek:ffice:spreadsheet"
xmlns:c="urn:schemas-microsoft-com:eek:ffice:component:spreadsheet">
<x:ExcelWorkbook>
<x:protectStructure>False</x:protectStructure>
<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:pattern="None"/>
<ss:NumberFormat ss:Format="General"/>
<ss:protection ss:protected="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:protectContents>False</x:protectContents>
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
<ss:Table ss:DefaultColumnWidth="48.0" ss:DefaultRowHeight="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:protectContents>False</x:protectContents>
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
<ss:Table ss:DefaultColumnWidth="48.0" ss:DefaultRowHeight="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:protectContents>False</x:protectContents>
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
<ss:Table ss:DefaultColumnWidth="48.0" ss:DefaultRowHeight="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.


Amol Rajimwale said:
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:eek: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:eek: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:protectContents>False</x:protectContents>
<x:DefaultRowHeight>255</x:DefaultRowHeight>
<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?
--
Amol Rajimwale
Tata Consultancy Services,Kolkata
mail:[email protected]


Alvin Bruney said:
Yup it works in VS 2003. What i would suggest is do it in 2003, then copy
the object over to 2005 when you have it properly customized.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
OWC Black Book 2nd Edition coming soon.

message
Thanks for the reply.

Is it possible in VS.NET 2003?
--
Amol Rajimwale
Tata Consultancy Services,Kolkata
mail:[email protected]


:

That functionality is disabled in VS 2005.NET. I don't know of a
work-around
for it.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
OWC Black Book 2nd Edition coming soon.


message
HI,

I would like to know whether it is possible to edit the owc
spreadsheet
object in Visual Studio .net the way we do in visual interdev within
a
web
page(asp or aspx).

I can easily perform operations on the spreadsheet embedded in a
page
when
opened in Visual interdev(like adding and deleting rows & columns,
resizing,formatting etc ) in the design mode.

However the same is not possible when the same page is opened in
Visual
Studio.net IDE. I have to go to the HTML view and perform all the
actions
manually.

Can anyone tell how it will be done in VS.NET.

Thanks,
 
A

Amol Rajimwale

Hi ,

Thanks for the reply.

I copied your code & pasted to my page. It really works. However, the code
supports OWC9(clsid:0002E559-0000-0000-C000-000000000046). But when I tried
the same with OWC11(clsid:0002E510-0000-0000-C000-000000000046), its not
working.

Can you please check & verify.
--
Amol Rajimwale
Tata Consultancy Services,Kolkata
mail:[email protected]


vapor said:
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:eek:ffice:excel"
xmlns:ss="urn:schemas-microsoft-com:eek:ffice:spreadsheet"
xmlns:c="urn:schemas-microsoft-com:eek:ffice:component:spreadsheet">
<x:ExcelWorkbook>
<x:protectStructure>False</x:protectStructure>
<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:pattern="None"/>
<ss:NumberFormat ss:Format="General"/>
<ss:protection ss:protected="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:protectContents>False</x:protectContents>
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
<ss:Table ss:DefaultColumnWidth="48.0" ss:DefaultRowHeight="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:protectContents>False</x:protectContents>
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
<ss:Table ss:DefaultColumnWidth="48.0" ss:DefaultRowHeight="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:protectContents>False</x:protectContents>
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
<ss:Table ss:DefaultColumnWidth="48.0" ss:DefaultRowHeight="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.


Amol Rajimwale said:
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:eek: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:eek: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:protectContents>False</x:protectContents>
<x:DefaultRowHeight>255</x:DefaultRowHeight>
<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?
 
A

Alvin Bruney [MVP]

Ok, here is the problem. These is a licensing issue. Licensing checks have
been disabled in VS 2005 .NET. This means that the OWC component will always
render in interactive mode. End of story.

In prior versions of Visual Studio .NET, licensing checks are enabled. This
means that, depending on your configuration, the components may render in
read-only mode (your problem) or full interactive mode. Here is the rub. As
far as I am aware, licensing checks are only done in Visual Studio .NET.
Products like InterDev do not have licensing checks which explains why you
are able to interact with the spreadsheet in InterDev and not in Visual
Studio .NET.

You can't work around the licensing problem in Visual Studio .NET 2003.
Basically, you will need an installed version of Office 2003 for OWC 11 and
Office XP for OWC 10 and Office 2000 for OWC 9 respectively. The components
are not dependent on a version of Office for functionality. However, license
checks are entirely dependent on the Office version.

In the case where you have Office 2003 on your system and Visual Studio 2003
..NET and the components are rendering in read-only mode, then you have a
serious problem.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
OWC Black Book 2nd Edition coming soon.


Amol Rajimwale said:
Hi ,

Thanks for the reply.

I copied your code & pasted to my page. It really works. However, the code
supports OWC9(clsid:0002E559-0000-0000-C000-000000000046). But when I
tried
the same with OWC11(clsid:0002E510-0000-0000-C000-000000000046), its not
working.

Can you please check & verify.
--
Amol Rajimwale
Tata Consultancy Services,Kolkata
mail:[email protected]


vapor said:
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:eek:ffice:excel"
xmlns:ss="urn:schemas-microsoft-com:eek:ffice:spreadsheet"
xmlns:c="urn:schemas-microsoft-com:eek:ffice:component:spreadsheet">
<x:ExcelWorkbook>
<x:protectStructure>False</x:protectStructure>
<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:pattern="None"/>
<ss:NumberFormat ss:Format="General"/>
<ss:protection ss:protected="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:protectContents>False</x:protectContents>
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
<ss:Table ss:DefaultColumnWidth="48.0" ss:DefaultRowHeight="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:protectContents>False</x:protectContents>
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
<ss:Table ss:DefaultColumnWidth="48.0" ss:DefaultRowHeight="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:protectContents>False</x:protectContents>
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
<ss:Table ss:DefaultColumnWidth="48.0" ss:DefaultRowHeight="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:eek: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:eek: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:protectContents>False</x:protectContents>
<x:DefaultRowHeight>255</x:DefaultRowHeight>
<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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top