Interactive user interface for refreshable objects in shared documents
In non-limiting examples of the present disclosure, systems, methods and devices for indicating a refresh activity that affects an object in a shared document are presented. A first instance of a shared document may be displayed on a computing device of a first user. A second instance of the shared document may be displayed on a computing device of a second user, wherein the first and second users are concurrently active in the shared document. An indication that the second user has initiated a refresh of underlying data affecting an object displayed in the first instance of the shared document may be received from the second instance of the shared document. An indication of the initiated refresh may be displayed in the first instance of the shared document.
1. A device-implemented method comprising:
causing display of an instance of a spreadsheet workbook comprising a plurality of spreadsheets, the instance is a version of the spreadsheet workbook associated with a first user; and
receiving a modification of an underlying data structure of a spreadsheet, of the plurality of spreadsheets, for the spreadsheet workbook by a second user, the underlying data structure being stored separately from the spreadsheet of the spreadsheet workbook;
initiating a refresh of the version of the spreadsheet workbook based on the receiving of the modification of the underlying data structure of the spreadsheet;
causing display, in the instance of the spreadsheet workbook, of a graphical notification of the refresh within the spreadsheet indicating that:
the refresh of the version of the spreadsheet workbook has initiated,
the second user initiated the refresh,
the refresh affects a first object of the spreadsheet, and
the refresh affects a second object of the spreadsheet.
2. The device-implemented method of claim 1 wherein the graphical notification comprises, as an indication that the second user initiated the refresh, an indication of an identity of the second user proximate to the first object and the second object.
3. The device-implemented method of claim 2 , wherein the indication of the identity of the second user is in a contact card comprising one or more selectable user interface elements selectable for initiating a real-time communication with the second user.
4. The device-implemented method of claim 2 , wherein the indication of the identity of the second user is in a contact card comprising an activity status of the second user in a second version of the spreadsheet workbook.
5. The device-implemented method of claim 1 , wherein the graphical notification further comprises an estimated duration of time required to complete the refresh.
6. The device-implemented method of claim 1 , wherein the underlying data structure is stored in a second spreadsheet of the spreadsheet workbook.
7. The device-implemented method of claim 1 , wherein the underlying data structure is stored in an external database, as a separate document from the spreadsheet workbook.
8. The device-implemented method of claim 1 , wherein the graphical notification comprises one or more of: a color, a pattern, an outline, a highlight, and a pop-up window, in association with one of the first object and the second object.
9. The device-implemented method of claim 1 , wherein the causing display of the graphical notification causes one or more graphical notifications to be rendered in the spreadsheet at a first location associated with the first data object and a second location associated with the second data object.
10. A 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 display of an instance of a spreadsheet workbook comprising a plurality of spreadsheets, the instance is a version of the spreadsheet workbook associated with a first user;
receive a modification of an underlying data structure of a spreadsheet, of the plurality of spreadsheets, for the spreadsheet workbook by a second user, the underlying data structure being stored separately from the spreadsheet of the spreadsheet workbook;
initiate a refresh of the version of the spreadsheet workbook based on the receiving of the modification of the underlying data structure of the spreadsheet; and
cause display, in the instance of the spreadsheet workbook, of a graphical notification of the refresh within the spreadsheet indicating that:
the refresh of the version of the spreadsheet workbook has initiated,
the second user initiated the refresh,
the refresh affects a first data object of the spreadsheet, and
the refresh affects a second data object of the spreadsheet.
11. The system of claim 10 , wherein the graphical notification comprises, as an indication that the second user initiated the refresh, an indication of an identity of the second user proximate to the first object and the second object.
12. The system of claim 10 , wherein the graphical notification comprises an estimated duration of time required to complete the refresh.
13. The system of claim 10 , wherein the underlying data structure is stored, in an external database, as a separate document from the spreadsheet workbook.
14. The system of claim 10 , wherein the underlying data structure is stored in a second spreadsheet of the spreadsheet workbook.
15. The system of claim 10 , wherein the causing display of the graphical notification causes one or more graphical notifications to be rendered in the spreadsheet at a first location associated with the first data object and a second location associated with the second data object.
16. A computer-readable storage device comprising executable instructions that, when executed by one or more processors, assists with indicating a refresh activity in a spreadsheet workbook, the computer-readable storage device including instructions executable by the one or more processors for:
causing display of an instance of the spreadsheet workbook comprising a plurality of spreadsheets, the instance is a version of the spreadsheet workbook associated with a first user;
receiving a modification of an underlying data structure of a spreadsheet, of the plurality of spreadsheets, for the spreadsheet workbook by a second user, the underlying data structure being stored separately from the spreadsheet of the spreadsheet workbook;
initiating a refresh of the version of the spreadsheet workbook based on the receiving of the modification of the underlying data structure of the spreadsheet; and
causing display, in the instance of the spreadsheet workbook, of a graphical notification of the refresh within the spreadsheet indicating that:
the refresh of the version of the spreadsheet workbook has initiated,
the second user initiated the refresh,
the refresh affects a first object of the spreadsheet, and
the refresh affects a second object of the spreadsheet.
17. The computer-readable storage device of claim 16 , wherein the causing display of the graphical notification causes one or more graphical notifications to be rendered in the spreadsheet at a first location associated with the first data object and a second location associated with the second data object.
18. The computer-readable storage device of claim 16 , wherein the underlying data structure is stored in a second spreadsheet of the spreadsheet workbook.
19. The computer-readable storage device of claim 16 , wherein the underlying data structure is stored, in an external database, as a separate document from the spreadsheet workbook.