{"type":"doc","content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":66.66},"content":[{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"german","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"7b034435-4789-47d8-bd45-5d69c55af42a"},"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":"39ab6451-c8dd-4132-912c-df515e41849e"},"content":[{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Für eine optimale Darstellung und automatische Aktualisierung von Grafiken und Werten innerhalb einer Excel-Datei und damit auch innerhalb einer Excel-Tabelle in Word, müssen bestimmte Voraussetzungen innerhalb der Excel-Tabelle erfüllt sein. Dazu zählen z.B. die Nutzung von Namen und Namenszusätzen für bestimmte Zellbereiche und Spalten.","type":"text"}]},{"type":"paragraph","content":[{"text":"Grundsätzlich ist es zwar möglich, dass auf mehreren Tabellenblättern programmiert werden kann. Aus Gründen der Performance empfehlen wir jedoch die Anzahl der Tabellenblätter möglichst gering zu halten.","type":"text"}]},{"type":"paragraph"},{"type":"paragraph"}]}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"german","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"fa3a63fd-8956-4e0b-880f-fec9b149f142"},"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":"aa438d63-3f7b-43e9-bd0f-8e1ae0aa7504"},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"1f310","text":"🌐","shortName":":globe_with_meridians:"}},{"text":" ","type":"text"},{"text":"Excel-Dokumente","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233270"}}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Anlegen von Excel-Dateien","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233286"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"CheckIn von Excel-Dateien","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233298"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Bearbeiten von Excel-Dateien","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233316"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Programmierung der Excel-Tabellen","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Namen und Namensmanager","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233358"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Zellen, Zellbereiche und Spalten mit Namen versehen","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233374"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Eingaben für die Programmierspalte","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233402"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Programmierungsassistent","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233426"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Referenzprogrammierung","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233450"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Fußnotenspalten","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233470"}}]}]}]}]}]}]},{"type":"paragraph"}]}]}]},{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":66.66},"content":[{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"english","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"74884a5d-b517-4d28-8ae9-73d717ef0cb0"},"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":"b5e56096-9199-46e2-bc03-f2f5c999c208"},"content":[{"type":"paragraph"},{"type":"paragraph","content":[{"text":"For an optimal display and automatic updating of graphics and values within an Excel file and thus also within an Excel table in Word, certain requirements must be met within the Excel table. These include, for example, the use of names and name suffixes for certain cell ranges and columns.","type":"text"}]},{"type":"paragraph","content":[{"text":"In principle, it is possible to programme on several spreadsheets. For performance reasons, however, we recommend keeping the number of spreadsheets as low as possible.","type":"text"}]},{"type":"paragraph"},{"type":"paragraph"},{"type":"paragraph"},{"type":"paragraph"}]}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"english","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"2692e6cd-c25e-49cb-9295-59b8b0f397e8"},"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":"dd9fd20f-ce87-42c4-9a4a-d51143468852"},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"1f310","text":"🌐","shortName":":globe_with_meridians:"}},{"text":" ","type":"text"},{"text":"Excel-Documents","type":"text","marks":[{"type":"underline"},{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233270"}}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create Excel files","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233286"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"CheckIn of Excel files","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233298"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Edit Excel Files","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233316"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Programming the Excel Tables","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Names and Name Manager","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233358"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Assigning names to cells, cell ranges, and columns","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233374"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Inputs for the Programming Column","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233402"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Programming Wizard","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233426"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"References","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233450"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Footnote Columns","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233470"}}]}]}]}]}]}]},{"type":"paragraph"}]}]}]},{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"german","parameters":{"macroParams":{"atlassian-macro-output-type":{"value":"INLINE"}},"macroMetadata":{"macroId":{"value":"00186bc7-0a0f-47e3-bf16-0698520c0bee"},"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":"00f2cab0-5073-4716-a7f6-b816c82630d4"},"content":[{"type":"paragraph"},{"type":"table","attrs":{"layout":"default","localId":"cc8f593f-02b3-4300-8efa-c72b635c3cfa"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[1766.0]},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Voransicht von Änderungen/Aktualisierung von Excel-Dateien","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%

In Excel vorgenommenen Änderungen können jederzeit als Vorschau angesehen werden, ohne die Excel-Datei in SmartNotes einchecken zu müssen. Das Aufrufen der Voransicht erfolgt dabei über die Funktion „Aktualisieren“.
Zum Aktualisieren der Ansicht wird im SmartNotes Ribbon der Button „Aktualisieren“ verwendet. Die Ansicht der Excel-Tabelle wird gemäß den derzeitigen, veränderten Einstellungen aktualisiert [z.B. Abruf von Werten aus der Datenbank bei aktualisierten Programmierungen].

Um Änderungen dauerhaft zu übernehmen muss die Excel-Datei beim Verlassen [Schließen] in SmartNotes eingecheckt werden. Andernfalls gehen vorgenommene Änderungen und Programmierungen verloren.

Werden Änderungen an der Programmierung vorgenommen, muss die Datei erst einmal eingecheckt werden, damit die Funktion „Aktualisieren“ greifen kann.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"a7f22e3f-9ae7-4a7a-b261-853813573d5c"},"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%

Um Änderungen dauerhaft zu übernehmen muss die Excel-Datei beim Verlassen [Schließen] in SmartNotes eingecheckt werden. Andernfalls gehen vorgenommene Änderungen und Programmierungen verloren.

Werden Änderungen an der Programmierung vorgenommen, muss die Datei erst einmal eingecheckt werden, damit die Funktion „Aktualisieren“ greifen kann.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"60%"}},"macroMetadata":{"macroId":{"value":"da96e6c7-8c19-4d40-91e2-1c659a8229a6"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":"In Excel vorgenommenen Änderungen können jederzeit als Vorschau angesehen werden, ohne die Excel-Datei in ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" einchecken zu müssen. Das Aufrufen der Voransicht erfolgt dabei über die Funktion „Aktualisieren“.","type":"text"},{"type":"hardBreak"},{"text":"Zum Aktualisieren der Ansicht wird im SmartNotes Ribbon der Button „Aktualisieren“ verwendet. Die Ansicht der Excel-Tabelle wird gemäß den derzeitigen, veränderten Einstellungen aktualisiert [z.B. Abruf von Werten aus der Datenbank bei aktualisierten Programmierungen].","type":"text"}]},{"type":"paragraph","content":[{"text":"Um Änderungen dauerhaft zu übernehmen muss die Excel-Datei beim Verlassen [Schließen] in ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" eingecheckt werden. Andernfalls gehen vorgenommene Änderungen und Programmierungen verloren.","type":"text"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Werden Änderungen an der Programmierung vorgenommen, muss die Datei erst einmal eingecheckt werden, damit die Funktion „Aktualisieren“ greifen kann.","type":"text"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A section macro in a table cell can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"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":"8c10def5-c4da-491b-807f-bbd7bc2eb03b"},"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":"a11fdcf4-08ff-408d-a809-310f5ca112e9"},"content":[{"type":"table","attrs":{"layout":"default","localId":"40fc6141-3183-4da7-b8c5-acd6e49cd37a"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[1766.0]},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Preview changes/update Excel files","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%

Changes made in Excel can be previewed at any time without having to check the Excel file into SmartNotes. The preview is called up via the "Refresh" function.
To refresh the view, the button "Refresh" is used in the SmartNotes ribbon. The view of the Excel spreadsheet is updated according to the current, changed settings [e.g. retrieval of values from the database for updated programming].

In order to apply changes permanently, the Excel file must be checked into SmartNotes when exiting [Close]. Otherwise, changes made and programming will be lost.

If changes are made to the programming, the file must first be checked in so that the "Refresh" function can take effect.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"1d53cbf7-c172-4ec6-8b0a-9ad0ad6ff114"},"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 order to apply changes permanently, the Excel file must be checked into SmartNotes when exiting [Close]. Otherwise, changes made and programming will be lost.

If changes are made to the programming, the file must first be checked in so that the "Refresh" function can take effect.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"60%"}},"macroMetadata":{"macroId":{"value":"643104db-12f0-46e2-a232-92336b705879"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":"Changes made in Excel can be previewed at any time without having to check the Excel file into ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":". The preview is called up via the \"Refresh\" function.","type":"text"},{"type":"hardBreak"},{"text":"To refresh the view, the button \"Refresh\" is used in the SmartNotes ribbon. The view of the Excel spreadsheet is updated according to the current, changed settings [e.g. retrieval of values from the database for updated programming].","type":"text"}]},{"type":"paragraph","content":[{"text":"In order to apply changes permanently, the Excel file must be checked into ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" when exiting [Close]. Otherwise, changes made and programming will be lost.","type":"text"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"If changes are made to the programming, the file must first be checked in so that the \"Refresh\" function can take effect.","type":"text"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A column macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"reason":"A section macro in a table cell can't be created or edited in the new editor."}}},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]}]},{"type":"paragraph"}]},{"type":"rule"},{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":66.66},"content":[{"type":"paragraph"}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"german","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"69dc41a9-533d-4a76-a929-70a6ed4d7742"},"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":"22e08205-23c5-4782-8286-59f2bf7173d9"},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"1f310","text":"🌐","shortName":":globe_with_meridians:"}},{"text":" ","type":"text"},{"text":"Excel-Dokumente","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233270"}}]}]}]}]}]},{"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":"4220065a-2306-4c40-bd0f-a892d1b67956"},"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":"89aaa53e-11be-4595-b787-e64d7ea05156"},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"1f310","text":"🌐","shortName":":globe_with_meridians:"}},{"text":" ","type":"text"},{"text":"Excel-Documents","type":"text","marks":[{"type":"underline"},{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6233270"}}]}]}]}]}]},{"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}

CloudProgramming the Excel tables