OWC11 Spreadsheet - named range

[Sandy]

Hi,


We have a requirement in our project to replace OWC Version #10 to Version #
11 in .NET 1.1 web application. We use an excel template to display on IE
using OWC.User is allowed to interact with the OWC excel component. The
template uses named ranges for List type. The template is converted to XML
spredsheet and Asp.NET application loads it to OWC. We could able to browse
the spredsheet component and interact in OWC version 10. We have installed
OWC 11 version and replaced the application with OWC ver 11 classID. But
while browsing the excel template in IE we get the following error:

The error message is "Validation Load Error: For Type List, the absence of a
<CellRangeList> tag implies relative cell references in the list values which
is not allowed".

We have Microsoft office 2003 Licensed version installed.

 

[Alvin Bruney [MVP]]

I've never seen this error before but it appears to me that your XML is no
longer valid. Dump the XML and remove the offending tags, see if that works.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley

 

[Sandy]

Hi,

The xML which is used for OWC 11 version is working fine with OWC10
version.As per your advice i tried removing the offending tags i,e removing
the Data validation control from type "List " to "Anyvalue" and its working
fine. Please suggest why this happens with OWC 11 version and not with OWC10
version.

Following are the steps which simulates the error using a sample excel file:

1)In the 2nd worksheet after including 5 items, i defined the name as Insert
-> Name -> Define and named it as "Namelist".

2) In the 1st worksheet for the 1st cell assign, data validation as list and
the source as "Namelist"( created in step 1.)

3) Saved the excelsheet as xyz.htm, by selecting "add interactivity"
checkbox and when i tried to publish the webpage following error is thrown

The error message is "Validation Load Error: For Type List, the absence of a
<CellRangeList> tag implies relative cell references in the list values which
is not allowed".

4) The same sheet works with out throwing above error, if data validation is
changed from list to "Any value" in Step 2.

We cannot use "Any Value" for our application to work. So, Please suggest if
we can fix the problem using the data validation type as "List".

Thanks in advance.
Sandy