40%

60%

Sprachunabhängige Einstellungen werden nicht sprachenspezifisch, sondern unabhängig von der aktuellen Dokumentsprache vorgenommen und sprachübergreifend für alle Sprachen eines SmartNotes-Dokumentes übernommen.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"8117eee0-0524-4081-9bf6-69ffc88c9e66"},"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%

Bei den sprachunabhängigen Einstellungen kann für die in dem SmartNotes-Dokument verwendeten Excel-Dateien über den Button „Excel Formatvorlage hinzufügen" eine Excel Formatvorlage hinterlegt werden. Über den Button „Excel Formatvorlage bearbeiten“ kann eine hinterlegte Excel Formatvorlage direkt bearbeitet werden.

Die meisten Tabellen innerhalb eines Berichtes können von vier bis fünf unterschiedlichen Grundstrukturen abgeleitet werden. Daher bietet SmartNotes eine einfache Möglichkeit diese Grundstrukturen innerhalb einer Formatvorlage zu layouten und anschließend innerhalb eines Berichtes zur Verfügung zu stellen. Damit ist zusätzlich gewährleistet, dass alle Tabellen eines Berichtes einem einheitlichen Format und Layout folgen.

Eine einmal angelegte Formatvorlage steht innerhalb eines Dokumentes auch dann zur Verfügung, wenn das Dokument fortgeschrieben wird.

In den Mustertabellen der Formatvorlage empfiehlt es sich folgende Eigenschaften zentral zu definieren:

Hintergrundfarben
Schriftart, -größe und -farbe
Zahlenformatierungen
Tabellenrahmen
Zeichen Style [z.B. fett, kursiv]
Spaltenbreiten
Zeilenhöhen

Formatvorlage hinzufügen: Zum Anlegen oder Hinzufügen einer Excel Formatvorlage wird der Button „Excel Formatvorlage hinzufügen“ in den SmartNotes Dokumenteinstellungen für Excel verwendet.

Hierdurch erscheint ein Windows Explorer-Fenster, mit dem eine bereits vorhandene Excel Formatvorlage [z.B. ein Excel-Dokument mit dem gewünschten Corporate Design] oder ein schon vorab gespeichertes Excel-Dokument, welches als [zukünftige] Vorlage angepasst und genutzt werden soll, als Formatvorlage gespeichert werden kann.

Das erfolgreiche Hinzufügen der Formatvorlage wird mit dem Dialog „Erfolg“ bestätigt.

Formatvorlage bearbeiten: Zum Bearbeiten einer Excel Formatvorlage wird der Button „Excel Formatvorlage bearbeiten“ in den SmartNotes Dokumenteinstellungen für Excel verwendet. Hierdurch öffnet sich die hinterlegte Formatvorlage in Excel und kann anschließend bearbeitet werden.

Formatvorlage löschen: Zum Löschen einer Excel Formatvorlage wird der Button „Excel Formatvorlage löschen“ in den Dokumenteinstellungen verwendet. Dieser erscheint nur, wenn bereits eine Excel Formatvorlage hinterlegt worden ist, und ersetzt somit den ursprünglichen Button „Excel Formatvorlage hinzufügen“.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Excel Formatvorlage hinzufügen / bearbeiten"}},"macroMetadata":{"macroId":{"value":"4f0bc003-51d1-4c0b-8a1e-a6f4c10c2d60"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

Eine einmal angelegte Formatvorlage steht innerhalb eines Dokumentes auch dann zur Verfügung, wenn das Dokument fortgeschrieben wird.

In den Mustertabellen der Formatvorlage empfiehlt es sich folgende Eigenschaften zentral zu definieren:

Hintergrundfarben
Schriftart, -größe und -farbe
Zahlenformatierungen
Tabellenrahmen
Zeichen Style [z.B. fett, kursiv]
Spaltenbreiten
Zeilenhöhen

Das erfolgreiche Hinzufügen der Formatvorlage wird mit dem Dialog „Erfolg“ bestätigt.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"06335cb4-ce82-4f08-8160-88057d0da8ea"},"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%

Eine einmal angelegte Formatvorlage steht innerhalb eines Dokumentes auch dann zur Verfügung, wenn das Dokument fortgeschrieben wird.

In den Mustertabellen der Formatvorlage empfiehlt es sich folgende Eigenschaften zentral zu definieren:

Hintergrundfarben
Schriftart, -größe und -farbe
Zahlenformatierungen
Tabellenrahmen
Zeichen Style [z.B. fett, kursiv]
Spaltenbreiten
Zeilenhöhen

