{"type":"doc","content":[{"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":"48514150-a172-47f3-b7a3-11fa30c73fe6"},"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":"a1a2bc28-3ea5-485b-ade4-7654f507e4c3"},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"1f310","text":"🌐","shortName":":globe_with_meridians:"}},{"text":" ","type":"text"},{"text":"Zurück zur Übersicht FAQ","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237738"}}]},{"text":" ","type":"text"}]}]}]}]},{"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":"bdc9c05e-71fe-4592-af0b-c7e380f9277e"},"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":"d8b5e099-3d92-4b7e-bac9-ddb0290cbffb"},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"1f310","text":"🌐","shortName":":globe_with_meridians:"}},{"text":" ","type":"text"},{"text":"Back to Overview FAQ","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237738"}}]},{"text":" ","type":"text"}]}]}]}]},{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"german","parameters":{"macroParams":{"atlassian-macro-output-type":{"value":"INLINE"}},"macroMetadata":{"macroId":{"value":"ca6a4084-a71d-4455-8403-0d609634bd0e"},"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":"503f1696-18f0-47d3-940a-22c20498cf6e"},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"table","attrs":{"layout":"default","localId":"255d04a0-b4f6-4c77-8ba3-245cec1273f0"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#ECECEC","rowspan":1,"colwidth":[1766.0]},"content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"Externe Excel-Werte (#e)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#ECECEC","rowspan":1,"colwidth":[1766.0]},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"panel","attrs":{"panelType":"custom"},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

Ab der Version 2.9 ist die #e-Programmierung hinzugekommen.

Normalerweise werden in SmartNotes Zahlen aus einem Vorsystem importiert und mit einer Kontonummer in Excel verknüpft. Andere Zahlen werden manuell eingetragen. Es gibt aber immer wieder Zahlen, die sich nicht über ein Vorsystem importieren lassen.

Bisher werden diese Werte in Einzelfällen über Excel-Add-ins oder Verweise auf andere Arbeitsblätter – meist unter Verwendung des alten Parsers – hinterlegt. Da diese Zahlen jedoch nicht unter SmartNotes-Kontrolle stehen, lassen sie sich nicht weiter als Fließtextzahl oder zur Validierung verwenden.

Mit der #e-Programmierung können die Zahlen in Excel gepflegt und dann von SmartNotes als Fließtextzahl oder zur Validierung genutzt werden. Sie sind allerdings starrere Werte, die im Rundungsassistent wie eine Summe dargestellt werden und sich nicht bearbeiten lassen.

Diese Programmierung ersetzt die #am-Programmierung, die wir nicht mehr empfehlen.

Hinweis: um die Zahlen zu aktualisieren, muss die Tabelle aus- und wieder eingecheckt werden. #e-Programmierungen werden nicht automatisch durch Import oder ähnliche Prozesse aktualisiert. Aus diesem Grund eignet sich die Funktion z.B. nicht für Subdokumente innerhalb des Factory-Moduls.

Bei Nutzung der #e-Programmierung ändert sich die Befüllungsart auf „Excel".

Verwenden Sie bei den Excel-Dateien bitte das Format XLSX. Das alte Format XLS führt zu Performance-Einbußen.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"custom"},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

40%

60%

Ab der Version 2.9 ist die #e-Programmierung hinzugekommen.

Diese Programmierung ersetzt die #am-Programmierung, die wir nicht mehr empfehlen.

Bei Nutzung der #e-Programmierung ändert sich die Befüllungsart auf „Excel".

Verwenden Sie bei den Excel-Dateien bitte das Format XLSX. Das alte Format XLS führt zu Performance-Einbußen.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"b38c0459-4da3-410b-b257-85d83f871129"},"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%

Ab der Version 2.9 ist die #e-Programmierung hinzugekommen.

Diese Programmierung ersetzt die #am-Programmierung, die wir nicht mehr empfehlen.

Bei Nutzung der #e-Programmierung ändert sich die Befüllungsart auf „Excel".

Verwenden Sie bei den Excel-Dateien bitte das Format XLSX. Das alte Format XLS führt zu Performance-Einbußen.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"60%"}},"macroMetadata":{"macroId":{"value":"92c70e27-8209-43b4-8a33-e9b845704240"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":"Ab der Version 2.9 ist die","type":"text"},{"text":" ","type":"text"},{"text":"#e","type":"text","marks":[{"type":"strong"}]},{"text":"-Programmierung hinzugekommen.","type":"text"}]},{"type":"paragraph","content":[{"text":"Normalerweise werden in","type":"text"},{"text":" ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" ","type":"text"},{"text":"Zahlen aus einem Vorsystem importiert und mit einer Kontonummer in Excel verknüpft. ","type":"text"},{"text":"Andere Zahlen werden manuell eingetragen. ","type":"text"},{"text":"Es gibt aber immer wieder Zahlen, die sich nicht über ein Vorsystem importieren lassen.","type":"text"}]},{"type":"paragraph","content":[{"text":"Bisher werden diese Werte in Einzelfällen über Excel-Add-ins oder Verweise auf andere Arbeitsblätter – meist unter Verwendung des alten Parsers – hinterlegt. Da diese Zahlen jedoch nicht unter SmartNotes-Kontrolle stehen, lassen sie sich nicht weiter als Fließtextzahl oder zur Validierung verwenden.","type":"text"}]},{"type":"paragraph","content":[{"text":"Mit der #e-Programmierung können die Zahlen in Excel gepflegt und dann von","type":"text"},{"text":" ","type":"text"},{"text":"SmartNotes","type":"text","marks":[{"type":"em"}]},{"text":" ","type":"text"},{"text":"als Fließtextzahl oder zur Validierung genutzt werden. Sie sind allerdings starrere Werte, die im","type":"text"},{"text":" ","type":"text"},{"text":"Rundungsassistent","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.amana.de/display/SND/Open+Data+View"}}]},{"text":" ","type":"text"},{"text":"wie eine Summe dargestellt werden und sich nicht bearbeiten lassen.","type":"text"}]},{"type":"paragraph","content":[{"text":"Diese Programmierung ersetzt die #am-Programmierung, die wir nicht mehr empfehlen.","type":"text"}]},{"type":"paragraph","content":[{"text":"Hinweis:","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"um die Zahlen zu aktualisieren, muss die Tabelle aus- und wieder eingecheckt werden. #e-Programmierungen werden nicht automatisch durch Import oder ähnliche Prozesse aktualisiert. Aus diesem Grund eignet sich die Funktion z.B. nicht für Subdokumente innerhalb des","type":"text"},{"text":" ","type":"text"},{"text":"Factory-Moduls","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.amana.de/display/SND/SN-Factory+Module"}}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"Bei Nutzung der #e-Programmierung ändert sich die","type":"text"},{"text":" ","type":"text"},{"text":"Befüllungsart","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.amana.de/display/SND/Column+Areas#ColumnAreas-Bef%C3%BCllungsart"}}]},{"text":" ","type":"text"},{"text":"auf „Excel\".","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Verwenden Sie bei den Excel-Dateien bitte das Format XLSX. Das alte Format XLS führt zu Performance-Einbußen. ","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"}]}]}],"version":1}}}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"Vorgehensweise

40%

60%

... für lokale Dateien

40%

60%

Wir haben außerhalb von SmartNotes eine Tabelle „Sonderlockentabelle.xlsx" angelegt und möchten gerne auf den Wert in Zelle $D$7 referenzieren. Die Tabelle enthält keine SmartNotes-Programmierungen.

Geben Sie in der Eingabezeile den Ausdruck „=[Mappe]Tabelle!$D$7" ein.

40%

60%

Es öffnet sich der Dateiexplorer, damit eine Datei ausgewählt werden kann.

Wählen Sie die die Datei „Sonderlockentabelle.xlsx" aus und klicken Sie auf den Button öffnen.

40%

60%

Es erscheint wieder die geöffnete Exceldatei. In der ausgewählten Zelle wird nun der Wert angezeigt.

Wechseln Sie über den Menüpunkt „Datei" in den folgenden Dialog.

40%

60%

Klicken Sie nun auf „Informationen" (1) , „Verknüpfungen mit Datei bearbeiten" (2) und „Quelle ändern".

40%

60%

Es öffnet sich der Dateiexplorer.

Wählen Sie die zu hinterlegende Datei aus und bestätigen Sie mit „Öffnen".

40%

60%

Sie sehen nun unter „Quelle" die hinterlegte Exceltabelle.

Klicken Sie auf „Werte aktualisieren", damit der Status auf „OK" wechselt und die Verknüpfung hinterlegt wird.

40%

60%

Checken Sie die Datei nun ein.

40%

60%

Die Warnung „Excel beinhaltet externe Links" dürfen Sie in diesem Falle natürlich ignorieren. Die Warnung lässt sich nicht umgehen oder abschalten und soll Ihnen jedes Mal bewusst machen, dass es sich hier um eine Sonderprogrammierung handelt. Sie müssen immer berücksichtigen, dass die Datei „Sonderlockentabelle.xlsx" für jeden Bearbeiter im Zugriff sein muss, damit Werte aktualisiert werden können.

... für Remote-Dateien

40%

60%

Wir haben außerhalb von SmartNotes eine Tabelle „SonderlockentabelleRemote.xlsx" angelegt. Diese liegt auf einem externen Laufwerk und wir möchten gerne auf den Wert in Zelle $D$9 referenzieren. Die Tabelle enthält keine SmartNotes-Programmierungen.

Geben Sie in der Eingabezeile den Ausdruck „=[Mappe]Tabelle!$D$9" ein.

40%

60%

Es öffnet sich der Dateiexplorer, damit eine Datei ausgewählt werden kann.

Wählen Sie die die Datei „SonderlockentabelleRemote.xlsx" aus und klicken Sie auf den Button öffnen.

40%

60%

Es erscheint wieder die geöffnete Exceldatei. In der ausgewählten Zelle wird nun der Wert angezeigt.

Wechseln Sie über den Menüpunkt „Datei" in den folgenden Dialog.

40%

60%

Klicken Sie nun auf „Informationen" (1) , „Verknüpfungen mit Datei bearbeiten" (2) und „Quelle ändern" (3).

40%

60%

Die Quelle wurde nun aktualisiert, der Name wird angezeigt.

Bleiben Sie in dem Dialog und klicken auf „Werte aktualisieren".
Verlassen die danach den Dialog.

40%

60%

Die Quelle ist hinterlegt und hat je nach Remotelaufwerk einen etwas kryptisch anmutenden Namen.

Der Wert ist aktualisiert.

Checken Sie die Datei nun ein.

Die nachfolgende Warnung „Excel beinhaltet externe Links" dürfen Sie in diesem Falle natürlich ignorieren.

Die Warnung lässt sich nicht umgehen oder abschalten und soll Ihnen jedes Mal bewusst machen, dass es sich hier um eine Sonderprogrammierung handelt. Sie müssen immer berücksichtigen, dass die Datei „SonderlockentabelleRemote.xlsx" für jeden Bearbeiter im Zugriff sein muss, damit Werte aktualisiert werden können.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"panel","parameters":{"macroParams":{"title":{"value":"Vorgehensweise"}},"macroMetadata":{"macroId":{"value":"03e45542-3b67-442e-a153-0915546c65cf"},"schemaVersion":{"value":"1"},"title":"Panel"}}},"content":[{"type":"paragraph","content":[{"text":"... für lokale Dateien","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/pages/resumedraft.action?draftId=6237906#CloudExternalExcelValues-fürlokaleDateien"}}]}]},{"type":"paragraph","content":[{"text":"... für Remote-Dateien","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/pages/resumedraft.action?draftId=6237906#CloudExternalExcelValues-fürRemote-Dateien"}}]}]},{"type":"paragraph","content":[{"text":"... Werte aktualisieren","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/pages/resumedraft.action?draftId=6237906#CloudExternalExcelValues-Werteaktualisieren"}}]}]},{"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":"36540033-9318-44bc-a7e8-2d678f7f9c98"},"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%

Geben Sie in der Eingabezeile den Ausdruck „=[Mappe]Tabelle!$D$7" ein.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"82f4c6be-a921-4783-894c-b1198852dd94"},"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%

Geben Sie in der Eingabezeile den Ausdruck „=[Mappe]Tabelle!$D$7" ein.

40%

60%

Es öffnet sich der Dateiexplorer, damit eine Datei ausgewählt werden kann.

Wählen Sie die die Datei „Sonderlockentabelle.xlsx" aus und klicken Sie auf den Button öffnen.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"c4cd30d4-8d74-450c-aa90-9012e9f31d6b"},"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 öffnet sich der Dateiexplorer, damit eine Datei ausgewählt werden kann.

Wählen Sie die die Datei „Sonderlockentabelle.xlsx" aus und klicken Sie auf den Button öffnen.

40%

60%

Es erscheint wieder die geöffnete Exceldatei. In der ausgewählten Zelle wird nun der Wert angezeigt.

Wechseln Sie über den Menüpunkt „Datei" in den folgenden Dialog.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"e427f1ca-9192-4618-be8b-40d4c5f228ef"},"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 erscheint wieder die geöffnete Exceldatei. In der ausgewählten Zelle wird nun der Wert angezeigt.

Wechseln Sie über den Menüpunkt „Datei" in den folgenden Dialog.

40%

60%

Klicken Sie nun auf „Informationen" (1) , „Verknüpfungen mit Datei bearbeiten" (2) und „Quelle ändern".

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"8f99f394-b1fa-4a66-9903-25b481918529"},"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%

Klicken Sie nun auf „Informationen" (1) , „Verknüpfungen mit Datei bearbeiten" (2) und „Quelle ändern".

40%

60%

Es öffnet sich der Dateiexplorer.

Wählen Sie die zu hinterlegende Datei aus und bestätigen Sie mit „Öffnen".

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"da351cc1-c35b-42c4-9237-1a99102d2f8d"},"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 öffnet sich der Dateiexplorer.

