Snapshots - Tabular Data Exchange in SpreadSheets

You can send a range/table/worksheet to other people without leaving Excel.

Let us make an example:
Alice works on a complex Excel spreadsheet and needs to send a table included in such a spreadsheet to her colleague Bob. Instead of copy-pasting the range into a temporary spreadsheet and attaching it to an email message, she selects the table and directly invokes the SpreadSheetSpace Send functionality. All in one click.

Bob receives a notification, invokes the SpreadSheetSpace Receive functionality and incorporates the Alice's data range in his spreadsheet at the cursor position. Again, just one click.

No more copy-paste, no more temporary files, no more errors, but direct Excel to Excel data exchange, one-click operation, Format/Style preservation.

Want to learn more on how to send/receive Snapshots? Continue reading...

Create and send a new Snapshot

  1. Select the range, table or worksheet you would like to send as a Snapshot;
    you will be able to select or edit the actual selection afterwards.
  2. In the SpreadSheetSpace panel, click on the Send / Receive button and then select Send.
  3. Insert recipients email addresses and a short description of the new Snapshot;
    in the Range field will be shown the previously selected area, if you want you can edit it by clicking on the side button.
    To finally send the new Snapshot press OK.
  4. A new window will inform you that the Snapshot has been sent.

Receive an existing Snapshot

  1. Select the cell in which you would like to import the desired Snapshot; the content of the Snapshot will be imported starting by the selected cell.
    If the desired Snapshot contains a full worksheet, it will automatically be created a new worksheet named to reflect Snapshot's description.
  2. In the SpreadSheetSpace panel, click on the Send / Receive button and then select Receive.
  3. Select the Snapshot you wish to import from the list and then press the OK button;
    To facilitate selection, in the lower section will be displayed a preview of the currently selected Snapshot's content and at the bottom will be indicated the size of the area it contains.
  4. Selected Snapshot's content will be imported in your Excel worksheet.

Views - SpreadSheets Synchronization

You can synchronize other people's spreadsheets with yours and so make a range/table/worksheet visible to them as its content evolves over time. You, as the data owner, will have write access rights on the range/table/worksheet while the other people will only be allowed to display its content and use it in calculations and presentations. The new versions immediately appear in the other people spreadsheets.

Let us make an example:
Alice works on a complex Excel spreadsheet and needs to make available a table which evolves over time to her colleague Bob. Instead of sending a new version of the table at every update by means of an email message, Alice selects the table and invokes the SpreadSheetSpace Expose functionality to expose a view of the table to Bob. All in one click.

Bob receive a notification and invokes the SpreadSheetSpace Connect functionality to install the View in his spreadsheet at the cursor position. Again, just one click. From then on, the two spreadsheets are “in sync” and SpreadSheetSpace takes care of synchronization.

No more Multiple Versions of the Truth, no more errors due to people working on different data versions, no more copy-paste, temporary files, email messages, but just a Single Version of the Truth, direct spreadsheet synchronization, automatic/manual update, one click operation.

Want to learn more on how to expose/connect Views? Continue reading...

Create and expose a new View

  1. Select the range, table or worksheet you would like to send as a View;
    you will be able to select or edit the actual selection afterwards.
  2. In the SpreadSheetSpace panel, click on the Expose / Connect button and then select Expose.
  3. Insert recipients email addresses and a short description of the new View;
    in the Range field will be shown the previously selected area, if you want you can edit it by clicking on the side button.
    Check or uncheck the Automatic field depending on whether you want to automatically transmit updates to recipients or if you prefer to transmit them manually.
    To finally expose the new View press OK.
  4. A new window will inform you that the View has been exposed.

Connect to an existing View

  1. Select the cell in which you would like to import the desired View; its content will be imported starting by the selected cell.
    If the desired View contains a full worksheet, it will automatically be created a new worksheet named to reflect View's description.
  2. In the SpreadSheetSpace panel, click on the Expose / Connect button and then select Connect.
  3. Select the View to which you wish to connect from the list and then press the OK button;
    To facilitate selection, in the lower section will be displayed a preview of the currently selected View's content and at the bottom will be indicated the size of the area it contains.
    You can also decide if you prefer to automatically receive future updates or rather to manually download them checking or unchecking Realtime field.
  4. Selected View's content will be imported in your Excel worksheet.

