Conditional Formatting

Some columns on the Extension sheet contain conditional formatting, which helps in building the taxonomy extension. The ElementName texts turn blue when they are defined with the prefix defined in the /**Extension literal. When you start creating your own extension elements, define your own namespace URI and a prefix.

If you delete the conditional formatting by accident or change the formatting, the checks will become inconsistent. You can refresh all the conditional formats by creating a report package. Conditional formatting will be reverted to original after creating the report.

List of formatting rules for the Extension sheet

Column	Definition	Formatting
All columns	Comment (/*)	Green text
All columns	Is a linkrole definition role	Violet text
All columns	Referenced element (/**Ref)	Brown text
ElementName	Duplicate of an earlier row	Underlined text
ElementName	Is an extension taxonomy element	Blue text
ElementName	Not a correct qualified name	Red text
AnchoringWider	Not a correct qualified name or the underlying basic expectation is not true: ElementName defines a core taxonomy element and AnchoringWider an extension element OR ElementName defines an extension element and AnchoringWider a core taxonomy element	Red text
AnchoringWider	Is an extension taxonomy element	Blue text

List of conditional formatting rules for the Mapping sheet

Column	Definition	Formatting
All columns	Comment (/*)	Green text
All columns	Literals (/**)	Violet text
All columns	Is an extension taxonomy element	Blue text
ElementName	Not defined on Extension or is abstract/dimensional	Red text
PeriodInit	Given for Period=instant element	Red text
PeriodInit	Not given for Period=duration element	Red background

Conditional Formatting

Was this article helpful?