S
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
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