Das erfolgreiche Hinzufügen der Formatvorlage wird mit dem Dialog „Erfolg“ bestätigt.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"60%"}},"macroMetadata":{"macroId":{"value":"84a47e1c-4f12-4966-8130-99cc348e6970"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":"Bei den sprachunabhängigen Einstellungen kann für die in dem ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":"-Dokument verwendeten Excel-Dateien über den Button „Excel Formatvorlage hinzufügen\" eine Excel Formatvorlage hinterlegt werden. Über den Button „Excel Formatvorlage bearbeiten“ kann eine hinterlegte Excel Formatvorlage direkt bearbeitet werden.","type":"text"}]},{"type":"paragraph","content":[{"text":"Die meisten Tabellen innerhalb eines Berichtes können von vier bis fünf unterschiedlichen Grundstrukturen abgeleitet werden. Daher bietet ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" eine einfache Möglichkeit diese Grundstrukturen innerhalb einer Formatvorlage zu layouten und anschließend innerhalb eines Berichtes zur Verfügung zu stellen. Damit ist zusätzlich gewährleistet, dass alle Tabellen eines Berichtes einem einheitlichen Format und Layout folgen.","type":"text"}]},{"type":"paragraph","content":[{"text":"Eine einmal angelegte Formatvorlage steht innerhalb eines Dokumentes auch dann zur Verfügung, wenn das Dokument fortgeschrieben wird.","type":"text"}]},{"type":"paragraph","content":[{"text":"In den Mustertabellen der Formatvorlage empfiehlt es sich folgende Eigenschaften zentral zu definieren:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Hintergrundfarben","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Schriftart, -größe und -farbe","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Zahlenformatierungen","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Tabellenrahmen","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Zeichen Style [z.B. fett, kursiv]","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Spaltenbreiten","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Zeilenhöhen","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Formatvorlage hinzufügen:","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text","marks":[{"type":"em"}]},{"text":"Zum Anlegen oder Hinzufügen einer Excel Formatvorlage wird der Button „Excel Formatvorlage hinzufügen“ in den ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" Dokumenteinstellungen für Excel verwendet.","type":"text"}]},{"type":"paragraph","content":[{"text":"Hierdurch erscheint ein Windows Explorer-Fenster, mit dem eine bereits vorhandene Excel Formatvorlage [z.B. ein Excel-Dokument mit dem gewünschten Corporate Design] oder ein schon vorab gespeichertes Excel-Dokument, welches als [zukünftige] Vorlage angepasst und genutzt werden soll, als Formatvorlage gespeichert werden kann.","type":"text"}]},{"type":"paragraph","content":[{"text":"Das erfolgreiche Hinzufügen der Formatvorlage wird mit dem Dialog „Erfolg“ bestätigt.","type":"text"}]},{"type":"paragraph","content":[{"text":"Formatvorlage bearbeiten:","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text","marks":[{"type":"em"}]},{"text":"Zum Bearbeiten einer Excel Formatvorlage wird der Button „Excel Formatvorlage bearbeiten“ in den ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" Dokumenteinstellungen für Excel verwendet. Hierdurch öffnet sich die hinterlegte Formatvorlage in Excel und kann anschließend bearbeitet werden.","type":"text"}]},{"type":"paragraph","content":[{"text":"Formatvorlage löschen:","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text","marks":[{"type":"em"}]},{"text":"Zum Löschen einer Excel Formatvorlage wird der Button „Excel Formatvorlage löschen“ in den Dokumenteinstellungen verwendet. Dieser erscheint nur, wenn bereits eine Excel Formatvorlage hinterlegt worden ist, und ersetzt somit den ursprünglichen Button „Excel Formatvorlage hinzufügen“.","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"}]}]}],"version":1},"reason":"A panel macro in a table cell can't be created or edited in the new editor."}}},{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"end"}}],"content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"Checkbox „Excel CheckIn Kommentar erzwingen“

40%

60%

Die Checkbox „Excel CheckIn Kommentar erzwingen“ sorgt dafür, dass beim Einchecken einer Excel-Datei ein Kommentar hinterlegt werden muss.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Checkbox „Excel CheckIn Kommentar erzwingen“"}},"macroMetadata":{"macroId":{"value":"ad14dcdb-f61f-4e14-98e7-9d19d555bac8"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

Die Checkbox „Excel CheckIn Kommentar erzwingen“ sorgt dafür, dass beim Einchecken einer Excel-Datei ein Kommentar hinterlegt werden muss.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"30845474-3577-460c-a34c-e14e0026a549"},"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%

Die Checkbox „Excel CheckIn Kommentar erzwingen“ sorgt dafür, dass beim Einchecken einer Excel-Datei ein Kommentar hinterlegt werden muss.

40%

60%

Durch die Aktivierung der Checkbox „Bei schreibgeschützten Excel Dateien Kommentare zulassen“ können Office Dokumente trotz einer Leseberechtigung kommentiert werden. Beim Schließen eines schreibgeschützten Dokumentes erscheint ein Fenster, ähnlich dem CheckIn Fenster; in dem der Benutzer die Möglichkeit hat einen Kommentar zu verfassen. Dieser wir in der Kapitel Historie angezeigt.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Checkbox „Bei schreibgeschützten Excel Dateien Kommentare zulassen“"}},"macroMetadata":{"macroId":{"value":"48fc834c-6c9a-4d6c-bfa6-fd70334fcf75"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"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":"e40b70bb-b091-49d5-b40b-5851b198a559"},"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%

Die Checkbox „Excel löschen erfordert Benutzerkommentar" erfordert, dass beim Löschen einer Excel Datei ein Kommentar hinterlegt werden muss.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Checkbox „Excel löschen erfordert Benutzerkommentar“"}},"macroMetadata":{"macroId":{"value":"41947867-bc75-4588-b61b-854f345d0cfc"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

Die Checkbox „Excel löschen erfordert Benutzerkommentar" erfordert, dass beim Löschen einer Excel Datei ein Kommentar hinterlegt werden muss.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"8c4d355f-d608-460c-920e-e47e4a2408c4"},"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%

Die Checkbox „Excel löschen erfordert Benutzerkommentar" erfordert, dass beim Löschen einer Excel Datei ein Kommentar hinterlegt werden muss.

40%

60%

Das „Ausgabeformat“ der Excel Tabellen eines Dokuments kann zentral festgelegt werden Abweichungen vom zentralen Ausgabeformat können beim CheckIn einer Excel Datei eingestellt werden. Excel-Dateien, die schon vor Einstellung des zentralen Zahlenformats formatiert wurden, behalten ihr ursprüngliches Format.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Ausgabeformat"}},"macroMetadata":{"macroId":{"value":"b599ee36-4628-4199-856c-d7460bb1970f"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"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":"6e7b6eb4-048f-4e2f-8bb4-6b1241e5552b"},"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%

Mittels der „Zahlenformatierung“ wird die Standardformatierung für Werte in Excel-Tabellen festgelegt und die Zahl der Nachkommastellen mit denen SmartNotes rechnet . Durch einen Linksklick in das Eingabefeld öffnet sich der Assistent zur Zahlenformatierung, welcher auch eine Vorschaufunktion bietet. Das Format der Angabe entspricht dabei der manuellen Formatanpassung in Excel:

#,0 Zahl mit Tausender-Trennzeichen und ohne Nachkommastelle
#,0.# Zahl mit Tausender-Trennzeichen und einer Nachkommastelle
#,0.## Zahl mit Tausender-Trennzeichen und zwei Nachkommastellen

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Zahlenformatierung"}},"macroMetadata":{"macroId":{"value":"08e1d9a5-f245-4067-9c9a-d9b61272145b"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

#,0 Zahl mit Tausender-Trennzeichen und ohne Nachkommastelle
#,0.# Zahl mit Tausender-Trennzeichen und einer Nachkommastelle
#,0.## Zahl mit Tausender-Trennzeichen und zwei Nachkommastellen

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"6dafa4ea-bf9e-455f-a9ff-1ac1781fdcfd"},"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%

#,0 Zahl mit Tausender-Trennzeichen und ohne Nachkommastelle
#,0.# Zahl mit Tausender-Trennzeichen und einer Nachkommastelle
#,0.## Zahl mit Tausender-Trennzeichen und zwei Nachkommastellen

40%

60%

Es kann ein Wert bestimmt werden, ab dem eine prozentual vorgenommene Rundung verpflichtend kommentiert werden muss.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Kommentierungspflichtige %-Rundung"}},"macroMetadata":{"macroId":{"value":"15fd8c0e-6e13-4abc-a50c-ae8daa015ac9"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

Es kann ein Wert bestimmt werden, ab dem eine prozentual vorgenommene Rundung verpflichtend kommentiert werden muss.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"9106149c-0b3a-47e8-a600-bb63a191b46a"},"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%

