<CellRangeList> error on trying to publish an excel workbook


G

Guest

I have a simple workbook that contains three cells being used for common
dropdown lists. The cells that reference this list are conditionally
formatted dependent on the cell value. When I try to save the workbook as a
webpage (Publish) I receive an error stating "Validation Load Error: For Type
List, absence of a <CellRangeList> tag implies relative cell references in
the list values which is not allowed.

Any ideas

Michael
 
Ad

Advertisements

Joined
Oct 24, 2006
Messages
1
Reaction score
0
when you have validation list tied to a cell, saving as xml wil add the following fragment:
============
<DataValidation xmlns="urn:schemas-microsoft-com:blush:ffice:excel">
<Range>R2C1:R5C1</Range>
<Type>List</Type>
<Value>R10C1:R32C1</Value>
</DataValidation>
=========
I found then if it loaded into MS Office spreadsheet component OWC11 an error happen.
replacing fragment with following helps(edit xml in notepad)
<DataValidation xmlns="urn:schemas-microsoft-com:blush:ffice:excel">
<Range>R2C1:R5C1</Range>
<Type>List</Type>
<CellRangeList/>
<Value>&quot;ITEM1,ITEM2,ITEM3&quot;</Value>
<ErrorMessage>out of range</ErrorMessage>
<ErrorTitle>Wrong Data</ErrorTitle>
</DataValidation>
 

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