Dependency-based presence for co-authored documents

A system for providing a dependency-based presence indication, the system comprising:

• a memory for storing executable program code;
• and
• one or more processors, functionally coupled to the memory, the one or more processors being responsive to computer-executable instructions contained in the program code and operative to:
• cause a first object comprising one of:
• a table, a function, and a method to be displayed on a first sheet in a first active instance of a co-authored spreadsheet application file, the first object displayed in a first format and with a first value;
• cause a second object comprising data that affects the first object to be displayed in a cell of a second sheet in a second active instance of the co-authored spreadsheet application file, the second object displayed in a second format different from the first format and with a second value;
• receive an indication that the second object has been selected in the second active instance of the co-authored spreadsheet application file;
• maintain, after receiving the indication, the display of the first object in the first format and the first value in the first active instance of the co-authored spreadsheet application file;
• maintain, after receiving the indication, the display of the second object in the second format and the second value in the second active instance of the co-authored spreadsheet application file;
• and
• cause, based on receiving the indication that the second object has been selected in the second active instance of the co-authored spreadsheet application file, a second indication that the first object may be affected by a further interaction with the second object in the second active instance of the co-authored spreadsheet application file to be displayed on the first active instance corresponding to the displayed first object, wherein the displayed second indication includes an identity of a user account associated with the selection of the second object.

A computer-readable hardware storage device comprising executable instructions that, when executed by one or more processors, assists with providing a dependency-based presence indication, the computer-readable storage device including instructions executable by the one or more processors for:

• causing a first object comprising one of:
• a table, a function, and a method to be displayed on a first sheet in a first active instance of a co-authored spreadsheet application file, the first object displayed in a first format and with a first value;
• causing a second object comprising data that affects the first object to be displayed in a cell of a second sheet in a second active instance of the co-authored spreadsheet application file, the second object displayed in a second format different from the first format and with a second value;
• receiving an indication that the second object has been selected in the second active instance of the co-authored spreadsheet application file;
• maintaining, after receiving the indication, the display of the first object in the first format and the first value in the first active instance of the co-authored spreadsheet application file;
• maintaining, after receiving the indication, the display of the second object in the second format and the second value in the second active instance of the co-authored spreadsheet application file;
• and
• causing, based on receiving the indication that the second object has been selected in the second active instance of the co-authored spreadsheet application file, a second indication that the first object may be affected by a further interaction with the second object in the second active instance of the co-authored spreadsheet application file to be displayed on the first active instance in the first sheet corresponding to the displayed first object, wherein the displayed second indication includes an identity of a user account associated with the selection of the second object.