Inserting external data

    1. The user copies the cell value to the clipboard from the document editor of the source spreadsheet. At the same time, the special data is also copied.
    2. The user inserts the copied data into the document editor of the destination spreadsheet.
    3. The document editor requests a link to the source file by sending the data to the document manager.
    4. The document manager sends the source spreadsheet link to the document editor.
    5. The document editor sends a request to the document editing service for spreadsheet downloading.
    6. The document editing service sends all the necessary data to display in the document editor of the destination spreadsheet.
    1. Create a source spreadsheet from where the data will be copied.

    2. Specify the parameter in the initialization config of the source spreadsheet:

    3. When the user copies the data from the source spreadsheet, the clipboard receives a list of the following values:

      • the sheet name and the range from where the data was copied which will be used later to refresh the copied data;
      • the document.referenceData object which will be used to check the availability of insering data into the destination spreadsheet by the external link;
    4. Create a destination spreadsheet where the external data will be inserted.

    5. Specify the event handler in the initialization config of the destination spreadsheet for the Paste link and Update values buttons to be displayed:

    6. Paste link

    7. When the user clicks the Paste link button, the formula is inserted into the current cell, and the referenceData object is saved to the destination file. The inserted formula is displayed as follows:

      The data update request to the file will be sent to the file URL.

      Please note that you can enter a formula of the specified format in the cell, and the data from the extrenal file will be inserted as well. But in this case, the onRequestReferenceData event will be executed only with the path parameter.

    8. To send the data to the setReferenceData method, it is recommended to search for the file by the referenceData parameter first. If there is no such a field or a file cannot be found, then the path parameter is used.

    9. In order to refresh the data from the source file, the setReferenceData method must be called:

      Please note that this method is executed only when the user has permissions to the source file.