Wählen Sie die zu hinterlegende Datei aus und bestätigen Sie mit „Öffnen".

40%

60%

Sie sehen nun unter „Quelle" die hinterlegte Exceltabelle.

Klicken Sie auf „Werte aktualisieren", damit der Status auf „OK" wechselt und die Verknüpfung hinterlegt wird.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"910ba409-0999-41a3-aa1f-a48e6d2f55bc"},"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%

Sie sehen nun unter „Quelle" die hinterlegte Exceltabelle.

Klicken Sie auf „Werte aktualisieren", damit der Status auf „OK" wechselt und die Verknüpfung hinterlegt wird.

40%

60%

Checken Sie die Datei nun ein.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"edcbf905-68f6-483b-8a2b-1b202efa3406"},"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%

Checken Sie die Datei nun ein.

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"6e5fb3bf-763d-4303-8abf-b4800138c711"},"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%

Geben Sie in der Eingabezeile den Ausdruck „=[Mappe]Tabelle!$D$9" ein.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"114368c5-0779-4523-8ec3-cae59596122d"},"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%

Geben Sie in der Eingabezeile den Ausdruck „=[Mappe]Tabelle!$D$9" ein.

40%

60%

Es öffnet sich der Dateiexplorer, damit eine Datei ausgewählt werden kann.

