T
Tony Gravagno
I have XSD files with enumerations to constrain the value of specific
elements. I want to use Excel to enter data using the XSD. When I
apply the XSD as an XML Map I can assign a cell to each element and
create a List which will get exported as an XML document. All good so
far. For the cells that are constrained, if I don't enter a proper
enumerated value into a cell, when I export I get a message like this:
'element' violates enumeration constraint of 'a b c d e'. The element
{URIpath}Name with value 'foo' failed to parse.
If I ensure that I enter correct case-sensitive values, the List saves
as XML without warning, so I know the constraints are properly applied
to the cells. Again, all good so far.
But rather than manually entering the enum values, I'd like to be able
to choose from a drop-down list. The right-click context menu for
cells includes a "Pick From Drop-down List" option, and I thought the
schema would provide that list, but it doesn't. It only offers a
selection of values previously entered.
So the question is - how do I get Excel to limit cell entry to the
proper Type specified in a schema, whether String, Boolean, or an Enum
with multiple possible values?
Since we're here, the exact same concept and error applies to Word.
Thanks!
elements. I want to use Excel to enter data using the XSD. When I
apply the XSD as an XML Map I can assign a cell to each element and
create a List which will get exported as an XML document. All good so
far. For the cells that are constrained, if I don't enter a proper
enumerated value into a cell, when I export I get a message like this:
'element' violates enumeration constraint of 'a b c d e'. The element
{URIpath}Name with value 'foo' failed to parse.
If I ensure that I enter correct case-sensitive values, the List saves
as XML without warning, so I know the constraints are properly applied
to the cells. Again, all good so far.
But rather than manually entering the enum values, I'd like to be able
to choose from a drop-down list. The right-click context menu for
cells includes a "Pick From Drop-down List" option, and I thought the
schema would provide that list, but it doesn't. It only offers a
selection of values previously entered.
So the question is - how do I get Excel to limit cell entry to the
proper Type specified in a schema, whether String, Boolean, or an Enum
with multiple possible values?
Since we're here, the exact same concept and error applies to Word.
Thanks!