ISO/IEC 29500-4:2011/PRF Amd 1

INTERNATIONAL ISO/IEC
STANDARD 29500-4
Second edition
2011-08-15
AMENDMENT 1
2012-##-##
Information technology — Document
description and processing languages —
Office Open XML File Formats —
Part 4:
Transitional Migration Features
AMENDMENT 1
Technologies de l'information — Description des documents et
langages de traitement — Formats de fichier “Office Open XML” —
Partie 4: Caractéristiques de migration transitoire
AMENDEMENT 1
PROOF/ÉPREUVE
Reference number
ISO/IEC 29500-4:2011/Amd.1:2012(E)
©
ISO/IEC 2012
ISO/IEC 29500-4:2011/Amd.1:2012(E)

©  ISO/IEC 2012
All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized in any form or by any means,
electronic or mechanical, including photocopying and microfilm, without permission in writing from either ISO at the address below or
ISO's member body in the country of the requester.
ISO copyright office
Case postale 56  CH-1211 Geneva 20
Tel. + 41 22 749 01 11
Fax + 41 22 749 09 47
E-mail copyright@iso.org
Web www.iso.org
Published in Switzerland
ii PROOF/ÉPREUVE © ISO/IEC 2012 – All rights reserved

ISO/IEC 29500-4:2011/Amd.1:2012
Contents
Foreword . v
Introduction . vi
Notational conventions . vii
1. §15.2.4, “Modified content for Date Conversion for Serial Date-Times (Part 1, §18.17.4.1)”, new subclause . 1
2. §15.7.3, “Removed enumeration values for ST_CellType (Part 1, §18.18.11)”, new subclause . 2
3. §A.2, “SpreadsheetML”, p. 1018, Lines 2326–2336 . 2
4. §A.2, “SpreadsheetML”, p. 1055, lines 4275–4298 . 2
5. §B.2, “SpreadsheetML”, p. 1359, Lines 2506–2509 . 2
6. §B.2, “SpreadsheetML”, pp. 1395–1396, lines 4436–4442 . 2
7. §D.2, “SpreadsheetML”, p. 1565 . 3

Copyright © ISO/IEC 2012 – All rights reserved  iii
PROOF/ÉPREUVE
ISO/IEC 29500-4:2011/Amd.1:2012
Foreword
ISO (the International Organization for Standardization) and IEC (the International Electrotechnical Commission)
form the specialized system for worldwide standardization. National bodies that are members of ISO or IEC
participate in the development of International Standards through technical committees established by the
respective organization to deal with particular fields of technical activity. ISO and IEC technical committees
collaborate in fields of mutual interest. Other international organizations, governmental and non-governmental,
in liaison with ISO and IEC, also take part in the work. In the field of information technology, ISO and IEC have
established a joint technical committee, ISO/IEC JTC 1.
International Standards are drafted in accordance with the rules given in the ISO/IEC Directives, Part 2.
The main task of the joint technical committee is to prepare International Standards. Draft International
Standards adopted by the joint technical committee are circulated to national bodies for voting. Publication as
an International Standard requires approval by at least 75% of the national bodies casting a vote.
Attention is drawn to the possibility that some of the elements of this document may be the subject of patent
rights. ISO and IEC shall not be held responsible for identifying any or all such patent rights.
Amendment 1 to ISO/IEC 29500-4 was prepared by Joint Technical Committee ISO/IEC JTC 1, Information
technology, Subcommittee SC 34, Document description and processing languages.
Copyright © ISO/IEC 2012 – All rights reserved  v
PROOF/ÉPREUVE
ISO/IEC 29500-4:2011/Amd.1:2012

Introduction
ISO 8601 dates are permitted in SpreadsheetML cell values in both Strict and Transitional variants. In other
aspects, Transitional ISO/IEC 29500-4 is identical to ECMA-376, edition 1, but applications able to read ECMA-
376 edition 1-compliant documents will regard ISO/IEC 29500-4 Transitional documents containing ISO 8601
dates as corrupt.
ISO/IEC 29500-1:2011/Amd.1:2012 removes the leap year bug by removing the "1900 backward-compatibility
date base". This amendment (ISO/IEC 29500-4:2011/Amd.1:2012) alters the "1900 date base" such that
Transitional documents must always exhibit the leap year bug. As a result, support for the date bases is as
follows:
Date Base Status in ISO/IEC 29500- Status in ISO/IEC 29500-
1:2011/Amd.1:2012 4:2011/Amd.1:2012
"1900" Stays as "1900" Removed
"1900 backward-compatibility" Removed Renamed to "1900"
"1904 backward-compatibility" Renamed to "1904" Renamed to "1904"

vi  Copyright © ISO/IEC 2012 – All rights reserved
PROOF/ÉPREUVE
ISO/IEC 29500-4:2011/Amd.1:2012
Notational conventions
The title of each change is the complete reference to the clause or subclause being modified. In all cases, the
title begins with the clause
...