[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format

Yüklə 3,69 Mb.

səhifə	175/180
tarix	09.01.2022
ölçüsü	3,69 Mb.
	#95757

1 ... 172 173 174 175 176 177 178 179 180

4 Security Considerations
5 Appendix A: Full XML Schema

Attribute name	Value
Notes
name	Slicer_State	This is the name of the slicer cache.
sourceName	State	This is the name of the associated slicer, as specified in section 2.1.5.

The following table describes the pivotTable element used in this example.

Attribute name	Value	Notes
tabId	1	This indicates that the associated PivotTable, as specified in [ISO/IEC29500-1:2011] section 18.10, is located on the first sheet (1).
name	PivotTable1	This is the name of the associated PivotTable.

The following table describes the tabular element used in this example.

Attribute name	Value	Notes
pivotCacheId	5	This indicates that the identifier of the associated PivotTable PivotCache is "5".

The following table describes the items element used in this example.

Attribute name	Value	Notes
count	2	This indicates that there are two items in the slicer cache.

The following table describes the first i (item) element used in this example.

Attribute name	Value	Notes
x	1	This indicates that the first item in the slicer cache is the second item in the PivotTable PivotCache.

The following table describes the second i (item) element used in this example.

Attribute name	Value	Notes
x	0	This indicates that the second item in the slicer cache is the first item in the PivotTable PivotCache.
s	1	This indicates that this item is selected in the slicer.

3.1.2 Slicer Part

The following is an example slicer part, as specified in section 2.1.5.

The following table describes the slicer element used in this example.

Attribute name	Value	Notes
name	State	This is the name of the slicer.
cache	Slicer_State	This is the name of the slicer cache, as specified in section 2.1.4.
caption	State	This is the caption displayed at the top of the slicer.
rowHeight	228600	This is the height of a row (2) in EMUs, equal to one-fourth of an inch.

4 Security Considerations

4.1 Security Considerations for Implementers

The password verifier features available in the file format are used to prevent accidental modification, rather than being used as security features. It is possible to remove the passwords by removing the records containing the verifier values.

The translation of passwords from a double-byte Unicode string to a new character string in the ANSI code page of the current system converts any Unicode character that cannot be mapped to the ANSI code page of the current system to the 0x3F character in that code page, as described in [ISO/IEC29500-1:2011] section 18.2.29. Replacing these characters with "0x3F" when the hash is verified will generate positive hash value matches. In certain locales, this can be a significant portion of the everyday character set (1).

Further security considerations regarding the file encryption algorithms are described in [MS-OFFCRYPTO] section 4.1.3.

4.2 Index of Security Fields

None.

5 Appendix A: Full XML Schema

For ease of implementation, this section provides the full W3C XML schemas for the new elements, attributes, complex types, and simple types specified in the earlier sections. Any schema references to namespaces included in Office Open XML file formats as described in [ISO/IEC29500:2011] refer specifically to the transitional schemas as described in [ISO/IEC29500-4:2011].

For ease of implementation, the following sections provide the full XML schema for this protocol.

Schema name	Prefix	Section
schemas.microsoft.com/office/excel/2006/main		section 5.1
schemas.microsoft.com/office/drawing/2010/slicer		section 5.2
schemas.microsoft.com/office/spreadsheetml/2010/11/main		section 5.3
schemas.microsoft.com/office/spreadsheetml/2009/9/main		section 5.4
schemas.microsoft.com/office/spreadsheetml/2009/9/ac		section 5.5
xl12AcSchemaUri		section 5.6
schemas.microsoft.com/office/drawing/2012/timeslicer		section 5.7

5.1 http://schemas.microsoft.com/office/excel/2006/main Schema

5.2 http://schemas.microsoft.com/office/drawing/2010/slicer Schema

5.3 http://schemas.microsoft.com/office/spreadsheetml/2010/11/main Schema

5.4 http://schemas.microsoft.com/office/spreadsheetml/2009/9/main Schema

5.5 http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac Schema

5.6 http://schemas.microsoft.com/office/spreadsheetml/2011/1/ac Schema

5.7 http://schemas.microsoft.com/office/drawing/2012/timeslicer Schema

5.8 http://schemas.microsoft.com/office/excel/2010/spreadsheetDrawing Schema

5.9 http://schemas.microsoft.com/office/spreadsheetml/2010/11/ac Schema

5.10 http://schemas.openxmlformats.org/spreadsheetml/2006/main Schema

Yüklə 3,69 Mb.

Dostları ilə paylaş: