40%

60%

Setzen Sie bitte in den erweiterten Excel-Einstellungen das Häkchen „Excel-Formate mit LAR automatisch anwenden“.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"c4d44e32-3815-4d03-946c-b28bfc170a55"},"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%

Setzen Sie bitte in den erweiterten Excel-Einstellungen das Häkchen „Excel-Formate mit LAR automatisch anwenden“.

40%

60%

Legen Sie dann in einem Excel-Schnipsel eine Zellformatvorlage an , die genauso heißt, wie ein LAR-Bereich.

In dem Beispiel haben wir eine Zellformatvorlage mit dem Namen „lar_total“ angelegt, die so definiert ist., dass der Zell-Hintergrund rot ist.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"2813a416-a3a2-497c-b826-4dc5cfabf42e"},"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%

Legen Sie dann in einem Excel-Schnipsel eine Zellformatvorlage an , die genauso heißt, wie ein LAR-Bereich.

In dem Beispiel haben wir eine Zellformatvorlage mit dem Namen „lar_total“ angelegt, die so definiert ist., dass der Zell-Hintergrund rot ist.

40%

60%

Wenn Sie dann einem Bereich in Excel per SmartNotes Menu den LayoutRange lar_total zuweisen, wird das Zellformat automatisch angewendet.

Man kann die Zellformate nicht zentral definieren, sondern muss das eigentlich in jedem Schnipsel tun.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"2d4870bc-71ea-4502-ae97-5a8b98048ae0"},"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%

Wenn Sie dann einem Bereich in Excel per SmartNotes Menu den LayoutRange lar_total zuweisen, wird das Zellformat automatisch angewendet.

