<rdn>
(Revision Defined Name)
This element represents a revision record of a defined name change.
Parent Elements |
---|
|
Child Elements |
Subclause |
---|---|
|
|
|
|
|
Attributes |
Description |
---|---|
|
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). |
|
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). |
|
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. |
|
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). |
|
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. |
|
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. |
|
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). |
|
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. |
|
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. |
|
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). |
|
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). |
|
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). |
|
A string representing the old description text The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
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. |
|
Old function group ID. The possible values for this attribute are defined by the XML Schema unsignedByte datatype. |
|
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). |
|
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. |
|
Old keyboard shortcut. The possible values for this attribute are defined by the XML Schema unsignedByte datatype. |
|
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). |
|
A Boolean flag which indicates that this revision was due to a previous undo ( The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
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. |
|
Represents the new keyboard shortcut. The possible values for this attribute are defined by the XML Schema unsignedByte datatype. |
|
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). |
|
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>