2.1.836 Part 1 Section 18.13.12, textPr (Text Import Settings)

  • Article

a.   The standard places no restrictions on the relationship between the delimited attribute and the comma, delimiter, semicolon, space, and tab attributes.

Excel will ignore the comma, delimiter, semicolon, space, and tab attributes when the value of the delimited attribute is false.

b.   The standard states that the values of the firstRow attribute are defined by the XML Schema unsignedInt datatype.

Excel restricts the value of this attribute to be at most 2147483647.

c.   The standard states that string values of the decimal attribute are expected to be one character in length.

Office expects string values of the decimal attribute to be one character with an ANSI value up to 255.

d.   The standard states that strings values of the thousands attribute are expected to be one character in length.

Office expects string values of the thousands attribute to be one character with an ANSI value up to 255.

e.   The standard states that the minOccurs value for the textFields child element is 0.

Excel requires an occurrence of this element.

f.   The standard does not limit the length of the value of the sourceFile attribute.

Excel restricts the value of this attribute to be at least 1 and at most 218 characters.

g.   The standard places no restrictions on the relationship between the prompt attribute and the sourceFile attribute.

Excel requires the sourceFile attribute when the value of the prompt attribute is false.

h.   The standard states that when both system and text file decimal separator is set to "," and thousands separator to period, 123,123.45 is imported as 123,123.45 (numeric).

Office imports the value as text in this case.

i.   The standard states that the default value of the sourceFile attribute is the empty string.

Excel does not use a default value for this attribute.

j.   The standard states that characterSet is a valid attribute, and that when it is present, codePage should be ignored.

Office ignores the characterSet attribute if it is present, and does not ignore the codePage attribute if characterSet is present.

This note applies to the following products: Office 2010, Office 2010 Server, Office 2010 SP1.