Wählen Sie die die Datei „SonderlockentabelleRemote.xlsx" aus und klicken Sie auf den Button öffnen.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"ec9bf759-f6ae-44c8-b2c1-15bc20030077"},"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 öffnet sich der Dateiexplorer, damit eine Datei ausgewählt werden kann.

Wählen Sie die die Datei „SonderlockentabelleRemote.xlsx" aus und klicken Sie auf den Button öffnen.

40%

60%

Es erscheint wieder die geöffnete Exceldatei. In der ausgewählten Zelle wird nun der Wert angezeigt.

Wechseln Sie über den Menüpunkt „Datei" in den folgenden Dialog.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"b243b667-1d03-4683-9575-a804f2ff59a2"},"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 erscheint wieder die geöffnete Exceldatei. In der ausgewählten Zelle wird nun der Wert angezeigt.

Wechseln Sie über den Menüpunkt „Datei" in den folgenden Dialog.

40%

60%

Klicken Sie nun auf „Informationen" (1) , „Verknüpfungen mit Datei bearbeiten" (2) und „Quelle ändern" (3).

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"1f553bdc-e42b-4ad6-8e9b-76f36eb413e1"},"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%

Klicken Sie nun auf „Informationen" (1) , „Verknüpfungen mit Datei bearbeiten" (2) und „Quelle ändern" (3).

