{"type":"doc","content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":66.66},"content":[{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"german","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"dbee1283-5f29-4e46-a1b7-6ef008a6f507"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://us.translations-static-assets.aws.bitvoodoo.cloud/static/latest/images/de_DE.png"}}],"title":"German"}},"localId":"35bed54e-82ac-49fb-93aa-a1b281f0476b"},"content":[{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Um die automatische Befüllung der Excel-Dateien und das Zusammenspiel zwischen Office-Dateien zu ermöglichen, sind in ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" spezielle Namen und Namenszusätze hinterlegt, welche innerhalb von Excel bestimmten Zellen, Zellbereichen oder Spalten zugewiesen werden müssen.","type":"text"}]},{"type":"paragraph","content":[{"text":"Diese dienen der einfachen Verknüpfung der Word- und Power Point-Dokumente mit den zugehörigen Zellbereichen der Excel-Tabellen.","type":"text"}]},{"type":"paragraph","content":[{"text":"Dabei ist generell darauf zu achten, dass den Zellen, Zellbereichen und Spalten eindeutige Namen zugewiesen werden und dass innerhalb der Excel-Tabellen die Groß- und Kleinschreibung von Namen zu berücksichtigen ist.","type":"text"}]},{"type":"paragraph","content":[{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" verwendet bei der Namensvergabe fortlaufende Nummern, weil Excel grundsätzlich keine zwei gleichen Namen zulässt. Gerade wenn Namen vom Benutzer manuell in Excel eingetragen werden, ist dieser Umstand zu beachten.","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Für vollautomatische, halbautomatische und programmierte manuelle Tabellen müssen über „name_“ eine Namensspalte, „value_“ eine Wertespalte und „prog_“ eine Programmierungsspalte benannt und damit definiert werden","type":"text"}]}]},{"type":"paragraph"}]}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"german","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"2bbe5502-f187-42a4-9e9d-339901def322"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://us.translations-static-assets.aws.bitvoodoo.cloud/static/latest/images/de_DE.png"}}],"title":"German"}},"localId":"a1abf80a-e638-4dbf-a6d8-b8d527da08b3"},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"1f310","text":"🌐","shortName":":globe_with_meridians:"}},{"text":" ","type":"text"},{"text":"Programmierung der Excel-Tabellen","type":"text","marks":[{"type":"underline"},{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233334"}}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Namen und Namensmanager","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Zellen, Zellbereiche und Spalten mit Namen versehen","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233374"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Eingaben für die Programmierspalte","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233402"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Programmierungsassistent","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233426"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Referenzprogrammierung","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233450"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Fußnotenspalten","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233470"}}]}]}]}]}]}]}]}]}]},{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":66.66},"content":[{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"english","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"cb9f0fd9-20f3-4f39-9da1-c6d26a2bedac"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://us.translations-static-assets.aws.bitvoodoo.cloud/static/latest/images/en_GB.png"}}],"title":"English"}},"localId":"348481ca-ea95-47b0-b67e-740f1ee6c4fb"},"content":[{"type":"paragraph"},{"type":"paragraph","content":[{"text":"In order to enable the automatic filling of the Excel files and the interaction between Office files, special names and name additions are stored in ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":", which must be assigned to certain cells, cell ranges or columns within Excel.","type":"text"}]},{"type":"paragraph","content":[{"text":"These serve to easily link Word and PowerPoint documents with the corresponding cell ranges of the Excel tables.","type":"text"}]},{"type":"paragraph","content":[{"text":"It is generally important to ensure that the cells, cell ranges and columns are assigned unique names and that the names are case-sensitive within the Excel tables.","type":"text"}]},{"type":"paragraph","content":[{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" uses consecutive numbers when assigning names because Excel does not allow two identical names in principle. Especially when names are entered manually by the user in Excel, this circumstance must be taken into account.","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"For fully automatic, semi-automatic and programmed manual tables, a name column must be named via \"name_\", a value column via \"value_\" and a programming column via \"prog_\" and thus defined.","type":"text"}]}]},{"type":"paragraph"},{"type":"paragraph"}]}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"english","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"26b24ebf-7612-439f-94fb-a349a4e3e4ef"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://us.translations-static-assets.aws.bitvoodoo.cloud/static/latest/images/en_GB.png"}}],"title":"English"}},"localId":"176780b8-a328-4184-a783-7ec8c4187512"},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"1f310","text":"🌐","shortName":":globe_with_meridians:"}},{"text":" ","type":"text"},{"text":"Programming the Excel tables","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233334"}}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Names and Name Manager","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Assigning names to cells, cell ranges, and columns","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233374"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Inputs for the Programming Column","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233402"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Programming Wizard","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233426"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"References","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233450"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Footnote Columns","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233470"}}]}]}]}]}]}]}]}]}]},{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"german","parameters":{"macroParams":{"atlassian-macro-output-type":{"value":"INLINE"}},"macroMetadata":{"macroId":{"value":"cc7d3105-5f3a-416c-b171-4c4a2fa8eb6f"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://us.translations-static-assets.aws.bitvoodoo.cloud/static/latest/images/de_DE.png"}}],"title":"German"}},"localId":"0b7d5ca7-6879-4f3e-ae56-71b7120fe785"},"content":[{"type":"table","attrs":{"layout":"default","localId":"9a4e4928-bd52-4399-882b-b7e2f926589b"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[1766.0]},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Festgelegte Namen und -zusätze","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1766.0]},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

Bezeichnung	Funktion
outarea outarea [_Name] outarea [_Name][_Sprache]	Ausgabebereich für den Export nach Word. Jede Zelle und jeder Zellbereich, der mit „outarea“ beginnt, kann optional um einen Namens- und/oder Sprachzusatz ergänzt werden [z.B. outarea_GuV_en].
name_1 name_1[_Sprache]	Namensspalte, welche optional um ein Sprachkürzel ergänzt werden kann [z.B. name_1, name_1_en].
value_laufende Nummer_PeriodenID[_Sprache]	Wertespalte, welche mit einer laufenden Nummer sowie einer PeriodenID versehen wird und optional um einen Sprachzusatz ergänzt werden kann.
column_name_laufende Nummer	Überschrift einer Spalte [bei mehreren „value_“-Spalten], welche mit einer laufenden Nummer versehen wird.
prog_laufende Nummer_PeriodenID	Programmierspalte, welche mit einer laufenden Nummer und einer PeriodenID versehen wird [z.B. prog_2_PAKTUELLESJAHR].

60%

Um eine Eindeutigkeit innerhalb der Nomenklatur der Excel-Tabellen zu erreichen und so die Programmierung für die Berichtswerte zu vereinfachen, werden in SmartNotes festgelegte Namen und Namenszusätze verwendet. Diese werden in den folgenden beiden Tabellen als Übersicht dargestellt. Eine genaue Beschreibung der einzelnen Punkte findet sich in den folgenden Kapiteln.
Kursiv geschriebene Bezeichnungen stellen beschreibende Platzhalter dar, welche durch die entsprechenden Werte ersetzt werden [z.B. „laufende Nummer“ als Beschreibung für den Wert „2“]. In „[ ]“ eingefasste Beschreibungen stellen optionale Namensergänzungen dar [z.B. „[_Sprache]“ als Hinweis auf eine optionalen Zusatz des Sprachkürzels „[_en]“].

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"806bece3-de59-4145-bb44-055c3b130953"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

Bezeichnung	Funktion
outarea outarea [_Name] outarea [_Name][_Sprache]	Ausgabebereich für den Export nach Word. Jede Zelle und jeder Zellbereich, der mit „outarea“ beginnt, kann optional um einen Namens- und/oder Sprachzusatz ergänzt werden [z.B. outarea_GuV_en].
name_1 name_1[_Sprache]	Namensspalte, welche optional um ein Sprachkürzel ergänzt werden kann [z.B. name_1, name_1_en].
value_laufende Nummer_PeriodenID[_Sprache]	Wertespalte, welche mit einer laufenden Nummer sowie einer PeriodenID versehen wird und optional um einen Sprachzusatz ergänzt werden kann.
column_name_laufende Nummer	Überschrift einer Spalte [bei mehreren „value_“-Spalten], welche mit einer laufenden Nummer versehen wird.
prog_laufende Nummer_PeriodenID	Programmierspalte, welche mit einer laufenden Nummer und einer PeriodenID versehen wird [z.B. prog_2_PAKTUELLESJAHR].

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"layout":"full-width","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"40%"}},"macroMetadata":{"macroId":{"value":"08c71d82-5e35-4584-96bc-ad37660795ca"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"table","attrs":{"layout":"full-width"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[229.05]},"content":[{"type":"paragraph","content":[{"text":"Bezeichnung","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[805.59]},"content":[{"type":"paragraph","content":[{"text":"Funktion","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[229.05]},"content":[{"type":"paragraph","content":[{"text":"outarea","type":"text"},{"type":"hardBreak"},{"text":"outarea [_Name]","type":"text"},{"type":"hardBreak"},{"text":"outarea [_Name][_Sprache]","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[805.59]},"content":[{"type":"paragraph","content":[{"text":"Ausgabebereich für den Export nach Word. Jede Zelle und jeder Zellbereich, der mit „outarea“ beginnt, kann optional um einen Namens- und/oder Sprachzusatz ergänzt werden [z.B. outarea_GuV_en].","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[229.05]},"content":[{"type":"paragraph","content":[{"text":"name_1","type":"text"},{"type":"hardBreak"},{"text":"name_1[_Sprache]","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[805.59]},"content":[{"type":"paragraph","content":[{"text":"Namensspalte, welche optional um ein Sprachkürzel ergänzt werden kann [z.B. name_1, name_1_en].","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[229.05]},"content":[{"type":"paragraph","content":[{"text":"value_","type":"text"},{"text":"laufende ","type":"text","marks":[{"type":"em"}]},{"text":"Nummer_PeriodenID","type":"text","marks":[{"type":"em"}]},{"text":"[_Sprache]","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[805.59]},"content":[{"type":"paragraph","content":[{"text":"Wertespalte, welche mit einer laufenden Nummer sowie einer PeriodenID versehen wird und optional um einen Sprachzusatz ergänzt werden kann.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[229.05]},"content":[{"type":"paragraph","content":[{"text":"column_name_","type":"text"},{"text":"laufende Nummer","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[805.59]},"content":[{"type":"paragraph","content":[{"text":"Überschrift einer Spalte [bei mehreren „value_“-Spalten], welche mit einer laufenden Nummer versehen wird.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[229.05]},"content":[{"type":"paragraph","content":[{"text":"prog_","type":"text"},{"text":"laufende Nummer_PeriodenID","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[805.59]},"content":[{"type":"paragraph","content":[{"text":"Programmierspalte, welche mit einer laufenden Nummer und einer PeriodenID versehen wird [z.B. prog_2_PAKTUELLESJAHR].","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"60%

40%

Bezeichnung	Funktion
sn_title	Titel des zugehörigen Kapitels
sn_duedate	Stichtag des Dokumentes
sn_year	Bezugsjahr des Dokumentes, z.B. „2021“
sn_unit	Kürzel für das Ausgabeformat der Excel-Datei beim Einchecken [z.B. Mio. Mrd.]

60%

Zellbereiche, die von SmartNotes befüllt und aktualisiert werden.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"a3954827-fc80-4cef-9f58-c56ace1be92d"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

Bezeichnung	Funktion
sn_title	Titel des zugehörigen Kapitels
sn_duedate	Stichtag des Dokumentes
sn_year	Bezugsjahr des Dokumentes, z.B. „2021“
sn_unit	Kürzel für das Ausgabeformat der Excel-Datei beim Einchecken [z.B. Mio. Mrd.]

Zellbereiche, die von SmartNotes befüllt und aktualisiert werden.

40%

60%

In jeder Excel-Datei muss über den Namen „outarea“ ein Zellbereich als Ausgabebereich definiert werden. Dieser kann in einer Word-Datei angezeigt werden und stellt damit die Datenbasis für die Tabellen in Ergebnisdokumenten dar.
Die Bezeichnung kann dabei nur aus „outarea“ bestehen oder optional um einen Namenszusatz und/oder um einen Sprachzusatz in Form des Länderkürzels ergänzt werden.
Der Ausgabebereich muss auch in rein-manuellen Tabellen angelegt werden, wenn diese in weitere Ausgabeformate wie Word- oder PowerPoint-Dateien exportiert werden sollen.

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"ae4240b4-1977-4008-b1e6-9db70131580e"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

dashedüber das SmartNotes Ribbon

40%

60%

Die einfachste Möglichkeit zur Namensvergabe stellt das SmartNotes Ribbon in Excel dar. Dazu wird die gewünschte Zelle, der Zellbereich oder die Spalte markiert und der passende Eintrag aus dem SmartNotes Ribbon ausgewählt. Je nachdem, ob eine Zelle bzw. Zellbereich oder eine ganze Spalte markiert wird, ändert sich die Darstellung des Ribbons kontextsensitiv.

40%

60%

40%

60%

Noch anzulegende Namensbereiche sind mit den entsprechenden Symbolen gekennzeichnet.

Über das Add-ins Menü

40%

60%

Alternativ kann zur Namensvergabe auch jederzeit das normale Kontextmenü mit einem Rechtsklick geöffnet werden. Unter dem Menüpunkt „SmartNotes...“ finden sich die von SmartNotes kontextabhängig zur Verfügung gestellten Funktionen.

40%

60%

Nach der Anlage der Namensbereiche sind die entsprechenden Zellen noch nicht mit dem jeweiligen Inhalt befüllt. Um eine Voransicht der getätigten Änderungen zu erhalten, wird der Button „Aktualisieren“ im SmartNotes Ribbon verwendet. Anschließend erscheint bspw. in dem Namensbereich „sn_year“ das Bezugsjahr des Dokumentes.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Namensvergabe"}},"macroMetadata":{"macroId":{"value":"8326145f-f629-4ea6-86fd-176f0c47f8f2"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"über das SmartNotes Ribbon","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"a3dc5efe-6b97-4c6a-a944-44b7d7782830"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"79df7631-97ef-4232-96de-f53a31e0a110"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

40%

60%

Noch anzulegende Namensbereiche sind mit den entsprechenden Symbolen gekennzeichnet.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"794b6c31-f3dd-44d6-b37a-0d1d8ce44525"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

Noch anzulegende Namensbereiche sind mit den entsprechenden Symbolen gekennzeichnet.

40%

60%

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"747e0a1d-ab9a-4bec-8f23-26683e43a9cc"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"47c371fa-2509-4af4-9d8a-ae339a101f73"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

40%

60%

SmartNotes stellt die Möglichkeit zur Verfügung, mehrere nicht direkt nebeneinander liegende Spalten gleichzeitig zu benennen. Dazu werden zunächst die gewünschten Spalten markiert; entweder mit gedrückter linker Maustaste und dem anschließendem Ziehen eines Bereiches oder mit Hilfe der gedrückten „Strg“-Taste und dem gezielten Auswählen durch den Mauszeiger plus Klick.

Anschließend kann im Bereich „Spalten“ im SmartNotes Ribbon die gewünschte Funktion ausgewählt werden. Die Unterpunkte der verschiedenen Menüs werden nun kontextsensitiv mit der Bezeichnung „Range einfügen“ versehen. Im gegebenen Beispiel werden nun die selektierten Spalten I bis L als Wertespalten des aktuellen Jahres – bzw. der aktuellen Periode – definiert. Dabei wird SmartNotes die fortlaufende Nummerierung der Spalten selbst vornehmen, so dass Spalte I als „value_1_PAKTUELLESJAHR01“ benannt wird und Spalte L als „value_4_PAKTUELLESJAHR01“.

40%

60%

Dasselbe Vorgehen ist natürlich auch für die korrespondierenden Programmierspalten –sowie weitere Spaltentypen – möglich, wodurch sich eine lohnenswerte Zeitersparnis bei der initialen Anlage von SmartNotes-Tabellen ergibt. Im gegebenen Beispiel für die Programmierspalten wurde eine gezielte Selektion mit der „Strg“-Taste vorgenommen.

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"54fee848-027c-4c4c-9793-4ae5aba660e2"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"60%"}},"macroMetadata":{"macroId":{"value":"3222018d-e0b3-4de4-9abc-3fd4fe8e9fcc"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" stellt die Möglichkeit zur Verfügung, mehrere nicht direkt nebeneinander liegende Spalten gleichzeitig zu benennen. Dazu werden zunächst die gewünschten Spalten markiert; entweder mit gedrückter linker Maustaste und dem anschließendem Ziehen eines Bereiches oder mit Hilfe der gedrückten „Strg“-Taste und dem gezielten Auswählen durch den Mauszeiger plus Klick.","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"},{"text":"Anschließend kann im Bereich „Spalten“ im ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" Ribbon die gewünschte Funktion ausgewählt werden. Die Unterpunkte der verschiedenen Menüs werden nun kontextsensitiv mit der Bezeichnung „Range einfügen“ versehen. Im gegebenen Beispiel werden nun die selektierten Spalten I bis L als Wertespalten des aktuellen Jahres – bzw. der aktuellen Periode – definiert. Dabei wird ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" die fortlaufende Nummerierung der Spalten selbst vornehmen, so dass Spalte I als „value_1_PAKTUELLESJAHR01“ benannt wird und Spalte L als „value_4_PAKTUELLESJAHR01“.","type":"text"}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A section macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"f7f97ec7-87f5-4d0c-90fb-de397f4c6630"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

40%

60%

Excel stellt per Dropdown-Liste eine Übersicht aller bereits angelegter Namen zur Verfügung. Mit einem Linksklick auf den jeweiligen Namen wird der entsprechende Zellbereich markiert und hervorgehoben.

40%

60%

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"97a3f773-6439-4a11-bdf6-c28a7772b807"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"25a91910-10e2-4454-9b60-ed65d8007ff2"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

40%

60%

Alle bereits vorhandenen Namen können auch mit Hilfe des „Namens-Managers“ angezeigt werden. Der Assistent findet sich im Ribbon „Formeln“ unter dem Button „Namens-Manager“.

Wenn Sie statt der Ribbons mit den AddIns arbeiten, dann erreichen Sie den Namensmanager über das Excel-Menü „Formeln".

Im „Namens-Manager“ werden alle vergebenen Namen mitsamt ihrer Bezugsbereiche, Werte sowie weiterer Informationen aufgelistet. Die Einträge können nach verschiedenen Rubriken gefiltert und sortiert werden.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"32d4e4f8-29a2-4dd4-8b93-07dfb4f7781e"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

Alle bereits vorhandenen Namen können auch mit Hilfe des „Namens-Managers“ angezeigt werden. Der Assistent findet sich im Ribbon „Formeln“ unter dem Button „Namens-Manager“.

Wenn Sie statt der Ribbons mit den AddIns arbeiten, dann erreichen Sie den Namensmanager über das Excel-Menü „Formeln".

40%

60%

Die in Excel vergebenen Namen für Zellen, Zellbereiche und Spalten können auf unterschiedliche Art und Weise bearbeitet und gelöscht werden. Die verschiedenen Methoden werden in diesem Kapitel beschrieben.

In Excel können angelegte Namen über den „Namens-Manager“ geändert und gelöscht werden. Zum Öffnen des Assistenten wird im Ribbon „Formeln“ der Button „Namens-Manager“ verwendet.

40%

60%

Zum Bearbeiten wird der gewünschte Name markiert und mit dem Button „Bearbeiten“ der Assistent „Name bearbeiten“ aufgerufen. Um getätigte Änderungen zu speichern, muss der Assistent mit dem Button „OK“ geschlossen werden.

Zum Löschen wird der gewünschte Name markiert und der Löschvorgang mit dem Button „Löschen“ gestartet. Nach Bestätigung der anschließenden Sicherheitsabfrage wird der Name aus der Namensliste gelöscht.

Änderungen an Namen haben direkte Auswirkungen auf die Programmierung oder die Verlinkung zu Word Power Point. Wird beispielsweise der Name der outarea geändert, muss diese in Word oder Power Point neu eingefügt werden.

dashedNamen über das SmartNotes Ribbon bearbeiten

40%

60%

Eine weitere Möglichkeit zur Bearbeitung von Namen ist die Nutzung des SmartNotes Ribbons. Dazu der Zellbereich nicht markiert sein. Die Funktionen des SmartNotes Ribbon werden kontextsensitiv zur Verfügung gestellt.

Vorhandende Namensbereiche, die über das SmartNotes Ribbon bearbeitet [verlegt] werden können, sind mit einem entsprechenden Symbol gekennzeichnet.

Das Bearbeiten der Namen erfolgt im SmartNotes Ribbon generell über das Verlegen der Zellen, Zellbereiche oder Spalten. Dazu wird die neue Zelle, der neue Zellbereich oder die neue Spalte markiert und über das SmartNotes Ribbon der jeweilige, zu verlegende Name ausgewählt.

dashedNamen über das SmartNotes Ribbon löschen

40%

60%

Das SmartNotes Ribbon bietet die Möglichkeit angelegte Namen einzeln oder insgesamt zu löschen. Soll ein einzelner Name gelöscht werden, so wird dieser entweder über das Namensfeld oder direkt über die Zelle[n] ausgewählt und anschließend über den Menüpunkt „Namen löschen“ entfernt. Eine Sicherheitsabfrage findet nicht statt.

40%

60%

Zum Löschen aller angelegten Namen muss ist es nicht notwendig einen bestimmte Zelle beziehungsweise Zellbereich zu markieren. Es kann jederzeit der Button „Alle Namen entfernen“ im SmartNotes Ribbon verwendet werden. Dafür muss jedoch zuvor noch die erscheinende Sicherheitsabfrage „Alle Namen entfernen“ bestätigt werden.

Mit dieser Funktion werden alle Namen im Namensmanager unwiderruflich gelöscht.

40%

60%

40%

60%

In Excel können angelegte Namen über den „Namens-Manager“ geändert und gelöscht werden. Zum Öffnen des Assistenten wird im Ribbon „Formeln“ der Button „Namens-Manager“ verwendet.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"2edea003-20b5-414c-a4cb-19e712972f88"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

In Excel können angelegte Namen über den „Namens-Manager“ geändert und gelöscht werden. Zum Öffnen des Assistenten wird im Ribbon „Formeln“ der Button „Namens-Manager“ verwendet.

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"dc821a61-4441-4411-91f6-301aad06d979"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"60%"}},"macroMetadata":{"macroId":{"value":"50a4ab11-85f4-4812-9d23-7079cf3ffa2b"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":"Zum Bearbeiten wird der gewünschte Name markiert und mit dem Button „Bearbeiten“ der Assistent „Name bearbeiten“ aufgerufen. Um getätigte Änderungen zu speichern, muss der Assistent mit dem Button „OK“ geschlossen werden.","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"Zum Löschen wird der gewünschte Name markiert und der Löschvorgang mit dem Button „Löschen“ gestartet. Nach Bestätigung der anschließenden Sicherheitsabfrage wird der Name aus der Namensliste gelöscht.","type":"text"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Änderungen an Namen haben direkte Auswirkungen auf die Programmierung oder die Verlinkung zu Word Power Point. Wird beispielsweise der Name der outarea geändert, muss diese in Word oder Power Point neu eingefügt werden.","type":"text"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A section macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Namen über das SmartNotes Ribbon bearbeiten","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

Vorhandende Namensbereiche, die über das SmartNotes Ribbon bearbeitet [verlegt] werden können, sind mit einem entsprechenden Symbol gekennzeichnet.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"001a1cfd-cb02-49a6-9609-fc9e92510de2"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

Vorhandende Namensbereiche, die über das SmartNotes Ribbon bearbeitet [verlegt] werden können, sind mit einem entsprechenden Symbol gekennzeichnet.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"60%"}},"macroMetadata":{"macroId":{"value":"8d231f6e-c430-4330-bd06-17474d1bf4df"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":"Eine weitere Möglichkeit zur Bearbeitung von Namen ist die Nutzung des ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" Ribbons. Dazu der Zellbereich nicht markiert sein. Die Funktionen des ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" Ribbon werden kontextsensitiv zur Verfügung gestellt.","type":"text"}]},{"type":"paragraph","content":[{"text":"Vorhandende Namensbereiche, die über das ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" Ribbon bearbeitet [verlegt] werden können, sind mit einem entsprechenden Symbol gekennzeichnet. ","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"inline-media-image","parameters":{"width":"40","id":"d11c39a6-005b-4734-be3e-2777a862612f","collection":"contentId-6233358","height":""}}}]},{"type":"paragraph","content":[{"text":"Das Bearbeiten der Namen erfolgt im ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" Ribbon generell über das Verlegen der Zellen, Zellbereiche oder Spalten. Dazu wird die neue Zelle, der neue Zellbereich oder die neue Spalte markiert und über das SmartNotes Ribbon der jeweilige, zu verlegende Name ausgewählt.","type":"text"}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A section macro in a table cell can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Namen über das SmartNotes Ribbon löschen","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"2083b86d-ae22-4560-8afa-e11b46a6e7df"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

40%

60%

Mit dieser Funktion werden alle Namen im Namensmanager unwiderruflich gelöscht.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"04de7450-be8c-4ec0-a194-61e4fa52392e"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

Mit dieser Funktion werden alle Namen im Namensmanager unwiderruflich gelöscht.

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"57794bcd-970e-4498-91c4-099124b9faea"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"60%"}},"macroMetadata":{"macroId":{"value":"1ef3a11b-fdbc-4f84-9420-6c4e7aeed588"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A section macro in a table cell can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A panel macro in a table cell can't be created or edited in the new editor."}}},{"type":"paragraph"}]}]}]},{"type":"paragraph"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"english","parameters":{"macroParams":{"atlassian-macro-output-type":{"value":"INLINE"}},"macroMetadata":{"macroId":{"value":"5da55788-0812-484b-a740-b8abd40b06c2"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://us.translations-static-assets.aws.bitvoodoo.cloud/static/latest/images/en_GB.png"}}],"title":"English"}},"localId":"090e1d61-541e-4495-b560-982c3e9a67f6"},"content":[{"type":"table","attrs":{"layout":"default","localId":"de46d927-86e9-4123-a981-a44803031a45"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[1766.0]},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Fixed names and suffixes","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1766.0]},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

Bezeichnung	Funktion
outarea outarea [_name] outarea [_name][_language]	Output range for export to Word. Each cell and cell range starting with "outarea" can optionally be supplemented with a name and/or language addition [e.g. outarea_GuV_en].
name_1 name_1[_language]	Name column, which can optionally be supplemented by a language abbreviation [e.g. name_1, name_1_en].
value_running number_PeriodID[_language]	Value column, which is provided with a consecutive number and a period ID and can optionally be supplemented with a language supplement.
column_name_running number	Heading of a column [in the case of several "value_" columns], which is provided with a consecutive number.
prog_running number_PeriodID	Programming column, which is provided with a consecutive number and a period ID [e.g. prog_2_PAKTUELLESJAHR].

60%

In order to achieve uniqueness within the nomenclature of the Excel tables and thus simplify the programming for the report values, fixed names and name additions are used in SmartNotes. These are shown in the following two tables as an overview. A detailed description of the individual items can be found in the following chapters.

Names written in italics are descriptive placeholders which are replaced by the corresponding values [e.g. "sequence number" as a description for the value "2"]. Descriptions enclosed in "[ ]" represent optional name additions [e.g. "[_language]" as a reference to an optional addition of the language abbreviation "[_en]"].

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"0ca1e448-037a-4fae-b7b0-3981bceee596"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

Bezeichnung	Funktion
outarea outarea [_name] outarea [_name][_language]	Output range for export to Word. Each cell and cell range starting with "outarea" can optionally be supplemented with a name and/or language addition [e.g. outarea_GuV_en].
name_1 name_1[_language]	Name column, which can optionally be supplemented by a language abbreviation [e.g. name_1, name_1_en].
value_running number_PeriodID[_language]	Value column, which is provided with a consecutive number and a period ID and can optionally be supplemented with a language supplement.
column_name_running number	Heading of a column [in the case of several "value_" columns], which is provided with a consecutive number.
prog_running number_PeriodID	Programming column, which is provided with a consecutive number and a period ID [e.g. prog_2_PAKTUELLESJAHR].

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"layout":"full-width","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"40%"}},"macroMetadata":{"macroId":{"value":"dfa7862e-bf3a-46b3-8791-a03edea5088d"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"table","attrs":{"layout":"full-width"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[229.05]},"content":[{"type":"paragraph","content":[{"text":"Bezeichnung","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[805.59]},"content":[{"type":"paragraph","content":[{"text":"Funktion","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[229.05]},"content":[{"type":"paragraph","content":[{"text":"outarea","type":"text"},{"type":"hardBreak"},{"text":"outarea [_name]","type":"text"},{"type":"hardBreak"},{"text":"outarea [_name][_language]","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[805.59]},"content":[{"type":"paragraph","content":[{"text":"Output range for export to Word. Each cell and cell range starting with \"outarea\" can optionally be supplemented with a name and/or language addition [e.g. outarea_GuV_en].","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[229.05]},"content":[{"type":"paragraph","content":[{"text":"name_1","type":"text"},{"type":"hardBreak"},{"text":"name_1[_language]","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[805.59]},"content":[{"type":"paragraph","content":[{"text":"Name column, which can optionally be supplemented by a language abbreviation [e.g. name_1, name_1_en].","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[229.05]},"content":[{"type":"paragraph","content":[{"text":"value_","type":"text"},{"text":"running number","type":"text","marks":[{"type":"em"}]},{"text":"_PeriodID","type":"text","marks":[{"type":"em"}]},{"text":"[_language]","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[805.59]},"content":[{"type":"paragraph","content":[{"text":"Value column, which is provided with a consecutive number and a period ID and can optionally be supplemented with a language supplement.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[229.05]},"content":[{"type":"paragraph","content":[{"text":"column_name_","type":"text"},{"text":"running number","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[805.59]},"content":[{"type":"paragraph","content":[{"text":"Heading of a column [in the case of several \"value_\" columns], which is provided with a consecutive number.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[229.05]},"content":[{"type":"paragraph","content":[{"text":"prog_","type":"text"},{"text":"running number","type":"text","marks":[{"type":"em"}]},{"text":"_PeriodID","type":"text","marks":[{"type":"em"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[805.59]},"content":[{"type":"paragraph","content":[{"text":"Programming column, which is provided with a consecutive number and a period ID [e.g. prog_2_PAKTUELLESJAHR].","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"60%

40%

Bezeichnung	Funktion
sn_title	Title of the corresponding chapter
sn_duedate	Due date of the document
sn_year	Reference year of the document, e.g. "2021".
sn_unit	Abbreviation for the output format of the Excel file during check-in [e.g. million].

60%

Cell areas that are filled and updated by SmartNotes.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"ab97c14c-795f-49ff-93a1-e89ccc260dd8"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

Bezeichnung	Funktion
sn_title	Title of the corresponding chapter
sn_duedate	Due date of the document
sn_year	Reference year of the document, e.g. "2021".
sn_unit	Abbreviation for the output format of the Excel file during check-in [e.g. million].

Cell areas that are filled and updated by SmartNotes.

40%

60%

In each Excel file, a cell range must be defined as the output range via the name "outarea". This can be displayed in a Word file and thus represents the data basis for the tables in result documents.

The name can consist only of "outarea" or optionally be supplemented by a name suffix and/or a language suffix in the form of the country abbreviation.

The output area must also be created in purely manual tables if they are to be exported to other output formats such as Word or PowerPoint files.

40%

60%

The name can consist only of "outarea" or optionally be supplemented by a name suffix and/or a language suffix in the form of the country abbreviation.

The output area must also be created in purely manual tables if they are to be exported to other output formats such as Word or PowerPoint files.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"b1e296c9-3e59-4c8a-bed8-0d8b0e791ea4"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

The name can consist only of "outarea" or optionally be supplemented by a name suffix and/or a language suffix in the form of the country abbreviation.

The output area must also be created in purely manual tables if they are to be exported to other output formats such as Word or PowerPoint files.

dashedvia the SmartNotes Ribbon

40%

60%

The easiest way to assign names is to use the SmartNotes Ribbon in Excel. To do this, the desired cell, cell range or column is marked and the appropriate entry is selected from the SmartNotes Ribbon. Depending on whether a cell or cell range or an entire column is selected, the display of the ribbon changes context-sensitively.

40%

60%

40%

60%

Name ranges still to be created are marked with the corresponding symbols.

via context menu

40%

60%

Alternatively, the normal context menu can be opened at any time with a right click. The menu item "SmartNotes..." contains the functions provided by SmartNotes depending on the context.

40%

60%

After creating the name ranges, the corresponding cells are not yet filled with the respective content. To get a preview of the changes made, use the "Refresh" button in the SmartNotes ribbon. Afterwards, the reference year of the document appears in the name range "sn_year", for example.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Name assignment"}},"macroMetadata":{"macroId":{"value":"4f402a20-f3ed-48f3-866a-693609b8b109"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"via the SmartNotes Ribbon","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"cd88e23f-f8ef-4868-802d-b6051d15bd6b"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"7f29a4d3-2af0-40e6-816b-7539c7c3f7da"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

40%

60%

Name ranges still to be created are marked with the corresponding symbols.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"adc50d8d-c835-4ab7-9d14-bf99676a2496"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

Name ranges still to be created are marked with the corresponding symbols.

40%

60%

Alternatively, the normal context menu can be opened at any time with a right click. The menu item "SmartNotes..." contains the functions provided by SmartNotes depending on the context.

40%

60%

Alternatively, the normal context menu can be opened at any time with a right click. The menu item "SmartNotes..." contains the functions provided by SmartNotes depending on the context.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"3434a5c9-b9f3-494c-8696-735db046f0a8"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

Alternatively, the normal context menu can be opened at any time with a right click. The menu item "SmartNotes..." contains the functions provided by SmartNotes depending on the context.

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"ea90b96a-5e30-456e-91d7-2adfed0cd40c"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

40%

60%

40%

60%

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"337afc5f-489f-4ee9-acb4-5b4f85095fb5"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"60%"}},"macroMetadata":{"macroId":{"value":"80183d5e-d79f-440c-9e96-00a021bac57e"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" stellt die Möglichkeit zur Verfügung, mehrere nicht direkt nebeneinander liegende Spalten gleichzeitig zu benennen. Dazu werden zunächst die gewünschten Spalten markiert; entweder mit gedrückter linker Maustaste und dem anschließendem Ziehen eines Bereiches oder mit Hilfe der gedrückten „Strg“-Taste und dem gezielten Auswählen durch den Mauszeiger plus Klick.","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"},{"text":"Anschließend kann im Bereich „Spalten“ im ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" Ribbon die gewünschte Funktion ausgewählt werden. Die Unterpunkte der verschiedenen Menüs werden nun kontextsensitiv mit der Bezeichnung „Range einfügen“ versehen. Im gegebenen Beispiel werden nun die selektierten Spalten I bis L als Wertespalten des aktuellen Jahres – bzw. der aktuellen Periode – definiert. Dabei wird ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" die fortlaufende Nummerierung der Spalten selbst vornehmen, so dass Spalte I als „value_1_PAKTUELLESJAHR01“ benannt wird und Spalte L als „value_4_PAKTUELLESJAHR01“.","type":"text"}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A section macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"a8d4fa4b-e683-4321-9a61-3ccf044d21f8"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

40%

60%

Excel provides an overview of all names already created via a drop-down list. With a left click on the respective name, the corresponding cell range is marked and highlighted.

40%

60%

40%

60%

Excel provides an overview of all names already created via a drop-down list. With a left click on the respective name, the corresponding cell range is marked and highlighted.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"a9f7a40f-8bee-48f9-b1c5-b05a81737b3a"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

Excel provides an overview of all names already created via a drop-down list. With a left click on the respective name, the corresponding cell range is marked and highlighted.

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"ae4914c7-8991-451b-8259-35b5ea674912"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

40%

60%

All existing names can also be displayed with the help of the "Name Manager". The assistant can be found in the ribbon "Formulas" under the button "Name Manager".

If you work with the AddIns instead of the ribbons, you can reach the Name Manager via the Excel menu "Formulas".

In the "Name Manager", all assigned names are listed together with their reference ranges, values and other information. The entries can be filtered and sorted according to various categories.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"401b71b2-01ca-49ef-8403-9a32cdb865fe"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

All existing names can also be displayed with the help of the "Name Manager". The assistant can be found in the ribbon "Formulas" under the button "Name Manager".

If you work with the AddIns instead of the ribbons, you can reach the Name Manager via the Excel menu "Formulas".

In the "Name Manager", all assigned names are listed together with their reference ranges, values and other information. The entries can be filtered and sorted according to various categories.

40%

60%

The names assigned to cells, cell ranges and columns in Excel can be edited and deleted in different ways. The different methods are described in this chapter.

In Excel, created names can be changed and deleted via the "Name Manager". To open the wizard, use the "Name Manager" button in the "Formulas" ribbon.

40%

60%

For editing, the desired name is marked and the assistant "Edit name" is called up with the button "Edit". To save changes made, the assistant must be closed with the "OK" button.

To delete a name, select the desired name and start the deletion process by pressing the "Delete" button. After confirming the subsequent security question, the name is deleted from the name list.

Changes to names have a direct impact on programming or linking to Word Power Point. For example, if the name of the outarea is changed, it must be re-inserted in Word or Power Point.

dashedEditing names via the SmartNotes Ribbon

40%

60%

Another way to edit names is to use the SmartNotes ribbon. To do this, the cell range must not be selected. The functions of the SmartNotes ribbon are provided context-sensitively.

Existing name ranges that can be edited [moved] via the SmartNotes Ribbon are marked with a corresponding symbol.

Editing names is generally done in the SmartNotes ribbon by relocating cells, cell ranges or columns. To do this, the new cell, the new cell range or the new column is marked and the respective name to be moved is selected via the SmartNotes ribbon.

dashedDelete names via the SmartNotes Ribbon

40%

60%

The SmartNotes ribbon offers the possibility to delete created names individually or altogether. If a single name is to be deleted, it is selected either via the name field or directly via the cell[s] and then removed via the menu item "Delete name". There is no confirmation prompt.

40%

60%

To delete all created names, it is not necessary to select a specific cell or cell range. The button "Remove all names" in the SmartNotes Ribbon can be used at any time. To do this, however, the security question "Remove all names" must be confirmed beforehand.

This function deletes all names in the name manager irrevocably.

40%

60%

40%

60%

The names assigned to cells, cell ranges and columns in Excel can be edited and deleted in different ways. The different methods are described in this chapter.

In Excel, created names can be changed and deleted via the "Name Manager". To open the wizard, use the "Name Manager" button in the "Formulas" ribbon.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"f799dc9c-2ff8-4dc8-856d-f637ed76a5b2"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

The names assigned to cells, cell ranges and columns in Excel can be edited and deleted in different ways. The different methods are described in this chapter.

In Excel, created names can be changed and deleted via the "Name Manager". To open the wizard, use the "Name Manager" button in the "Formulas" ribbon.

40%

60%

For editing, the desired name is marked and the assistant "Edit name" is called up with the button "Edit". To save changes made, the assistant must be closed with the "OK" button.

To delete a name, select the desired name and start the deletion process by pressing the "Delete" button. After confirming the subsequent security question, the name is deleted from the name list.

Changes to names have a direct impact on programming or linking to Word Power Point. For example, if the name of the outarea is changed, it must be re-inserted in Word or Power Point.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"c991f42a-e88e-4883-8f23-91d2e0341711"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

For editing, the desired name is marked and the assistant "Edit name" is called up with the button "Edit". To save changes made, the assistant must be closed with the "OK" button.

To delete a name, select the desired name and start the deletion process by pressing the "Delete" button. After confirming the subsequent security question, the name is deleted from the name list.

Changes to names have a direct impact on programming or linking to Word Power Point. For example, if the name of the outarea is changed, it must be re-inserted in Word or Power Point.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"60%"}},"macroMetadata":{"macroId":{"value":"572fff0f-86e9-4464-b5f8-f38448160de3"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":"For editing, the desired name is marked and the assistant \"Edit name\" is called up with the button \"Edit\". To save changes made, the assistant must be closed with the \"OK\" button.","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"},{"text":"To delete a name, select the desired name and start the deletion process by pressing the \"Delete\" button. After confirming the subsequent security question, the name is deleted from the name list.","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Changes to names have a direct impact on programming or linking to Word Power Point. For example, if the name of the outarea is changed, it must be re-inserted in Word or Power Point.","type":"text"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A section macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Editing names via the SmartNotes Ribbon","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

Another way to edit names is to use the SmartNotes ribbon. To do this, the cell range must not be selected. The functions of the SmartNotes ribbon are provided context-sensitively.

Existing name ranges that can be edited [moved] via the SmartNotes Ribbon are marked with a corresponding symbol.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"7bfd9528-b5f4-4f6c-a410-051989edb200"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

Another way to edit names is to use the SmartNotes ribbon. To do this, the cell range must not be selected. The functions of the SmartNotes ribbon are provided context-sensitively.

Existing name ranges that can be edited [moved] via the SmartNotes Ribbon are marked with a corresponding symbol.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"60%"}},"macroMetadata":{"macroId":{"value":"193f2d9d-9b63-4fd5-bf4d-3225a7102e4b"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":"Another way to edit names is to use the SmartNotes ribbon. To do this, the cell range must not be selected. The functions of the SmartNotes ribbon are provided context-sensitively.","type":"text"}]},{"type":"paragraph","content":[{"text":"Existing name ranges that can be edited [moved] via the SmartNotes Ribbon are marked with a corresponding symbol.","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"inline-media-image","parameters":{"width":"40","id":"d11c39a6-005b-4734-be3e-2777a862612f","collection":"contentId-6233358","height":""}}}]},{"type":"paragraph","content":[{"text":"Editing names is generally done in the SmartNotes ribbon by relocating cells, cell ranges or columns. To do this, the new cell, the new cell range or the new column is marked and the respective name to be moved is selected via the SmartNotes ribbon.","type":"text"}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A section macro in a table cell can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Delete names via the SmartNotes Ribbon","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"8431686c-e433-4bc2-8648-a55dcb8f0923"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

40%

60%

This function deletes all names in the name manager irrevocably.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"1646173a-8416-4711-8fa3-7b21e8e756b7"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

This function deletes all names in the name manager irrevocably.

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"3455d060-ad98-4fbc-ab2a-100453f34352"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"60%"}},"macroMetadata":{"macroId":{"value":"2dd9ec67-ff96-4cf7-9c5d-ea6a9c4e6dda"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A section macro in a table cell can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A panel macro in a table cell can't be created or edited in the new editor."}}},{"type":"paragraph"}]}]}]},{"type":"paragraph"}]},{"type":"rule"},{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":66.66},"content":[{"type":"paragraph"}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"german","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"13ab6304-7d9e-4612-9e3e-ca5e4f1af9a1"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://us.translations-static-assets.aws.bitvoodoo.cloud/static/latest/images/de_DE.png"}}],"title":"German"}},"localId":"4c689c61-1d0f-49ef-acf3-130208cfdffa"},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"1f310","text":"🌐","shortName":":globe_with_meridians:"}},{"text":" ","type":"text"},{"text":"Programmierung der Excel-Tabellen","type":"text","marks":[{"type":"underline"},{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233334"}}]}]}]}]}]},{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":66.66},"content":[{"type":"paragraph"}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"english","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"b78b045a-64c4-494f-9207-3273cd5546b5"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://us.translations-static-assets.aws.bitvoodoo.cloud/static/latest/images/en_GB.png"}}],"title":"English"}},"localId":"91d40a04-d8c3-4c9f-a58d-b7633ccbc94e"},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"1f310","text":"🌐","shortName":":globe_with_meridians:"}},{"text":" ","type":"text"},{"text":"Programming the Excel tables","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233334"}}]}]}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}],"version":1}