Es kann ein Wert bestimmt werden, ab dem eine prozentual vorgenommene Rundung verpflichtend kommentiert werden muss.

40%

60%

Es kann ein Wert bestimmt werden, ab dem eine absolute Rundung verpflichtend kommentiert werden muss.

Für die Kommentierungspflicht der absoluten Rundung sind in der aktuellen SmartNotes Version auch nicht ganzzahlige Werte erlaubt.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Kommentierungspflichtige Abs-Rundung"}},"macroMetadata":{"macroId":{"value":"8b89e2a8-6b55-4505-b97e-4221de025945"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

Es kann ein Wert bestimmt werden, ab dem eine absolute Rundung verpflichtend kommentiert werden muss.

Für die Kommentierungspflicht der absoluten Rundung sind in der aktuellen SmartNotes Version auch nicht ganzzahlige Werte erlaubt.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"3569f143-3060-4a1f-8218-97c9dc6c9a5a"},"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%

Es kann ein Wert bestimmt werden, ab dem eine absolute Rundung verpflichtend kommentiert werden muss.

Für die Kommentierungspflicht der absoluten Rundung sind in der aktuellen SmartNotes Version auch nicht ganzzahlige Werte erlaubt.

40%

60%

Die Checkbox „Layout Bereiche beim Checkout anwenden“ sorgt dafür, dass die in der Formatvorlage definierten Layout Bereiche [Layout Actions] automatisch bei jedem Checkout auf die Excel-Dokumente angewendet werden, in denen ihre Verwendung vorgesehen ist. Es ist zu beachten, dass die Nutzung der Layout Actions bei jedem Checkout von Excel-Dateien leistungsintensiv sein kann.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Checkbox „Layout Bereiche beim Checkout anwenden“"}},"macroMetadata":{"macroId":{"value":"4926f720-7dc7-4387-9e46-725f862fdb22"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"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":"a20f5c36-04b9-4c9e-9556-5ac8a2aeb8b4"},"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%

Die Checkbox „Exakte von gerundeten Nullwerten unterscheiden“ ermöglicht es, dass eine „unechte Null", also einer Zahl die abgerundet Null ist, von einer "echten Null" (0) unterschieden wird. Dafür wird zu einer „unechten Null" ein winzig kleiner Wert (10^-6) addiert und echte Nullen bleiben Null. Dadurch wird z.B. eine „#.##0;-#.##0;-“ Formatierung bei den unechten Nullen eine „0“ anzeigen, bei den richtigen Nullen einen Strich „-“.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Checkbox „Exakte von gerundeten Nullwerten unterscheiden“"}},"macroMetadata":{"macroId":{"value":"09a0fae3-06c5-40bf-b808-83b5c39f28bd"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"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":"9055f7e5-2723-4f12-ac04-315bc180d95d"},"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%

Die Checkbox „Erweiterte Excel Programmierung erlauben“ stellt in der Programmierspalte die folgenden Funktionen zur Verfügung [die Auflistung erfolgt mit Hilfe von Beispielkonten]:

Soll(4711;4712): Die Werte der Konten 4711+4712 fließen in die Summe ein, wenn sie postitiv sind.
Haben(4711): Die Wertespalte enthält nur dann einen Wert, wenn dieser negativ ist.

Diese Funktion greift sowohl bei den deutschen Begriffen „Soll" und „Haben", als auch bei den englischen Begriffen „Debit" und „Credit".

Nach Setzen des Hakens muss der Zahlenimport neu durchgeführt werden, damit die Funktion greifen kann.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Checkbox „Erweiterte Excel Programmierung erlauben“"}},"macroMetadata":{"macroId":{"value":"9e765d18-3538-4fbd-b53d-dc6fd5bb6528"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

Die Checkbox „Erweiterte Excel Programmierung erlauben“ stellt in der Programmierspalte die folgenden Funktionen zur Verfügung [die Auflistung erfolgt mit Hilfe von Beispielkonten]:

Soll(4711;4712): Die Werte der Konten 4711+4712 fließen in die Summe ein, wenn sie postitiv sind.
Haben(4711): Die Wertespalte enthält nur dann einen Wert, wenn dieser negativ ist.

Diese Funktion greift sowohl bei den deutschen Begriffen „Soll" und „Haben", als auch bei den englischen Begriffen „Debit" und „Credit".

Nach Setzen des Hakens muss der Zahlenimport neu durchgeführt werden, damit die Funktion greifen kann.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"625ffd73-2f21-4072-b9f6-df906d2f7cee"},"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%

Die Checkbox „Erweiterte Excel Programmierung erlauben“ stellt in der Programmierspalte die folgenden Funktionen zur Verfügung [die Auflistung erfolgt mit Hilfe von Beispielkonten]:

Soll(4711;4712): Die Werte der Konten 4711+4712 fließen in die Summe ein, wenn sie postitiv sind.
Haben(4711): Die Wertespalte enthält nur dann einen Wert, wenn dieser negativ ist.

Diese Funktion greift sowohl bei den deutschen Begriffen „Soll" und „Haben", als auch bei den englischen Begriffen „Debit" und „Credit".

Nach Setzen des Hakens muss der Zahlenimport neu durchgeführt werden, damit die Funktion greifen kann.

40%

60%

Die Checkbox „Erweiterte Excel-Programmierung: Legacy Modus aktivieren“ ist eine zusätzliche Funktion, um die erweiterte Excel-Programmierung zu ergänzen. Mit dieser Funktion werden alle Kontonummern als Soll-Haben-Programmierungen gewertet, die mit einen „S" oder „H" beginnen oder enden. Dadurch ist es nicht mehr notwendig, die Kontonummern mit dem Zusatz „SOLL" oder „HABEN" zu ergänzen.

Diese Funktion greift auch bei den jeweils englischen Begriffen „DEBIT" und „CREDIT" und damit auch auf die englischen Kürzel „D" und „C".

Durch diese Option werden alle Kontonummern, die mit „S" oder „H" sowie „D" oder „C" beginnen oder auf diesen Buchstaben enden, als Soll oder Haben gewertet. Dau gehören beispielsweise auch Kontonummern wie „Konzernergebnis" oder „Dividents".

Nach Setzen des Hakens muss der Zahlenimport neu durchgeführt werden, damit die Funktion greifen kann.

Ausgabeformat für Differenzspalte

40%

60%

In Excel besteht die Möglichkeit die Differenz zwischen zwei voneinander abhängigen Perioden automatisch berechnen zu lassen. Hierzu wird in Excel über das Kontextmenü die „difference"-Spalten programmiert. In den Einstellungen kann ausgewählt werden, ob die Differenz in absoluten Werten (Betrag) angegeben werden soll oder mit umgekehrten Vorzeichen bzw. dem tatsächlichen Differenz-Wert.

Einstellung für die Berechnung der Prozentwerte

40%

60%

In den „Einstellung für die Berechnung der Prozentwerte“ kann eingestellt werden, ob die Prozentwerte auf Basis der gerundeten oder der exakten Werte berechnet werden sollen. Weiterhin kann festgelegt werden, welcher Text bei Werten größer oder kleiner eines gewissen Schwellenwerts oder bei einer Division durch Null angezeigt werden sollen [Exaktspalte festlegen].

Die Exaktspalte ist eine optionale Spalte. Sie gibt den exakten Wert des gewünschten importiertes Wertes wieder. Sie kann flexibel nach Auswahl der gewünschten Spalte über das SmartNotes Ribbon gesetzt werden.

40%

60%

Inhaltlich gibt sie den genauen Wert des entsprechenden Datensatzes wieder. Im gegebenen Beispiel den exakten Wert der Value 1 für die aktuelle Periode.

40%

60%

Um die Exact-Spalte auch im Rundungsassistenten sichtbar zu machen, müssen zunächst die Datailinformationen eingeblendet werden. Die Exactspalte erscheint dann ganz recht im Rundungsassistenten. Dabei werden sowohl die exakten importierten Werte als auch die exakten Summen angezeigt. Da es sich bei diesen Werten um importierte Werte aus den Vorsystemen handelt, sind manuelle Anpassungen sowie Änderungen in dieser Spalte nicht möglich.

Nachdem erneut Daten der selben Positionen aus dem Vorsystemen eingeladen werden, können im Rundungsassistenten die Veränderung der Werte gegenüber dem ersten Import in der Spalte ,,Alter Wert“ eingesehen werden. Die Dateilinformationen zu der Exact-Spalte können flexibel im Rundungsformular über den Button ,, Details ein- /ausblenden“ ausgeblendet werden.

Button „Excel Processing Einstellungen“

40%

60%

Mit diesen Einstellungen kann die Aisführung von externen Excel-Makros verwaltet werden.

„OnProcessing“ bedeutet, dass die Funktion ausgeführt wird, nachdem der Listeintrag „Ausführen Excel Bearbeitung“ getätigt wurde.

„OnOpen“ bedeutet, dass die Funktion ausgeführt wird, nachdem die Excel-Datei geöffnet wurde [hier im Beispiel].

„OnCheckin“ bedeutet, dass die Funktion ausgeführt wird, nachdem die Excel-Datei eingecheckt wurde.

Welche Funktion ausgeführt werden soll muss in der Eingabezeile hinterlegt werden.

Eine genaue Beschreibung mit Beispiel zum Nachstellen finden Sie in dem Kapitel .

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Checkbox „Erweiterte Excel-Programmierung: Legacy Modus aktivieren“"}},"macroMetadata":{"macroId":{"value":"6f88df69-3028-40b0-8fa5-ffe07054d58e"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

Diese Funktion greift auch bei den jeweils englischen Begriffen „DEBIT" und „CREDIT" und damit auch auf die englischen Kürzel „D" und „C".

Nach Setzen des Hakens muss der Zahlenimport neu durchgeführt werden, damit die Funktion greifen kann.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"722ad9f0-4fb2-4731-9d73-84152c6e8ce2"},"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%

Diese Funktion greift auch bei den jeweils englischen Begriffen „DEBIT" und „CREDIT" und damit auch auf die englischen Kürzel „D" und „C".

Nach Setzen des Hakens muss der Zahlenimport neu durchgeführt werden, damit die Funktion greifen kann.

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"8bb7edd8-9800-4b73-9cb4-f67fe7074e5c"},"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":"32f913b9-5aea-4835-8d7d-f6707b1cdc37"},"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%

Inhaltlich gibt sie den genauen Wert des entsprechenden Datensatzes wieder. Im gegebenen Beispiel den exakten Wert der Value 1 für die aktuelle Periode.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"a5371154-5a15-47e0-8d3f-b2ee8df46d72"},"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%

Inhaltlich gibt sie den genauen Wert des entsprechenden Datensatzes wieder. Im gegebenen Beispiel den exakten Wert der Value 1 für die aktuelle Periode.

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"1a0aa2cf-dd79-47d7-87b8-75a5e6b7c792"},"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 diesen Einstellungen kann die Aisführung von externen Excel-Makros verwaltet werden.

„OnProcessing“ bedeutet, dass die Funktion ausgeführt wird, nachdem der Listeintrag „Ausführen Excel Bearbeitung“ getätigt wurde.

„OnOpen“ bedeutet, dass die Funktion ausgeführt wird, nachdem die Excel-Datei geöffnet wurde [hier im Beispiel].

„OnCheckin“ bedeutet, dass die Funktion ausgeführt wird, nachdem die Excel-Datei eingecheckt wurde.

Welche Funktion ausgeführt werden soll muss in der Eingabezeile hinterlegt werden.

Eine genaue Beschreibung mit Beispiel zum Nachstellen finden Sie in dem Kapitel .

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"fdc1eaaa-49c6-4e61-aed5-ec0d607a68d3"},"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 diesen Einstellungen kann die Aisführung von externen Excel-Makros verwaltet werden.

„OnProcessing“ bedeutet, dass die Funktion ausgeführt wird, nachdem der Listeintrag „Ausführen Excel Bearbeitung“ getätigt wurde.

„OnOpen“ bedeutet, dass die Funktion ausgeführt wird, nachdem die Excel-Datei geöffnet wurde [hier im Beispiel].

„OnCheckin“ bedeutet, dass die Funktion ausgeführt wird, nachdem die Excel-Datei eingecheckt wurde.

Welche Funktion ausgeführt werden soll muss in der Eingabezeile hinterlegt werden.

Eine genaue Beschreibung mit Beispiel zum Nachstellen finden Sie in dem Kapitel .

40%

60%

Die Überschrift „Sprachabhängige Einstellungen“ ist mit einem in Klammern geschriebenen Sprachzusatz versehen [z.B. „[Deutsch]“]. Dieser stellt die aktuell im SmartNotes Cockpit verwendete Sprachversion dar und wird in Abhängigkeit von der genutzten Dokumentsprache vergeben. Die sprachabhängigen Einstellungen können also für jede Dokumentsprache einzeln vorgenommen werden. Sollen Einstellungen für eine andere Sprache getätigt werden, so muss zunächst die aktuelle Dokumentsprache gewechselt werden.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"1f53dbaf-533d-4466-bc90-ace664b4408b"},"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%

Bei den sprachabhängigen Einstellungen können für die in dem SmartNotes-Dokument verwendeten Excel-Dateien über den Button „Abkürzungseinstellungen“ Abkürzungen für Einheiten definiert werden. Es öffnet sich ein Assistent, in dem die Abkürzungen frei bestimmt werden können.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Abkürzungseinstellungen"}},"macroMetadata":{"macroId":{"value":"efb1dece-3408-4db9-bd84-6646596af842"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"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":"822aef93-7b1b-45d9-af38-bec8e86c20e3"},"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%

Die benutzerdefinierte Ausgabe- und Zahlenformate können jederzeit flexibel für die gewünschten Kapitel zurückgesetzt werden. Hierzu wird im Cockpit das Kaptiel gewählt, indem die Ausgaben- und Zahlenformate zurückgesetzt werden soll und mit einem Rechtsklick in den markierten Kapitel das Kontextmenü aufgerufen. Hierbei wird nicht das Ausgabe- und Zahlenformat der Excel-Datei zurückgesetzt, sondern nur individuell definierte Ausgabe- und Zahlenformate auf Berichtsdatenebene, sofern diese von der Formatierung der Excel-Datei abweichen.

Neben der Möglichkeit die Ausgaben- und Zahlenformate auf der Kapitelebene zurückzusetzen, ist es auch möglich, das ganze auf der Dokumentebene für das gesamte Dokument zurückzusetzen. Der Assistent für das Zurücksetzten von Ausgaben- und Zahlenformaten befindet sich unter dem Menüpunkt ,,Dokument‘‘ und kann mit dem Unterpunkt ,,Einstellungen‘‘ aufgerufen werden. Die globalen Einstellungen für Excel findet sich unter dem Reiter ,,Excel Einstellungen“. Über den Button ,,Reset Output and Number Format for Report Data“ lassen sich dann die gesamten Ausgabe- sowie Zahlenformate für das Dokument zurücksetzen.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Ausgabe- und Zahlenformat zurücksetzen"}},"macroMetadata":{"macroId":{"value":"e061435e-ea3a-421f-80fb-cd8567d033c7"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"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":"b80980c5-e199-47df-a4ec-d742484d5724"},"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":"6be19430-e6df-4c24-9530-5956feb7aaf2"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":"Die benutzerdefinierte Ausgabe- und Zahlenformate können jederzeit flexibel für die gewünschten Kapitel zurückgesetzt werden. Hierzu wird im Cockpit das Kaptiel gewählt, indem die Ausgaben- und Zahlenformate zurückgesetzt werden soll und mit einem Rechtsklick in den markierten Kapitel das Kontextmenü aufgerufen. Hierbei wird nicht das Ausgabe- und Zahlenformat der Excel-Datei zurückgesetzt, sondern nur individuell definierte Ausgabe- und Zahlenformate auf Berichtsdatenebene, sofern diese von der Formatierung der Excel-Datei abweichen.","type":"text"}]},{"type":"paragraph","content":[{"text":"Neben der Möglichkeit die Ausgaben- und Zahlenformate auf der Kapitelebene zurückzusetzen, ist es auch möglich, das ganze auf der Dokumentebene für das gesamte Dokument zurückzusetzen. Der Assistent für das Zurücksetzten von Ausgaben- und Zahlenformaten befindet sich unter dem Menüpunkt ,,Dokument‘‘ und kann mit dem Unterpunkt ,,Einstellungen‘‘ aufgerufen werden. Die globalen Einstellungen für Excel findet sich unter dem Reiter ,,Excel Einstellungen“. Über den Button ,,Reset Output and Number Format for Report Data“ lassen sich dann die gesamten Ausgabe- sowie Zahlenformate für das Dokument zurücksetzen.","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"}]}]}],"version":1},"reason":"A panel 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":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Hinweis: Die Einstellungen für Excel werden dokumentweit angewendet d.h. sie gelten nur für das aktuelle SmartNotes-Dokument. Sind in ein anderes SmartNotes-Dokument Änderungen gewünscht, so müssen diese Einstellungen im nächsten Dokument erneut angepasst werde","type":"text"}]}]},{"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":"1484d6c9-ba7a-45ae-8ca7-02a0dfaffba7"},"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":"659acf23-1723-4a9d-aba1-b82f83f54323"},"content":[{"type":"table","attrs":{"layout":"default","localId":"934e8fb4-069c-489b-9d81-ac740486b160"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[1766.0]},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Language Invariant Settings","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%

60%

Language-independent settings are not language-specific, but are made independently of the current document language and are applied across all languages of a SmartNotes document.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"93c5f921-e673-4502-a21c-de442ca5f7f7"},"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%

Language-independent settings are not language-specific, but are made independently of the current document language and are applied across all languages of a SmartNotes document.

40%

60%

In the language-independent settings, an Excel style sheet can be stored for the Excel files used in the SmartNotes document via the button "Add Excel Format Master". The button "Edit Excel Format Mastert" can be used to directly edit a stored Excel style sheet.

Most tables within a report can be derived from four to five different basic structures. Therefore, SmartNotes offers a simple possibility to layout these basic structures within a format template and then make them available within a report. This also ensures that all tables in a report follow a uniform format and layout.

Once a format master has been created, it is also available within a document when the document is updated.

It is advisable to define the following properties centrally in the model tables of the format master:

Background colours
Font type, size and colour
Number formatting
Table frames
Character style [e.g. bold, italic]
Column widths
Line heights

Adding a style sheet: To create or add an Excel format master, use the "Add Excel Format Master" button in the SmartNotes Document Settings for Excel.

This brings up a Windows Explorer window that can be used to save an existing Excel style sheet [e.g. an Excel document with the desired corporate design] or a previously saved Excel document that is to be adapted and used as a [future] style sheet.

The successful addition of the style template is confirmed with the "Success" dialogue.

Edit Excel Format Master: To edit an Excel format master , use the button "Edit Excel Format Master" in the SmartNotes document settings for Excel. This opens the stored style template in Excel and can then be edited.

Delete Excel Format Master: To delete an Excel format master, use the button "Delete Excel Format Master" in the document settings. This button only appears if an Excel style sheet has already been saved and replaces the original button "Add Excel style sheet".

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Add Excel Format Master"}},"macroMetadata":{"macroId":{"value":"3dd8fc89-6b37-4a7d-a898-25f624a61f21"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

Once a format master has been created, it is also available within a document when the document is updated.

It is advisable to define the following properties centrally in the model tables of the format master:

Background colours
Font type, size and colour
Number formatting
Table frames
Character style [e.g. bold, italic]
Column widths
Line heights

Adding a style sheet: To create or add an Excel format master, use the "Add Excel Format Master" button in the SmartNotes Document Settings for Excel.

The successful addition of the style template is confirmed with the "Success" dialogue.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"941c6356-dd9d-4626-b689-36d0882d9d45"},"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%

Once a format master has been created, it is also available within a document when the document is updated.

It is advisable to define the following properties centrally in the model tables of the format master:

Background colours
Font type, size and colour
Number formatting
Table frames
Character style [e.g. bold, italic]
Column widths
Line heights

Adding a style sheet: To create or add an Excel format master, use the "Add Excel Format Master" button in the SmartNotes Document Settings for Excel.

The successful addition of the style template is confirmed with the "Success" dialogue.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"60%"}},"macroMetadata":{"macroId":{"value":"aaf432a9-226f-48e9-a9c1-7d16ecaed24b"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":"In the language-independent settings, an Excel style sheet can be stored for the Excel files used in the SmartNotes document via the button \"Add Excel Format Master\". The button \"Edit Excel Format Mastert\" can be used to directly edit a stored Excel style sheet.","type":"text"}]},{"type":"paragraph","content":[{"text":"Most tables within a report can be derived from four to five different basic structures. Therefore, SmartNotes offers a simple possibility to layout these basic structures within a format template and then make them available within a report. This also ensures that all tables in a report follow a uniform format and layout.","type":"text"}]},{"type":"paragraph","content":[{"text":"Once a format master has been created, it is also available within a document when the document is updated.","type":"text"}]},{"type":"paragraph","content":[{"text":"It is advisable to define the following properties centrally in the model tables of the format master:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Background colours","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Font type, size and colour","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Number formatting","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Table frames","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Character style [e.g. bold, italic]","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Column widths","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Line heights","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Adding a style sheet: To create or add an Excel format master, use the \"Add Excel Format Master\" button in the SmartNotes Document Settings for Excel.","type":"text"}]},{"type":"paragraph","content":[{"text":"This brings up a Windows Explorer window that can be used to save an existing Excel style sheet [e.g. an Excel document with the desired corporate design] or a previously saved Excel document that is to be adapted and used as a [future] style sheet.","type":"text"}]},{"type":"paragraph","content":[{"text":"The successful addition of the style template is confirmed with the \"Success\" dialogue.","type":"text"}]},{"type":"paragraph","content":[{"text":"Edit Excel Format Master: To edit an Excel format master , use the button \"Edit Excel Format Master\" in the SmartNotes document settings for Excel. This opens the stored style template in Excel and can then be edited.","type":"text"}]},{"type":"paragraph","content":[{"text":"Delete Excel Format Master: To delete an Excel format master, use the button \"Delete Excel Format Master\" in the document settings. This button only appears if an Excel style sheet has already been saved and replaces the original button \"Add Excel style sheet\".","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"}]}]}],"version":1},"reason":"A panel macro in a table cell can't be created or edited in the new editor."}}},{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"end"}}],"content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"Checkbox "Excel Check In requires user comment"

40%

60%

The checkbox "Excel Check In requires user comment" ensures that a comment must be stored when checking in an Excel file.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Checkbox \"Excel Check In requires user comment\" "}},"macroMetadata":{"macroId":{"value":"06173034-c3f1-4739-a42c-7cd261683775"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

The checkbox "Excel Check In requires user comment" ensures that a comment must be stored when checking in an Excel file.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"2e13fed8-819a-47ef-9370-9b11c62b7e5f"},"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 checkbox "Excel Check In requires user comment" ensures that a comment must be stored when checking in an Excel file.

40%

60%

By activating the checkbox "Allow comments to write-protected Excel files", Office documents can be commented on despite a read permission. When closing a read-only document, a window similar to the CheckIn window appears in which the user can write a comment. This is displayed in the chapter history.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Checkbox \"Allow comments to write-protected Excel files\""}},"macroMetadata":{"macroId":{"value":"99677faa-4b72-4c09-b490-e98f055a0158"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"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":"aedf44f9-3ed6-4c8e-ac12-c5f123069d73"},"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%

The checkbox "Excel delete requires user comment" requires that a comment must be stored when deleting an Excel file.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Checkbox \"Excel delete requires user comment\""}},"macroMetadata":{"macroId":{"value":"a5a65d43-8784-4cf2-a66a-c2f651fcdef6"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

The checkbox "Excel delete requires user comment" requires that a comment must be stored when deleting an Excel file.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"169787c6-2810-447b-8fec-04f96c299ac5"},"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 checkbox "Excel delete requires user comment" requires that a comment must be stored when deleting an Excel file.

40%

60%

The "output format" of the Excel tables of a document can be set centrally, e.g. to Mio. Deviations from the central output format can be set when checking in an Excel file. Excel files that were already formatted before the central number format was set retain their original format.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Output format"}},"macroMetadata":{"macroId":{"value":"f98c6ee6-f184-49ee-b87c-7717da5f8e7b"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"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":"c789f000-8825-41b6-bca4-172f1159db9f"},"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%

With the help of the "Number formatting", the standard formatting for values in Excel tables is defined and the number of decimal places with which SmartNotes calculates. A left click in the input field opens the assistant for number formatting, which also offers a preview function. The format of the entry corresponds to the manual format adjustment in Excel:

#,0 Number with thousands separator and without decimal place
#,0.# Number with thousands separator and one decimal place
#,0.## Number with thousands separator and two decimal places

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Number format"}},"macroMetadata":{"macroId":{"value":"87f329f9-90ec-4891-bb24-fd94e13610a8"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

#,0 Number with thousands separator and without decimal place
#,0.# Number with thousands separator and one decimal place
#,0.## Number with thousands separator and two decimal places

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"ef358e92-5fcd-4a5a-a425-bada6561986b"},"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%