Man kann die Zellformate nicht zentral definieren, sondern muss das eigentlich in jedem Schnipsel tun.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"60%"}},"macroMetadata":{"macroId":{"value":"0832ea37-a955-4764-a4ce-6c5a381ada92"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":"Wenn Sie dann einem Bereich in Excel per SmartNotes Menu den LayoutRange lar_total zuweisen, wird das Zellformat automatisch angewendet.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#3d454c"}}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Man kann die Zellformate nicht zentral definieren, sondern muss das eigentlich in jedem Schnipsel tun.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#3d454c"}}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1}}}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1660176000000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Word","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"Beim Wechsel zwischen DE und EN passiert das oft, dass Dezimal- und Tausendertrennzeichen nicht richtig angezeigt werden.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#3d454c"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"nestedExpand","attrs":{"title":"Mit der folgenden Einstellung funktioniert es ..."},"content":[{"type":"mediaSingle","attrs":{"layout":"align-start","width":30.0},"content":[{"type":"media","attrs":{"width":1031,"id":"aad9a25b-4f08-4b5a-9542-f91f1befb726","collection":"contentId-6237738","type":"file","height":711}}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1659052800000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Validierungen","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"Finden Vorzeichen ","type":"text","marks":[{"type":"strong"}]},{"text":"bei Validierungen Berücksichtigung?","type":"text","marks":[{"type":"textColor","attrs":{"color":"#3d454c"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"nestedExpand","attrs":{"title":"Lesen Sie mehr dazu ..."},"content":[{"type":"paragraph","content":[{"text":"Nein. Man validiert in der Regel jede Tabelle aus den Notes gegen Bilanz und GuV. Dabei sind dann auch viele Tabellen, in denen Aufwände erklärt werden, z.B. sonstige betriebliche Aufwände.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#3d454c"}}]},{"type":"hardBreak"},{"text":"Während in den Notes die Aufwände meistens vorzeichenlos dargestellt werden, wird der Aufwand meistens mit negativem Vorzeichen dargestellt (dort sind Aufwände und Erträge gemischt).","type":"text","marks":[{"type":"textColor","attrs":{"color":"#3d454c"}}]},{"type":"hardBreak"},{"text":"Damit das schnell validieren kann, ignoriert SN immer schon die Vorzeichen bei der Validierung.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#3d454c"}}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1659052800000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Word","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"Word Rechtschreibung und Grammatik","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Lesen Sie im folgenden Kapitel mehr dazu ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237900"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1658966400000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Word","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"Wie kann ich Seitenzahlen mit führender 0 einstellen?","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"nestedExpand","attrs":{"title":"Lesen Sie mehr dazu ..."},"content":[{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

Seitenzahl wie gewohnt einfügen
Seitenzahl markieren
Mit der Tastenkombination <Alt>+<F9> die Feldfunktion anzeigen lassen
Diese sieht dann so aus: {PAGE   \\* MERGEFORMAT}
Diese können Sie dann z.B. in {PAGE   \\# "000 " MERGEFORMAT} ändern.
Erneut <Alt+F9> um die Seitenzahlen wieder anzeigen zu lassen

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Seitenzahl wie gewohnt einfügen","type":"text","marks":[{"type":"textColor","attrs":{"color":"#3d454c"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Seitenzahl markieren","type":"text","marks":[{"type":"textColor","attrs":{"color":"#3d454c"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Mit der Tastenkombination + die Feldfunktion anzeigen lassen","type":"text","marks":[{"type":"textColor","attrs":{"color":"#3d454c"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Diese sieht dann so aus: {PAGE   \\* MERGEFORMAT}","type":"text","marks":[{"type":"textColor","attrs":{"color":"#3d454c"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Diese können Sie dann z.B. in {PAGE   \\# \"000 \" MERGEFORMAT} ändern.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#3d454c"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Erneut um die Seitenzahlen wieder anzeigen zu lassen","type":"text","marks":[{"type":"textColor","attrs":{"color":"#3d454c"}}]}]}]}]}],"version":1}}}}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1655164800000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"MIP","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"Kann ich in SmartNotes die MIP Klassifizierung verwenden?","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Lesen Sie mehr dazu ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237896"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1651795200000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Ergebnisdokument","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"Meldung „Die vom Server zurückgegeben Datei konnte nicht geöffnet werden.\"","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Lesen Sie im folgenden Kapitel mehr dazu ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237884"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1651536000000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Word","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"Re-Import: Schnipsel-Zuweisung stimmt nach Re-Import nicht mehr","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt-include","parameters":{"macroParams":{"":{"value":"SND:CloudRe-import: Snippet assignment no longer correct after re-import"},"nopanel":{"value":"true"}},"macroMetadata":{"macroId":{"value":"ac075ad8-ef24-4ab8-b494-36ce58d98ee0"},"schemaVersion":{"value":"1"},"title":"Excerpt Include"}},"localId":"4e4d2f74-bef1-48a6-871e-d085f9177c3f"}}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1646956800000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Word","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"Mehrere Styles gleichzeitig aus der Formatvorlage löschen","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Lesen Sie im folgenden Kapitel mehr dazu ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237856"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1646956800000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Word","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"Gibt es eine maximale Anzahl an Styles in Word? Was passiert wenn diese erreicht ist?","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt-include","parameters":{"macroParams":{"":{"value":"CloudMaximum number of styles"},"nopanel":{"value":"true"}},"macroMetadata":{"macroId":{"value":"60653cdf-1678-414b-a013-42c773c9c463"},"schemaVersion":{"value":"1"},"title":"Excerpt Include"}},"localId":"fe2fd7cf-b187-4aa8-bb7a-40dcfb34d1f7"}}]},{"type":"paragraph","content":[{"text":"Lesen Sie im folgenden Kapitel mehr dazu ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237868"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1645488000000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Word","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"Custom XML Meldung - Wir empfehlen eine Bereinigung","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt-include","parameters":{"macroParams":{"":{"value":"CloudCustomXML Message"},"nopanel":{"value":"true"}},"macroMetadata":{"macroId":{"value":"838681c5-48ce-439a-9c9f-22d765fc8ac8"},"schemaVersion":{"value":"1"},"title":"Excerpt Include"}},"localId":"beb691df-9ece-4925-9598-a13ea4d1f9e6"}}]},{"type":"paragraph","content":[{"text":"Lesen Sie im folgenden Kapitel mehr dazu ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237840"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1642291200000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Allgemein","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"Feiertage in NRW / Servicezeiten","type":"text","marks":[{"type":"textColor","attrs":{"color":"#242424"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Mit ihrem Sitz in Essen unterliegt AMANA der gesetzlichen Feiertagsregelung in NRW","type":"text","marks":[{"type":"textColor","attrs":{"color":"#242424"}}]},{"text":". An diesen Tagen bieten wir regulär keine Servicezeiten an. ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]},{"type":"paragraph","content":[{"text":"Damit Sie sich einen Überblick machen können, um welche Tage es sich dabei handelt, haben wir für Sie einen Kalender angelegt. ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]},{"type":"paragraph","content":[{"text":"Zum Kalender Feiertage in NRW ","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237852"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1641686400000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Lizensierung","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"XBRL Lizensierung in SmartNotes","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Für den Austausch einer XBRL Lizenzdatei haben wir Ihnen eine kleine Anleitng erstellt.","type":"text"}]},{"type":"paragraph","content":[{"text":"Der Austausch einer Lizenz - z.B. vor Ablauf während eines Wartungsfensters - ist derzeit noch nicht über das SmartNotes-Menü möglich und daher noch mit etwas manuellem Aufwand verbunden.","type":"text"}]},{"type":"paragraph","content":[{"text":"Lesen Sie im folgenden Kapitel mehr dazu ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237800"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1641686400000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Lizensierung ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"So installieren oder ersetzen Sie die SmartNotes-Lizenz","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Das Ersetzen einer existierenden Lizenz kann aus verschiedenen Gründen notwendig sein","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Sie haben ein zusätzliches Modul lizensiert und möchten dieses aktivieren","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Sie möchten die bestehende Lizenz schon kurz vor Ablauf - z.B. während eines Wartungsfenster - austauschen","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Lesen Sie im folgenden Kapitel mehr dazu ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237794"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1638748800000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Installation","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"Versionsnummern","type":"text","marks":[{"type":"strong"}]},{"text":" unterscheiden einzelne Versionen einer Software, um deren Weiterentwicklungen nachvollziehbar zu kennzeichnen.","type":"text"}]},{"type":"paragraph","content":[{"text":"Eine \"neue Version\" kann also bedeuten, dass es eine neue Jahresversion gibt oder aber zu einer Jahresversion ein neues \"Bugfix Release\", also eine Fehlerkorrektur.","type":"text"}]},{"type":"paragraph","content":[{"text":"Erfahren Sie mehr zur Versionierung in SmartNotes ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237776"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1638748800000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Excel","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"Excel Processing (Makros)","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Das \"Excel-Processing\" (Excel-Bearbeitung) ist bereits seit Jahren ein Bestandteil von SmartNotes. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Durch die Umstellung auf das Format XLSX (Ab Excel 2007) hat sich jedoch der Ablauf der Bearbeitung geändert, da in XLSX-Dateien (aufgrund der Vorgabe von Microsoft) keine Makros hinterlegt werden können.","type":"text"}]},{"type":"paragraph","content":[{"text":"Mit dieser Anleitung möchten wir Ihnen zeigen, wie Sie in SmartNotes dennoch komfortabel eigene oder durch uns erstellte Makros ausführen können.","type":"text"}]},{"type":"paragraph","content":[{"text":"Lesen Sie mehr dazu ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237808"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1638748800000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Excel","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"Think-Cell","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Erfahren Sie welche Vorbereitungen für den Arbeit mit dem Think-Cell Addin zu treffen sind.","type":"text"}]},{"type":"paragraph","content":[{"text":"Lesen Sie im folgenden Kapitel mehr dazu ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237816"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1638403200000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Word","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"Neuer Word Parser und CustomXML","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Aus technischer Sicht bedeutet dies die Verarbeitung der \"X\"-Dateien. Also bei Worddateien die Endung \".docx\" statt \".doc\", bei Exceldateien die Endung \".xlsx\" statt \".xls\".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Ebenso unterscheidet sich der \"Ort\" an dem der Parser ausgeführt wird. Der alte Parser arbeitet auf dem SmartNotes-Client, der neue Parser auf dem SmartNotes-Server. ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Lesen Sie im folgenden Kapitel mehr dazu ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237786"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1638230400000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Datenbank","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"Datenbank-Skript aus der Datenbank erstellen","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Gelegentlich kann es sinnvoll sein zu prüfen, ob das Schema der Datenbank der Standardinstallation entspricht. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Mit Hilfe dieser Anleitung lässt sich ein Skript erstellen, dass die komplette Struktur einer Datenbank, jedoch keine Daten aus SmartNotes enthält. ","type":"text"}]},{"type":"paragraph","content":[{"text":"Zur Erstellung des Skriptes ist ein Zugang zum Datenbankserver über das SQL-Managementstudio notwendig.","type":"text"}]},{"type":"paragraph","content":[{"text":"Lesen Sie im folgenden Kapitel mehr dazu ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237826"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[135.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1637452800000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[127.0]},"content":[{"type":"paragraph","content":[{"text":"Datensicherheit","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1504.0]},"content":[{"type":"paragraph","content":[{"text":"Sind meine Daten verloren, wenn SmartNotes abgestürzt ist?","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt-include","parameters":{"macroParams":{"":{"value":"Clouddata loss after crash"},"nopanel":{"value":"true"}},"macroMetadata":{"macroId":{"value":"bab7b77f-35a4-4e07-96f8-a425f9d2f9ed"},"schemaVersion":{"value":"1"},"title":"Excerpt Include"}},"localId":"c5e09793-5ead-4c25-bd18-5abef8f8be58"}}]},{"type":"paragraph","content":[{"text":"Lesen Sie im folgenden Kapitel mehr dazu ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237832"}}]}]}]}]}]},{"type":"paragraph"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"bodiedExtension","attrs":{"layout":"full-width","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"english","parameters":{"macroParams":{"atlassian-macro-output-type":{"value":"INLINE"}},"macroMetadata":{"macroId":{"value":"814ee4d0-6200-4aa6-b2bc-5f16bcd9bb5d"},"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":"7e83d47a-482d-4952-bceb-b8af9c0c3b6e"},"content":[{"type":"paragraph"},{"type":"table","attrs":{"layout":"full-width","localId":"c87ffac0-e55f-4f47-9500-c5f5cf997053"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"text":"Date","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Category","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"Topic / Question","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1673395200000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"LAR","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"\"Cell Style\" function in the layout robot","type":"text","marks":[{"type":"strong"}]}]},{"type":"nestedExpand","attrs":{"title":"Read more about it ..."},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

Please set the checkmark "Assign Excel Style with LAR definition automatically" in the extended Excel settings.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"87b5a6ac-d585-429f-af80-23142beb102b"},"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%

Please set the checkmark "Assign Excel Style with LAR definition automatically" in the extended Excel settings.

40%

60%

Then create a cell style in an Excel snippet that has the same name as a LAR range.

In the example we have created a cell style called "lar_total" which is defined so that the cell background is red.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"b7eeff39-1fb7-4a3d-93cb-5faa74136632"},"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%

Then create a cell style in an Excel snippet that has the same name as a LAR range.

In the example we have created a cell style called "lar_total" which is defined so that the cell background is red.

40%

60%

If you then assign the LayoutRange lar_total to a range in Excel via SmartNotes Menu, the cell format is automatically applied.

You cannot define the cell formats centrally, but actually have to do this in each snippet.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"85f6abd0-d7df-4e70-b7fd-ec24053693e4"},"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%

