[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

rdn (Revision Defined Name)

This element represents a revision record of a defined name change.

Parent Elements

revisions3.11.1.16)

 

Child Elements

Subclause

extLst (Future Feature Data Storage Area)

§3.2.10

formula (Formula)

§3.3.1.40

oldFormula (Old Formula)

§3.11.1.7

 

Attributes

Description

comment (Name Comment)

A string representing a comment about the defined name.

 

Note: This comment can be shown by the spreadsheet application in a names management UI so that users have more information about what the defined name is used for.

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

customMenu (New Custom Menu)

A string representing the new custom menu text

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

customView (Custom View)

A Boolean flag indicating that this named range belongs to a custom view

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

description (Description)

A string representing the new description text for the defined name.

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

function (Function)

A Boolean value indicating that the defined name refers to a function. True if the defined name is a function, false otherwise.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

functionGroupId (Function Group Id)

Represents the new function group id.

 

Function group ids are used to help classify functions. For instance, functions in the same group can be searched or selected easily from the spreadsheet applications UI. For instance, filtering the list of all functions to allow the user to choose from functions used for financial data.

 

The following group ids should be used:

ID Function group

1 Financial

2 Date and Time

3 Math and Trig

4 Statistical

5 Lookup & Reference

6 Database

7 Text

8 Logical

9 Information

10 Commands

11 Customizing

12 Macro Control

13 DDE/External

14 User Defined

15 Engineering

14 Cube

 

The possible values for this attribute are defined by the XML Schema unsignedByte datatype.

help (New Help Topic)

A string representing the new help topic text.

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

hidden (Named Range Hidden)

A Boolean value indicating whether the named range is now hidden.

 

Note: hidden refers to whether the defined name is of a 'hidden' type. This applies to things like a custom filter on a cell, it has a name, but is hidden and so is not visible in any name management UI.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

localSheetId (Local Name Sheet Id)

An integer representing the id of the sheet to which this defined name belongs. This shall be used local defined names only.

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

name (Name)

A string representing the name for this defined name.

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

oldComment (Old Name Comment)

A string representing the old comment about the defined name.

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

oldCustomMenu (Old Custom Menu Text)

A string representing the old custom menu text

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

oldDescription (Old Description)

A string representing the old description text

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

oldFunction (Old Function)

A Boolean flag indicating that the old name was a function

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

oldFunctionGroupId (Old Function Group Id)

Old function group ID.

 

The possible values for this attribute are defined by the XML Schema unsignedByte datatype.

oldHelp (Old Help Topic)

A string representing the old help topic text

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

oldHidden (Old Hidden)

A Boolean flag indicating whether the named range was hidden

 

Note: hidden refers to whether the defined name is of a 'hidden' type. This applies to things like a custom filter on a cell, it has a name, but is hidden and so is not visible in any name management UI.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

oldShortcutKey (Old Short Cut Key)

Old keyboard shortcut.

 

The possible values for this attribute are defined by the XML Schema unsignedByte datatype.

oldStatusBar (Old Status Bar)

A string representing the old status bar text

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

ra (Revision Undo Rejected)

A Boolean flag which indicates that this revision was due to a previous undo (ua) revision being rejected.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

rId (Revision Id)

An integer representing the number of this revision. This id shall apply to reviewable revision types only.

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

shortcutKey (Shortcut Key)

Represents the new keyboard shortcut.

 

The possible values for this attribute are defined by the XML Schema unsignedByte datatype.

statusBar (Status Bar)

A string representing the new status bar text.

 

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

ua (Revision From Rejection)

A Boolean flag indicating that this revision occurred because another revision was rejected and therefore undone.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_RevisionDefinedName">

   <sequence>

   <element name="formula" type="ST_Formula" minOccurs="0" maxOccurs="1"/>

   <element name="oldFormula" type="ST_Formula" minOccurs="0" maxOccurs="1"/>

   <element name="extLst" minOccurs="0" type="CT_ExtensionList"/>

   </sequence>

   <attributeGroup ref="AG_RevData"/>

   <attribute name="localSheetId" type="xsd:unsignedInt" use="optional"/>

   <attribute name="customView" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="name" type="ST_Xstring" use="required"/>

   <attribute name="function" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="oldFunction" type="xsd:boolean" default="false"/>

   <attribute name="functionGroupId" type="xsd:unsignedByte" use="optional"/>

   <attribute name="oldFunctionGroupId" type="xsd:unsignedByte" use="optional"/>

   <attribute name="shortcutKey" type="xsd:unsignedByte" use="optional"/>

   <attribute name="oldShortcutKey" type="xsd:unsignedByte" use="optional"/>

   <attribute name="hidden" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="oldHidden" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="customMenu" type="ST_Xstring" use="optional"/>

   <attribute name="oldCustomMenu" type="ST_Xstring" use="optional"/>

   <attribute name="description" type="ST_Xstring" use="optional"/>

   <attribute name="oldDescription" type="ST_Xstring" use="optional"/>

   <attribute name="help" type="ST_Xstring" use="optional"/>

   <attribute name="oldHelp" type="ST_Xstring" use="optional"/>

   <attribute name="statusBar" type="ST_Xstring" use="optional"/>

   <attribute name="oldStatusBar" type="ST_Xstring" use="optional"/>

   <attribute name="comment" type="ST_Xstring" use="optional"/>

   <attribute name="oldComment" type="ST_Xstring" use="optional"/>

</complexType>