#,0 Number with thousands separator and without decimal place
#,0.# Number with thousands separator and one decimal place
#,0.## Number with thousands separator and two decimal places

40%

60%

A value can be determined from which a rounding in percent must be commented obligatorily.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Comment required rounding percentage"}},"macroMetadata":{"macroId":{"value":"5d38dfcc-0674-450d-ae32-e8cbd16feaa9"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

A value can be determined from which a rounding in percent must be commented obligatorily.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"b62062fa-641f-46f9-b053-1648cb4683eb"},"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%

A value can be determined from which a rounding in percent must be commented obligatorily.

40%

60%

A value can be defined from which an absolute rounding must be commented.

In the current SmartNotes version, non-integer values are also allowed for the comment obligation of absolute rounding.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Comment required absolute rounding"}},"macroMetadata":{"macroId":{"value":"bf4151f4-ba4a-4a14-addf-5ef4133ac065"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

A value can be defined from which an absolute rounding must be commented.

In the current SmartNotes version, non-integer values are also allowed for the comment obligation of absolute rounding.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"6dda0557-97be-4995-a906-32befe1b9f54"},"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%

A value can be defined from which an absolute rounding must be commented.

In the current SmartNotes version, non-integer values are also allowed for the comment obligation of absolute rounding.

40%

60%

The checkbox "Apply Layout Ranges on Check Out" ensures that the layout areas [layout actions] defined in the style sheet are automatically applied to the Excel documents in which their use is intended at each checkout. It should be noted that the use of the layout actions for each checkout of Excel files can be performance-intensive.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Checkbox \"Apply Layout Ranges on Check Out\""}},"macroMetadata":{"macroId":{"value":"e5883e0d-5867-4e42-81c5-df91abcfaf21"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"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":"aee83ae8-cbd3-4e37-a25a-4a17859af4f0"},"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%

The checkbox "Distinguish exact from rounded zero" makes it possible to distinguish a "false zero", i.e. a number that is zero when rounded down, from a "real zero" (0). To do this, a tiny little value (10^-6) is added to a "false zero" and real zeros remain zero. Thus, for example, a "#.##0;-#.##0;-" formatting will show a "0" for the fake zeros and a dash "-" for the real zeros.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Checkbox \"Distinguish exact from rounded zeroes\""}},"macroMetadata":{"macroId":{"value":"97960984-e87f-4de4-b0e2-ee9a4c5ec90a"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"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":"ad43fccf-b0dd-4821-8e73-c104b913253f"},"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%

The checkbox "Allow advanced Excel programming to this document" makes the following functions available in the programming column [the listing is done with the help of example accounts]:

DEBIT(4711;4712): the values of accounts 4711+4712 flow into the total if they are postitive.
CREDIT(4711): The value column only contains a value if it is negative.

This function works with the English terms "Debit" and "Credit" as well as with the German terms "Soll" and "Haben".

After setting the checkmark, the number import must be carried out again so that the function can take effect.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Checkbox \"Allow advanced Excel programming to this document\""}},"macroMetadata":{"macroId":{"value":"8cfa3637-4ac6-42a9-b283-9eeda34fa79b"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

The checkbox "Allow advanced Excel programming to this document" makes the following functions available in the programming column [the listing is done with the help of example accounts]:

DEBIT(4711;4712): the values of accounts 4711+4712 flow into the total if they are postitive.
CREDIT(4711): The value column only contains a value if it is negative.

This function works with the English terms "Debit" and "Credit" as well as with the German terms "Soll" and "Haben".

After setting the checkmark, the number import must be carried out again so that the function can take effect.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"b8b0c8b8-0b9b-4d3f-be4e-1a826aa19600"},"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 checkbox "Allow advanced Excel programming to this document" makes the following functions available in the programming column [the listing is done with the help of example accounts]:

DEBIT(4711;4712): the values of accounts 4711+4712 flow into the total if they are postitive.
CREDIT(4711): The value column only contains a value if it is negative.

This function works with the English terms "Debit" and "Credit" as well as with the German terms "Soll" and "Haben".

After setting the checkmark, the number import must be carried out again so that the function can take effect.

40%

60%

The checkbox "Use legacy mode for advanced Excel programming" is an additional function to supplement the advanced Excel programming. With this function, all account numbers that begin or end with an D or C are evaluated as debit/credit programming. This means that it is no longer necessary to add "DEBIT" or "CREDIT" to the account numbers.

This function also applies to the German terms "SOLL" and "HABEN" and thus also to the German abbreviations "S" and "H".

With this option, all account numbers beginning with "S" or "H" as well as "D" or "C" or ending with these letters are evaluated as debit or credit. This also includes, for example, account numbers such as "Konzernergebnis" or "Dividents".

After setting the checkmark, the number import must be carried out again so that the function can take effect.

Output format for difference column

40%

60%

In Excel it is possible to automatically calculate the difference between two dependent periods. To do this, the "difference" columns are programmed in Excel via the context menu. In the settings it can be selected whether the difference is to be given in absolute values (amount) or with reversed sign or the actual difference value.

Percentage Calculation Settings

40%

60%

In the "Percentage Calculation Settings" you can set whether the percentage values are to be calculated on the basis of the rounded or the exact values. Furthermore, it can be determined which text is to be displayed for values larger or smaller than a certain threshold value or for a division by zero [Set Exact Column].

The exact column is an optional column. It shows the exact value of the desired imported value. It can be set flexibly after selecting the desired column via the SmartNotes Ribbon.

40%

60%

In terms of content, it reflects the exact value of the corresponding data set. In the given example, the exact value of Value 1 for the current period.

40%

60%

To make the Exact column visible in the Data View, the data information must first be displayed. The Exact column then appears on the far right in the Data View. Both the exact imported values and the exact totals are displayed. As these values are imported values from the previous systems, manual adjustments and changes in this column are not possible.

After reloading data of the same positions from the previous systems, the change of the values compared to the first import can be seen in the column "Old value" in the Data View. The file information for the Exact column can be flexibly hidden in the Data View via the button "Show/Hide details".

Button "Excel Processing Einstellungen“

40%

60%

With these settings, the execution of external Excel macros can be managed.

"OnProcessing" means that the function is executed after the list entry "Execute Excel Processing" has been made.
"OnOpen" means that the function is executed after the Excel file has been opened [here in the example].
"OnCheckin" means that the function is executed after the Excel file has been checked in.

Which function is to be executed must be stored in the input line.

You can find a detailed description with an example in the chapter .

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Checkbox \"Use legacy mode for advanced Excel programming\""}},"macroMetadata":{"macroId":{"value":"5aefa0c3-142a-4429-8f0e-e873b1ff2d35"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

This function also applies to the German terms "SOLL" and "HABEN" and thus also to the German abbreviations "S" and "H".

After setting the checkmark, the number import must be carried out again so that the function can take effect.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"d7af1e08-3c93-4e36-967e-d537123b108a"},"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 also applies to the German terms "SOLL" and "HABEN" and thus also to the German abbreviations "S" and "H".

After setting the checkmark, the number import must be carried out again so that the function can take effect.

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"bf3f5fbd-d14e-4a40-a9c7-018a5276e331"},"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%