Manually send View's updates

If automatic updates were not been set during View creation, you can manually send any updates toward recipients by:
  1. Right click on a cell belonging to the View you wish to update.
  2. At the bottom of the context menu you can find a section named SpreadSheetSpace where all the Views to which the selected cell belongs will be listed;
    Move your mouse over the entry relative to the View you wish to update and then press the Send button.
  3. A new window will inform you that the View has been updated.
  4. Alternativelly you can click on the Refresh Worksheet button in the SpreadSheetSpace panel to manually update all the Views contained in the current worksheet.

Manually receive View's updates

If automatic updates were not been set during View connection, you can manually receive any updates from the author by:
  1. Right click on a cell belonging to the View you wish to update.
  2. At the bottom of the context menu you can find a section named SpreadSheetSpace where all the Views to which the selected cell belongs will be listed;
    Move your mouse over the entry relative to the View you wish to update and then press the Receive button.
  3. A new window will inform you that the View has been updated.
  4. Alternativelly you can click on the Refresh Worksheet button in the SpreadSheetSpace panel to manually update all the Views contained in the current worksheet.

Sharings - Real Time SpreadSheet Co-editing

A group of people can co-edit a range/table/worksheet in real time. Each participant works on the range/table/worksheet from his/her spreadsheet, the content of which remains protected and invisible to the other participants. The edit operations on the shared range/table/worksheet automatically propagate to all the group, so as to give the perception of a single shared element.

Let us make an example:
Alice works on a complex Excel spreadsheet and wants to co-edit a table along with her colleague Bob while they chat over Skype. Instead of:

  • extracting the table in a temporary spreadsheet,
  • uploading such a spreadsheet to a cloud server for online access (typically Google or Microsoft), and
  • downloading the table back to her spreadsheet at the end of the session,

Alice creates a bidirectional connection between her spreadsheet and Bob’s spreadsheet, in which the table is shared while the rest of the spreadsheets remains protected and invisible to the other party. To do so, Alice selects the table to be co-edited and invokes the SpreadSheetSpace Share functionality. All in one click.

Bob receives a notification and invokes the SpreadSheetSpace Join functionality to install the shared view in his spreadsheet at the cursor position. Again, just one click. From then on SpreadSheetSpace takes care of the replication of the edit operations of each party in the other party’s spreadsheet to support real time co-editing.

No more spreadsheet upload in untrusted cloud servers, no more complex and error-prone data extraction procedures using temporary files to protect private data, but direct peer-to-peer synchronization, automatic data protection and real time co-editing of shared ranges/tables/worksheets.

Want to learn more on how to create and join a Sharing? Continue reading...

Create a new Sharing

  1. Select the range, table or worksheet you would like to share as a Sharing;
    you will be able to select or edit the actual selection afterwards.
  2. In the SpreadSheetSpace panel, click on the Sharing button and then select Share.
  3. Insert recipients email addresses and a short description of the new Sharing;
    in the Range field will be shown the previously selected area, if you want you can edit it by clicking on the side button.
    To finally create the new Sharing press OK.

Join an existing Sharing

  1. Select the cell in which you would like to import the desired Sharing; the content of the Sharing will be imported starting by the selected cell.
    If the desired Sharing contains a full worksheet, it will automatically be created a new worksheet named to reflect Sharing's description.
  2. In the SpreadSheetSpace panel, click on the Sharing button and then select Join.
  3. Select the Sharing you wish to join to from the list and then press the OK button;
    To facilitate selection, in the lower section will be displayed a preview of the currently selected Sharing's content and at the bottom will be indicated the size of the area it contains.
  4. Selected Sharing's content will be imported in your Excel worksheet.