Export (0) Print
Expand All
Expand Minimize

2.1.619 Part 4 Section 3.2.28, workbookPr (Workbook Properties)

a. The standard states that allowRefreshQuery is a valid attribute on this element.

Excel does not support this attribute on this element.

b. The standard does not specify a default value for the defaultThemeVersion attribute.

Excel uses a default value of 0, which indicates that no default theme applies in the workbook, for this attribute.

c. The standard states that on and off are valid values of the autoCompressPic attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

d. The standard states that on and off are valid values of the backupFile attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

e. The standard states that on and off are valid values of the checkCompatibility attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

f. The standard states that on and off are valid values of the date1904 attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

g. The standard states that on and off are valid values of the filterPrivacy attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

h. The standard states that on and off are valid values of the hidePivotFieldList attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

i. The standard states that on and off are valid values of the promptedSolutions attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

j. The standard states that on and off are valid values of the publishItems attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

k. The standard states that on and off are valid values of the saveExternalLinkValues attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

l. The standard states that on and off are valid values of the showBorderUnselectedTables attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

m. The standard states that on and off are valid values of the showInkAnnotation attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

n. The standard states that on and off are valid values of the showPivotChartFilter attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

o. The standard describes the codeName attribute as specifying the codename of the application that created the workbook.

Office uses the codeName attribute to specify the name of the Workbook object as to be used in a scripting application.

p. The standard states that the values of the codeName attribute are defined by the XML Schema string datatype.

Excel requires this attribute to be at most 31 characters, with the following pattern restriction: [\p{L}\P{IsBasicLatin}][_\d\p{L}\P{IsBasicLatin}]*.

q. The standard specifies a value of 1 or true for @hidePivotFieldList indicates the field list is shown.

Office treats that a value of 1 or true to indicate the field list is hidden, and a value of 0 or false otherwise.

r. The standard does not specify the meaning of possible values for the attribute refreshAllConnections.

Office treats a value of 1 or true for @refreshAllConnections to indicate all connections shall be refreshed, and 0 or false otherwise.

s. The standard implies that the implementing application should draw a border around unselected tables if @showBorderUnselectedTables is set to true.

Office does not draw the border around tables regardless of the value of showBorderUnselectedTables.

t. The standard states that the promptedSolutions attribute determines whether the user received or did not receive an alert.

In Office, this attribute indicates whether an alert is requested before loading Smart Document components. A value of 1 or true indicates the user has chosen not to receive an alert. A value of 0 or false indicates the user will receive an alert.

u. The standard states that the filterPrivacy attribute is used to warn the user when PII is added to a document.

In Office, the filterPrivacy attribute is used to determine if PII is removed or not removed from the workbook when it is saved.

Show:
© 2014 Microsoft