The exact column is an optional column. It shows the exact value of the desired imported value. It can be set flexibly after selecting the desired column via the SmartNotes Ribbon.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"1fb6702b-a3b8-4e77-951b-2e86683da150"},"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 exact column is an optional column. It shows the exact value of the desired imported value. It can be set flexibly after selecting the desired column via the SmartNotes Ribbon.

40%

60%

In terms of content, it reflects the exact value of the corresponding data set. In the given example, the exact value of Value 1 for the current period.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"1bb666df-eb07-482f-a8c2-8cd29fb1cf2e"},"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 terms of content, it reflects the exact value of the corresponding data set. In the given example, the exact value of Value 1 for the current period.

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"f61a2bcd-088c-4594-b6a6-ab15390c6408"},"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%

With these settings, the execution of external Excel macros can be managed.

"OnProcessing" means that the function is executed after the list entry "Execute Excel Processing" has been made.
"OnOpen" means that the function is executed after the Excel file has been opened [here in the example].
"OnCheckin" means that the function is executed after the Excel file has been checked in.

Which function is to be executed must be stored in the input line.

You can find a detailed description with an example in the chapter .

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"d15a9ea3-5a76-4a67-a718-50acf60fdd46"},"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%

With these settings, the execution of external Excel macros can be managed.

"OnProcessing" means that the function is executed after the list entry "Execute Excel Processing" has been made.
"OnOpen" means that the function is executed after the Excel file has been opened [here in the example].
"OnCheckin" means that the function is executed after the Excel file has been checked in.

Which function is to be executed must be stored in the input line.

You can find a detailed description with an example in the chapter .

40%

60%

The heading "Language-dependent settings" is provided with a language suffix written in brackets [e.g. "[German]"]. This represents the language version currently used in the SmartNotes Cockpit and is assigned depending on the document language used. The language-dependent settings can therefore be made individually for each document language. If settings are to be made for another language, the current document language must first be changed.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"005e1aa8-daa0-4ba7-9894-df49ace36eef"},"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%

In the language-dependent settings, abbreviations for units can be defined for the Excel files used in the SmartNotes document via the button "Abbreviation settings". An assistant opens in which the abbreviations can be freely defined.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Abbreviation Settings"}},"macroMetadata":{"macroId":{"value":"768b3cbd-a78b-44fc-ad3d-9a8074e30b14"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"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":"ee5b2583-9967-464b-b925-4f90533c9adf"},"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%

The user-defined output and number formats can be flexibly reset for the desired chapters at any time. To do this, select the chapter in the cockpit in which the output and number formats are to be reset and call up the context menu by right-clicking in the selected chapter. This does not reset the output and number format of the Excel file, but only individually defined output and number formats on the report data level, if these differ from the formatting of the Excel file.

In addition to the possibility of resetting the output and number formats at the chapter level, it is also possible to reset the whole thing at the document level for the entire document. The wizard for resetting output and number formats can be found under the menu item 'Document' and can be called up with the sub-item 'Settings'. The global settings for Excel can be found under the tab "Excel settings". The button "Reset Output and Number Format for Report Data" can be used to reset the entire output and number formats for the document.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Reset Output and NumberFormat for ReportData"}},"macroMetadata":{"macroId":{"value":"7597a760-acfa-4362-bb0f-1eb9bd46cd48"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"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":"9498f036-5c51-42f4-8ef6-712949edf027"},"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":"5240cd0a-67df-45c9-bf3b-d7606cb6e658"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":"The user-defined output and number formats can be flexibly reset for the desired chapters at any time. To do this, select the chapter in the cockpit in which the output and number formats are to be reset and call up the context menu by right-clicking in the selected chapter. This does not reset the output and number format of the Excel file, but only individually defined output and number formats on the report data level, if these differ from the formatting of the Excel file.","type":"text"}]},{"type":"paragraph","content":[{"text":"In addition to the possibility of resetting the output and number formats at the chapter level, it is also possible to reset the whole thing at the document level for the entire document. The wizard for resetting output and number formats can be found under the menu item 'Document' and can be called up with the sub-item 'Settings'. The global settings for Excel can be found under the tab \"Excel settings\". The button \"Reset Output and Number Format for Report Data\" can be used to reset the entire output and number formats for the document.","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"}]}]}],"version":1},"reason":"A panel 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":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Note: The settings for Excel are applied document-wide, i.e. they only apply to the current SmartNotes document. If changes are desired in another SmartNotes document, these settings must be adjusted again in the next document.","type":"text"}]}]},{"type":"paragraph"}]},{"type":"paragraph"},{"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":"fa269314-1efb-44da-bb52-f140fa15e1c0"},"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":"c92de00e-2269-4116-bfce-f7bff0ab861e"},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"1f310","text":"🌐","shortName":":globe_with_meridians:"}},{"text":" ","type":"text"},{"text":"Einstellungen","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6231676"}}]}]}]}]}]},{"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":"cefabbb8-bd9e-44e7-b1a7-0a1e31d30d92"},"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":"522fb400-3fae-488e-8012-4f821bca44cb"},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"1f310","text":"🌐","shortName":":globe_with_meridians:"}},{"text":" ","type":"text"},{"text":"Settings","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6231676"}}]}]}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}],"version":1}

Browser not supported