40%

60%

Die Quelle wurde nun aktualisiert, der Name wird angezeigt.

Bleiben Sie in dem Dialog und klicken auf „Werte aktualisieren".
Verlassen die danach den Dialog.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"02930dcd-4ec3-4542-9c20-ea7f6125ace9"},"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 Quelle wurde nun aktualisiert, der Name wird angezeigt.

Bleiben Sie in dem Dialog und klicken auf „Werte aktualisieren".
Verlassen die danach den Dialog.

40%

60%

Die Quelle ist hinterlegt und hat je nach Remotelaufwerk einen etwas kryptisch anmutenden Namen.

Der Wert ist aktualisiert.

Checken Sie die Datei nun ein.

Die nachfolgende Warnung „Excel beinhaltet externe Links" dürfen Sie in diesem Falle natürlich ignorieren.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"1b60282e-b91b-4403-b316-5851d6bd34cf"},"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 Quelle ist hinterlegt und hat je nach Remotelaufwerk einen etwas kryptisch anmutenden Namen.

Der Wert ist aktualisiert.

Checken Sie die Datei nun ein.

Die nachfolgende Warnung „Excel beinhaltet externe Links" dürfen Sie in diesem Falle natürlich ignorieren.

40%

60%

Bei Werten, die per #e aus externen Tabellen gelesen werden, müssen diese manuell aktualisiert werden.

Öffnen Sie die Tabelle, in der die Links eingetragen sind.
Wechseln Sie zu „Datei\\Informationen\\Verknüpfungen mit Dateien bearbeiten" und klicken Sie dort auf den Button „Werte aktualisieren".

40%

60%

Nach dem Aktualisieren wechselt der Status auf „OK".

40%

60%

Der aktualisierte Wert wird nun angezeigt.

Checken Sie die Datei nun ein, damit die Aktualisierung gespeichert wird.

40%

60%

Bei Werten, die per #e aus externen Tabellen gelesen werden, müssen diese manuell aktualisiert werden.

Öffnen Sie die Tabelle, in der die Links eingetragen sind.
Wechseln Sie zu „Datei\\Informationen\\Verknüpfungen mit Dateien bearbeiten" und klicken Sie dort auf den Button „Werte aktualisieren".

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"f4f2a0ca-3007-40ac-82a5-c22f00f69a65"},"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%

Bei Werten, die per #e aus externen Tabellen gelesen werden, müssen diese manuell aktualisiert werden.

Öffnen Sie die Tabelle, in der die Links eingetragen sind.
Wechseln Sie zu „Datei\\Informationen\\Verknüpfungen mit Dateien bearbeiten" und klicken Sie dort auf den Button „Werte aktualisieren".

40%

60%

Nach dem Aktualisieren wechselt der Status auf „OK".

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"484a3434-652b-492e-9c4e-43fe2108e8e2"},"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%

Nach dem Aktualisieren wechselt der Status auf „OK".

40%

60%

Der aktualisierte Wert wird nun angezeigt.

Checken Sie die Datei nun ein, damit die Aktualisierung gespeichert wird.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"ede9d651-f187-40b9-b504-3fb20d066c4c"},"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%

Der aktualisierte Wert wird nun angezeigt.

Checken Sie die Datei nun ein, damit die Aktualisierung gespeichert wird.

40%

60%

As of version 2.9, #e programming has been added.

Usually, numbers are imported from a previous system in SmartNotes and linked to an account number in Excel. Other numbers are entered manually. However, there are always numbers that cannot be imported via a pre-system.

Until now, these values have been deposited in individual cases via Excel add-ins or references to other worksheets - mostly using the old parser. However, since these numbers are not under SmartNotes control, they cannot be used further as continuous text numbers or for validation.

With #e programming, the numbers can be maintained in Excel and then used by SmartNotes as continuous text numbers or for validation. However, they are more rigid values that are displayed in the Data View like a sum and cannot be edited.

This programming replaces #am programming, which we no longer recommend.

Note: to update the numbers, the table must be checked out and checked in again. #e programming is not automatically updated by import or similar processes. For this reason, the function is not suitable for sub-documents within the Factory module, for example.

When using #e programming, the fill type changes to "Excel".

Please use the XLSX format for the Excel files. The old XLS format causes performance losses.

40%

60%

As of version 2.9, #e programming has been added.

This programming replaces #am programming, which we no longer recommend.

When using #e programming, the fill type changes to "Excel".

Please use the XLSX format for the Excel files. The old XLS format causes performance losses.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"7301932c-1329-4ff7-a18c-8d35f63c7324"},"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%

As of version 2.9, #e programming has been added.

This programming replaces #am programming, which we no longer recommend.

When using #e programming, the fill type changes to "Excel".

Please use the XLSX format for the Excel files. The old XLS format causes performance losses.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"60%"}},"macroMetadata":{"macroId":{"value":"f29a5832-1021-4f7d-bdae-366064d5116a"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":"As of version 2.9, ","type":"text"},{"text":"#e ","type":"text","marks":[{"type":"strong"}]},{"text":"programming has been added.","type":"text"}]},{"type":"paragraph","content":[{"text":"Usually, numbers are imported from a previous system in SmartNotes and linked to an account number in Excel. Other numbers are entered manually. However, there are always numbers that cannot be imported via a pre-system.","type":"text"}]},{"type":"paragraph","content":[{"text":"Until now, these values have been deposited in individual cases via Excel add-ins or references to other worksheets - mostly using the old parser. However, since these numbers are not under SmartNotes control, they cannot be used further as continuous text numbers or for validation.","type":"text"}]},{"type":"paragraph","content":[{"text":"With #e programming, the numbers can be maintained in Excel and then used by SmartNotes as continuous text numbers or for validation. However, they are more rigid values that are displayed in the ","type":"text"},{"text":"Data View","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.amana.de/display/SND/Open+Data+View"}}]},{"text":" like a sum and cannot be edited.","type":"text"}]},{"type":"paragraph","content":[{"text":"This programming replaces #am programming, which we no longer recommend.","type":"text"}]},{"type":"paragraph","content":[{"text":"Note:","type":"text","marks":[{"type":"strong"}]},{"text":" to update the numbers, the table must be checked out and checked in again. #e programming is not automatically updated by import or similar processes. For this reason, the function is not suitable for sub-documents within the ","type":"text"},{"text":"Factory module","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.amana.de/display/SND/SN-Factory+Module"}}]},{"text":", for example.","type":"text"}]},{"type":"paragraph","content":[{"text":"When using #e programming, the ","type":"text"},{"text":"fill type","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.amana.de/display/SND/Column+Areas#ColumnAreas-Bef%C3%BCllungsart"}}]},{"text":" changes to \"Excel\".","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Please use the XLSX format for the Excel files. The old XLS format causes performance losses. ","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"}]}]}],"version":1}}}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"Procedure

40%

60%

... for local files

40%

60%

We have created a table "Specialcases.xlsx" outside of SmartNotes and would like to reference the value in cell $D$8. The table does not contain any SmartNotes programming.

In the input line, enter the expression "=[Map]Table!$D$8".

40%

60%

The file explorer opens so that a file can be selected.

Select the file "Specialcases.xlsx" and click on the open button.

40%

60%

The opened Excel file appears again. The value is now displayed in the selected cell.

Switch to the following dialogue via the menu item "File".

40%

60%

Please choose „Info" (1) , „Edit Links to Files" (2) and „Change Source" (3).

40%

60%

The file explorer opens.

Select the file to be deposited and confirm with "Open".

40%

60%

You will now see the stored Excel table under "Source".

Click on "Update Values" so that the status changes to "OK" and the link is stored.

40%

60%

Now check in the file.

40%

60%

You may of course ignore the warning "Excel contains external links" in this case. The warning cannot be bypassed or switched off and should make you aware each time that this is special programming. You must always take into account that the file "Specialcases.xlsx" must be accessible to every editor so that values can be updated.

... for remote files

40%

60%

We have created a table "SpecialcasesRemote.xlsx" outside of SmartNotes. This is on an external drive and we would like to reference the value in cell $D$7. The table does not contain any SmartNotes programming.

Enter the expression "=[Map]Table!$D$7" in the input line.

40%

The file explorer opens so that a file can be selected.

Select the file "SpecialCasesRemote.xlsx" and click on the open button.

40%

60%

The opened Excel file appears again. The value is now displayed in the selected cell.

Switch to the following dialogue via the menu item "File".

40%

60%

Please choose "Info" (1) , "Edit Links to Files" (2) und „Change Source" (3).

40%

60%

The source has now been updated, the name is displayed.

Remain in the dialogue and click on "Update Values".
Then exit the dialogue.

40%

60%

The source is stored and has a somewhat cryptic name depending on the remote drive.

The value is updated.
Now please check in the file.

40%

60%

You may of course ignore the following warning "Excel file contains external links" in this case.

The warning cannot be bypassed or switched off and should make you aware each time that this is special programming. You must always take into account that the file "SpecialCasesRemote.xlsx" must be accessible to every editor so that values can be updated.

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"bad694ac-12f6-47cd-803c-c517c37b0795"},"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%

We have created a table "Specialcases.xlsx" outside of SmartNotes and would like to reference the value in cell $D$8. The table does not contain any SmartNotes programming.

In the input line, enter the expression "=[Map]Table!$D$8".

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"f1ad685e-a40d-4f07-af40-04b45e30812b"},"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%

We have created a table "Specialcases.xlsx" outside of SmartNotes and would like to reference the value in cell $D$8. The table does not contain any SmartNotes programming.

In the input line, enter the expression "=[Map]Table!$D$8".

40%

60%

The file explorer opens so that a file can be selected.

Select the file "Specialcases.xlsx" and click on the open button.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"3790055e-f29d-4325-861d-25852ca88284"},"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 file explorer opens so that a file can be selected.

Select the file "Specialcases.xlsx" and click on the open button.

40%

60%

The opened Excel file appears again. The value is now displayed in the selected cell.

Switch to the following dialogue via the menu item "File".

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"0e5e1fd5-2aa7-4218-8685-7b1710bf8ba5"},"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 opened Excel file appears again. The value is now displayed in the selected cell.

Switch to the following dialogue via the menu item "File".

40%

60%

Please choose „Info" (1) , „Edit Links to Files" (2) and „Change Source" (3).

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"1b1e61fc-4121-40fa-82ac-7841c6ed0860"},"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 choose „Info" (1) , „Edit Links to Files" (2) and „Change Source" (3).

40%

60%

The file explorer opens.

Select the file to be deposited and confirm with "Open".

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"52f57822-469e-4eb2-aa0a-0ba789d13114"},"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 file explorer opens.

Select the file to be deposited and confirm with "Open".

40%

60%

You will now see the stored Excel table under "Source".

Click on "Update Values" so that the status changes to "OK" and the link is stored.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"4ec296ca-789d-4874-8fc3-d881b6a58fe3"},"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%

You will now see the stored Excel table under "Source".

Click on "Update Values" so that the status changes to "OK" and the link is stored.

40%

60%

Now check in the file.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"4e68686c-5bc5-40de-9103-528478d83520"},"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%

Now check in the file.

40%

60%

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"5c246e7a-3a0f-4e1a-8250-7209a16dd2f3"},"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%

Enter the expression "=[Map]Table!$D$7" in the input line.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"9ad68267-43a6-42db-8eef-ea11b0c424d7"},"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%

Enter the expression "=[Map]Table!$D$7" in the input line.

40%

The file explorer opens so that a file can be selected.

Select the file "SpecialCasesRemote.xlsx" and click on the open button.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"25570e83-ef6f-4556-bc01-b9ae2fd71389"},"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 opened Excel file appears again. The value is now displayed in the selected cell.

Switch to the following dialogue via the menu item "File".

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"cc1abcc2-c761-4616-aca1-e240f4aa620f"},"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 opened Excel file appears again. The value is now displayed in the selected cell.

Switch to the following dialogue via the menu item "File".

40%

60%

Please choose "Info" (1) , "Edit Links to Files" (2) und „Change Source" (3).

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"1cd21595-d1cd-401c-ad4a-e27346ebb3ba"},"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 choose "Info" (1) , "Edit Links to Files" (2) und „Change Source" (3).

40%

60%

The source has now been updated, the name is displayed.

Remain in the dialogue and click on "Update Values".
Then exit the dialogue.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"e5fa8f17-8645-4846-b2e7-bdb2349c72ef"},"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 source has now been updated, the name is displayed.

Remain in the dialogue and click on "Update Values".
Then exit the dialogue.

40%

60%

The source is stored and has a somewhat cryptic name depending on the remote drive.

The value is updated.
Now please check in the file.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"b4a059a5-f94b-4cc8-a34a-79e3ea46575c"},"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 source is stored and has a somewhat cryptic name depending on the remote drive.

The value is updated.
Now please check in the file.

40%

60%

You may of course ignore the following warning "Excel file contains external links" in this case.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"c991121d-830c-4769-a3ce-37c45ebb6759"},"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%

You may of course ignore the following warning "Excel file contains external links" in this case.

40%

60%

For values that are read from external tables via #e, these must be updated manually.

Open the table in which the links are entered.
Switch to "File\\Info\\Edit links to Files" and click on the button "Update Values".

40%

60%

After updating, the status changes to "OK".

40%

60%

The updated value is now displayed.

Now check in the file so that the update is saved.

40%

60%

For values that are read from external tables via #e, these must be updated manually.

Open the table in which the links are entered.
Switch to "File\\Info\\Edit links to Files" and click on the button "Update Values".

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"32733ba4-8baf-4cff-bb52-d7fba5f75ab7"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"40%

For values that are read from external tables via #e, these must be updated manually.

Open the table in which the links are entered.
Switch to "File\\Info\\Edit links to Files" and click on the button "Update Values".

40%

60%

After updating, the status changes to "OK".

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"9a73c82e-d967-4fbc-9224-ef19ff362ce7"},"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%

After updating, the status changes to "OK".

40%

60%

The updated value is now displayed.

Now check in the file so that the update is saved.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"035fbde8-98d8-4f27-8405-e408148e5d96"},"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 updated value is now displayed.

Now check in the file so that the update is saved.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"width":{"value":"60%"}},"macroMetadata":{"macroId":{"value":"becdc98e-f113-47f7-b1bb-47b52582fcf8"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"text":"The updated value is now displayed.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Now check in the file so that the update is saved.","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}}}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"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":"882a2f93-1ca1-4487-8b2f-d9f037f284fc"},"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":"cfe0ab1d-caca-43e2-b120-783979e68d65"},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"1f310","text":"🌐","shortName":":globe_with_meridians:"}},{"text":" ","type":"text"},{"text":"Zurück zur Übersicht FAQ","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237738"}}]},{"text":" ","type":"text"}]}]}]}]},{"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":"734b802f-9b5c-459d-954d-3379dbdea0e8"},"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":"35d07649-2faf-4066-87c1-af1faf843be3"},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"1f310","text":"🌐","shortName":":globe_with_meridians:"}},{"text":" ","type":"text"},{"text":"Back to Overview FAQ","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/SND/pages/6237738"}}]},{"text":" ","type":"text"}]}]}]}]}],"version":1}

CloudExternal Excel Values

Related content