Bidirectional networked real-time data exchange using a spreadsheet application

1. A method for real-time interaction with a spreadsheet application (SSAPP), the method comprising:

obtaining data propagated from a data source;

creating a persistent connection with a SSAPP;

subscribing the SSAPP to subscribed data, wherein the subscribed data includes at least some of the data obtained from the data source;

propagating the subscribed data to the SSAPP through the persistent connection as the subscribed data is obtained;

obtaining a change request from the SSAPP through the persistent connection;

transmitting the change request to the data source;

obtaining updated data propagated from the data source based on the change request;

propagating the updated data to the SSAPP through the persistent connection as the updated data is obtained;

operating in a non-authoritative configuration, wherein operating in the non-authoritative configuration further includes:

storing a data set;

receiving a connection from an authoritative client device;

responsive to receiving the connection, obtaining an authoritative data set from the authoritative client device over the connection; and

storing the authoritative data set,

wherein storing the authoritative data set includes at least one of: (i) overwriting a portion of the stored data set that conflicts with the authoritative data set and (ii) ignoring a portion of the stored data set that conflicts with the authoritative data set, and

wherein operating in the non-authoritative configuration further includes:

determining whether the authoritative client device has disconnected; and

responsive to the authoritative client device disconnecting, notifying one or more other connected client devices that the authoritative client device is no longer providing data.

2. The method of claim 1 , further comprising:

sending the subscribed data to the SSAPP via a bi-directional Transmission Control Protocol (TCP) connection.

3. The method of claim 1 , further comprising:

obtaining, from the SSAPP, a command; and

executing the command.

4. The method of claim 3 , wherein executing the command includes: altering a behavior based on the command.

5. The method of claim 3 , wherein executing the command includes:

altering how the data propagated from the data source is obtained based on the command.

6. The method of claim 1 , wherein obtaining the data propagated from the data source further includes:

obtaining the data through at least one intermediate component.

7. The method of claim 1 , further comprising:

treating the SSAPP as both an authoritative data source and a non-authoritative data source.

8. The method of claim 7 ,

wherein the SSAPP is a first SSAPP;

wherein treating the first SSAPP as an authoritative data source includes:

obtaining SSAPP-originated data from the first SSAPP through the persistent connection; and

propagating the SSAPP-originated data to a second SSAPP; and

wherein treating the first SSAPP as a non-authoritative data source includes:

obtaining second SSAPP-originated data from the second SSAPP; and

propagating the second SSAPP-originated data to the first SSAPP.

9. A system for real-time interaction with a spreadsheet application (SSAPP), the system comprising:

a processor;

a memory comprising instructions that, when executed by the processor, cause the processor to:

obtain data propagated from a data source;

create a persistent connection with a SSAPP;

subscribe the SSAPP to subscribed data, wherein the subscribed data includes at least some of the data obtained from the data source;

propagate the subscribed data to the SSAPP through the persistent connection as the subscribed data is obtained;

obtain a change request from the SSAPP through the persistent connection;

transmit the change request to the data source;

obtain updated data propagated from the data source based on the change request;

propagate the updated data to the SSAPP through the persistent connection as the updated data is obtained;

operate in a non-authoritative configuration by:

storing a data set;

receiving a connection from an authoritative client device;

responsive to receiving the connection, obtaining an authoritative data set from the authoritative client device over the connection; and

storing the authoritative data set,

wherein storing the authoritative data set includes at least one of: (i) overwriting a portion of the stored data set that conflicts with the authoritative data set and (ii) ignoring a portion of the stored data set that conflicts with the authoritative data set, and

wherein operating in the non-authoritative configuration further includes:

determining whether the authoritative client device has disconnected; and

responsive to the authoritative client device disconnecting, notifying one or more other connected clients that the authoritative client device is no longer providing data.

10. The system of claim 9 , wherein the instructions further cause the processor to:

obtain, from the SSAPP, a command; and

execute the command, wherein executing the command includes: altering a behavior based on the command.

11. The system of claim 9 , wherein the SSAPP is a first SSAPP; and

wherein the instructions further cause the processor to:

obtain SSAPP-originated data from the first SSAPP through the persistent connection; and

propagate the SSAPP-originated data to a second SSAPP.

12. The system of claim 9 , wherein the instructions further cause the processor to:

obtain, from the SSAPP, a command; and

execute the command, wherein executing the command includes altering how the data propagated from the data source is obtained based on the command.

13. A non-transitory computer-readable medium having stored thereon one or more sequences of instructions for causing one or more processors to perform:

obtaining data propagated from a data source;

creating a persistent connection with a SSAPP;

subscribing the SSAPP to subscribed data, wherein the subscribed data includes at least some of the data obtained from the data source;

propagating the subscribed data to the SSAPP through the persistent connection as the subscribed data is obtained;

obtaining a change request from the SSAPP through the persistent connection;

transmitting the change request to the data source;

obtaining updated data propagated from the data source based on the change request;

propagating the updated data to the SSAPP through the persistent connection as the updated data is obtained;

operating in a non-authoritative configuration, wherein operating in the non-authoritative configuration further includes:

storing a data set;

receiving a connection from an authoritative client device;

responsive to receiving the connection, obtaining an authoritative data set from the authoritative client device over the connection; and

storing the authoritative data set,

wherein storing the authoritative data set includes at least one of: (i) overwriting a portion of the stored data set that conflicts with the authoritative data set and (ii) ignoring a portion of the stored data set that conflicts with the authoritative data set, and

wherein operating in the non-authoritative configuration further includes:

determining whether the authoritative client device has disconnected; and

responsive to the authoritative client device disconnecting, notifying one or more other connected client devices that the authoritative client device is no longer providing data.

14. The non-transitory computer-readable medium of claim 13 , further having stored thereon a sequence of instructions for causing the one or more processors to perform:

sending the subscribed data to the SSAPP via a bi-directional Transmission Control Protocol (TCP) connection.

15. The non-transitory computer-readable medium of claim 13 , further having stored thereon a sequence of instructions for causing the one or more processors to perform:

obtaining, from the SSAPP, a command; and

executing the command.

16. The non-transitory computer-readable medium of claim 15 , wherein executing the command includes altering a behavior based on the command.

17. The non-transitory computer-readable medium of claim 13 , wherein obtaining the data propagated from the data source further includes obtaining the data through at least one intermediate component.

18. The non-transitory computer-readable medium of claim 13 , further having stored thereon a sequence of instructions for causing the one or more processors to perform:

treating the SSAPP as both an authoritative data source and a non-authoritative data source.

19. The non-transitory computer-readable medium of claim 13 ,

wherein the SSAPP is a first SSAPP;

wherein treating the first SSAPP as an authoritative data source includes:

obtaining SSAPP-originated data from the first SSAPP through the persistent connection; and

propagating the SSAPP-originated data to a second SSAPP; and

wherein treating the first SSAPP as a non-authoritative data source includes:

obtaining second SSAPP-originated data from the second SSAPP; and

propagating the second SSAPP-originated data to the first SSAPP.