If you then assign the LayoutRange lar_total to a range in Excel via SmartNotes Menu, the cell format is automatically applied.

You cannot define the cell formats centrally, but actually have to do this in each snippet.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"60%"}},"macroMetadata":{"macroId":{"value":"43d924bb-d3a1-4f03-aa50-ba6b0fafd183"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":"If you then assign the LayoutRange lar_total to a range in Excel via SmartNotes Menu, the cell format is automatically applied.","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"You cannot define the cell formats centrally, but actually have to do this in each snippet.","type":"text"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1}}}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1660176000000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Word","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"When switching between DE and EN, it often happens that decimal and thousand separators are not displayed correctly.","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"nestedExpand","attrs":{"title":"With the following setting it works ..."},"content":[{"type":"mediaSingle","attrs":{"layout":"align-start","width":30.0},"content":[{"type":"media","attrs":{"width":1280,"id":"65a050a9-d3df-4ba6-89e8-b921c7b4bad6","collection":"contentId-6237738","type":"file","height":1123}}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1659052800000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Validations","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"Are signs taken into account in validations?","type":"text","marks":[{"type":"strong"}]}]},{"type":"nestedExpand","attrs":{"title":"Read more ..."},"content":[{"type":"paragraph","content":[{"text":"No. As a rule, every table from the notes is validated against the balance sheet and income statement. This also includes many tables in which expenses are explained, e.g. other operating expenses.","type":"text"},{"type":"hardBreak"},{"text":"Whereas in the notes the expenses are usually shown unsigned, the expenses are usually shown with a negative sign (expenses and income are mixed there).","type":"text"},{"type":"hardBreak"},{"text":"In order to validate this quickly, SN always ignores the sign during validation.","type":"text"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1659052800000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Word ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"Word Spelling and Grammar","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Read more about this in the following chapter ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237900"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1658966400000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Word","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"How can I set page numbers with leading 0?","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"nestedExpand","attrs":{"title":"Read more ..."},"content":[{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

Insert page number as usual
Mark page number
Press <Alt>+<F9> to display the field function.
This will look like this: {PAGE \\* MERGEFORMAT}
You can then change this to {PAGE \\# "000 " MERGEFORMAT}, for example.
Press <Alt+F9> again to display the page numbers again.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Insert page number as usual","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Mark page number","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Press + to display the field function.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"This will look like this: {PAGE \\* MERGEFORMAT}","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"You can then change this to {PAGE \\# \"000 \" MERGEFORMAT}, for example.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Press again to display the page numbers again.","type":"text"}]}]}]}],"version":1}}}}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1655164800000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"MIP","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"Can I use the MIP classification in SmartNotes?","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Read more about this in the following chapter ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237896"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1651795200000"}},{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Result Document","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"Message \"Die vom Server zurückgegeben Datei konnte nicht geöffnet werden.\"","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":" ","type":"text"},{"text":"Read more about it ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237884"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1651536000000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Word","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"Re-import: Snippet assignment no longer correct after re-import","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt-include","parameters":{"macroParams":{"":{"value":"SND:CloudRe-import: Snippet assignment no longer correct after re-import"},"nopanel":{"value":"true"}},"macroMetadata":{"macroId":{"value":"66e99e2d-3b44-47f4-9b06-1858e49975da"},"schemaVersion":{"value":"1"},"title":"Excerpt Include"}},"localId":"3d28ca23-488e-406d-a9fb-e816d4dfed26"}}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1646956800000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Word","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"Delete several styles from the layout master","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Read more about this in the following chapter ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237856"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1646956800000"}},{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Word","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"Is there a maximum number of styles in Word? What happens when this is reached?","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt-include","parameters":{"macroParams":{"":{"value":"CloudMaximum number of styles"},"nopanel":{"value":"true"}},"macroMetadata":{"macroId":{"value":"450a8fe0-5286-481c-b131-490682252dab"},"schemaVersion":{"value":"1"},"title":"Excerpt Include"}},"localId":"6d33a95c-fff8-4406-aaa7-0233147dcd4a"}}]},{"type":"paragraph","content":[{"text":"Read more about this in the following chapter ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237868"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1645488000000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Word","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"Your document contains CustomXML - We recommend clean up","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt-include","parameters":{"macroParams":{"":{"value":"CloudCustomXML Message"},"nopanel":{"value":"true"}},"macroMetadata":{"macroId":{"value":"dbb1614f-d4fe-46e6-8b21-26749d09ac2e"},"schemaVersion":{"value":"1"},"title":"Excerpt Include"}},"localId":"538188b4-73d8-4c64-88c4-125edc18ff64"}}]},{"type":"paragraph","content":[{"text":"Read more about this in the following chapter ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237840"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1642291200000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"General","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"Public Holidays in NW / Service Times","type":"text","marks":[{"type":"textColor","attrs":{"color":"#242424"}},{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"With its headquarters in Essen, AMANA is subject to the statutory holiday regulations in NRW. We do not regularly offer service hours on these days.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]},{"type":"paragraph","content":[{"text":"To give you an overview of which days these are, we have created a calender for you.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#333333"}}]}]},{"type":"paragraph","content":[{"text":"To the calendar Public holidays in NW","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237852"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1641686400000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Licensing","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"XBRL Licensing SmartNotes","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"For the exchange of an XBRL licence file we have created a small instruction for you.","type":"text"}]},{"type":"paragraph","content":[{"text":"The exchange of a licence - e.g. before expiry during a maintenance window - is currently not yet possible via the SmartNotes menu and therefore still involves some manual effort.","type":"text"}]},{"type":"paragraph","content":[{"text":"Read more about this in the following chapter ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237800"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1641686400000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Licensing","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"How to install or replace the SmartNotes licence","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Replacing an existing licence may be necessary for various reasons","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"You have licensed an additional module and would like to activate it.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"You want to replace the existing licence shortly before it expires - e.g. during a maintenance window.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Read more about this in the following chapter ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237794"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1638748800000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Installation","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"Version numbers","type":"text","marks":[{"type":"strong"}]},{"text":" distinguish between individual versions of software in order to identify their further development in a comprehensible way.","type":"text"}]},{"type":"paragraph","content":[{"text":"A \"new version\" can therefore mean that there is a new annual version or a new \"bug fix release\" for an annual version.","type":"text"}]},{"type":"paragraph","content":[{"text":"Read more about versioning in SmartNotes ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237776"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1638748800000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Excel","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"Excel Processing (Macros)","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Excel processing has been part of SmartNotes for years. ","type":"text"}]},{"type":"paragraph","content":[{"text":"However, due to the changeover to the XLSX format (from Excel 2007), the processing procedure has changed, as no macros can be stored in XLSX files (due to Microsoft specifications).","type":"text"}]},{"type":"paragraph","content":[{"text":"We would like to show you how you can still comfortably execute your own macros or macros created by us in SmartNotes.","type":"text"}]},{"type":"paragraph","content":[{"text":"Read more about this in the following chapter ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237808"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1638748800000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Excel","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"Think-Cell","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Learn which preparations have to be made for working with the Think-Cell Addin.","type":"text"}]},{"type":"paragraph","content":[{"text":"Read more about this in the following chapter ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237816"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1638403200000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Word","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"New Word Parser and CustomXML","type":"text","marks":[{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"From a technical point of view, this means processing the \"X\" files. So for Word files the extension \".docx\" instead of \".doc\", for Excel files the extension \".xlsx\" instead of \".xls\".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The \"location\" where the parser is executed is also different. The old parser works on the SmartNotes client, the new parser on the SmartNotes server. ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Read more about this in the following chapter ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237786"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1638230400000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Database","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"Create database script from database","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Sometimes it may be useful to check whether the schema of the database corresponds to the standard installation. ","type":"text"}]},{"type":"paragraph","content":[{"text":"With the help of these instructions, a script can be created that contains the complete structure of a database, but no data from SmartNotes. ","type":"text"}]},{"type":"paragraph","content":[{"text":"To create the script, access to the database server via the SQL Management Studio is necessary.","type":"text"}]},{"type":"paragraph","content":[{"text":"Read more about this in the following chapter ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237826"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[162.0]},"content":[{"type":"paragraph","content":[{"type":"date","attrs":{"timestamp":"1637452800000"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Data security","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1506.0]},"content":[{"type":"paragraph","content":[{"text":"Is my data lost if SmartNotes has crashed?","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt-include","parameters":{"macroParams":{"":{"value":"Clouddata loss after crash"},"nopanel":{"value":"true"}},"macroMetadata":{"macroId":{"value":"1f34e0c8-a861-49e5-bf55-e656816ad8f3"},"schemaVersion":{"value":"1"},"title":"Excerpt Include"}},"localId":"7371e655-6337-4257-b033-9e31b403b81f"}}]},{"type":"paragraph","content":[{"text":"Read more about this in the following chapter ...","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237832"}}]}]}]}]}]},{"type":"paragraph"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"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":"28f4d966-0c30-4661-8661-6da6960ecb7e"},"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":"7c3c5757-3c83-4a56-9a2e-72a8edd43f17"},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"1f310","text":"🌐","shortName":":globe_with_meridians:"}},{"text":" ","type":"text"},{"text":"Übersicht Hilfe","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6238410"}}]}]}]}]}]},{"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":"52a9e260-cad7-4b35-98e8-f9d20d11ae7f"},"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":"5a71c9b9-c9db-4f93-82a9-5e65ec77bfb2"},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"1f310","text":"🌐","shortName":":globe_with_meridians:"}},{"text":" ","type":"text"},{"text":"Overview Help","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6238410"}}]}]}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}],"version":1}