Computing device for multiple cell linking
A method for rendering linked content in a first document having a table with a plurality of cells is described. A first user entry of a first link in a cell of the plurality of cells is received at a computing device. The first link refers to a first set of content having a source location that is external to the cell. The cell is displayed in a user interface that displays the first document. Displaying the cell includes retrieving, by the computing device, the first set of content using the first link. Displaying the cell also includes updating, by the computing device, the user interface to display, within the cell, both the first set of content and a second set of content that is distinct from the first set of content.
1 . A method for rendering linked content in a first document having a table with a plurality of cells, the method comprising:
receiving, at a computing device, a first user entry of a first link in a cell of the plurality of cells, wherein i) the first link refers to a first set of content to be displayed in the cell and having a source location that is external to the cell, and ii) before the first link is added to the cell, the cell includes a second set of content that is distinct from the first set of content when displayed;
adding, by the computing device, the first link to the cell, comprising inserting a first uniform resource identifier, which identifies the source location of the first set of content, into a node of a causal tree that represents a history of edits to the cell, wherein nodes of the causal tree represent editing instructions for the cell and include nodes for the second set of content;
displaying, by the computing device, the cell in a user interface that displays the first document, including:
traversing, by the computing device, the causal tree to render the cell;
retrieving, by the computing device, the first set of content from the source location using the first uniform resource identifier from the cell; and
updating, by the computing device, the user interface to display, within the cell, both the first set of content and the second set of content that is distinct from the first set of content,
wherein updating the user interface comprises displaying the first set of content with text that is presented in a first display format of the first document that is different from text that is presented in a second display format of a second document, text that is presented in the second display format corresponds to a display of the first set of content in the second document, wherein the second document is distinct from the first document.
2 . The method of claim 1 , wherein:
retrieving the first set of content using the first uniform resource identifier includes retrieving the first set of content as plain text; and
displaying the first set of content with the first display format comprises formatting the plain text using the first display format.
3 . The method of claim 1 , wherein retrieving the first set of content using the first uniform resource identifier includes retrieving the first set of content from the second document.
4 . The method of claim 3 , wherein the first document contains a table having the plurality of cells and the second document is a non-spreadsheet format document.
5 . The method of claim 1 , further comprising displaying, by the computing device, a link properties box in the user interface, wherein the link properties box i) includes a list of sets of linked content within the cell, the list of sets including the first set of linked content, and ii) identifies source locations of the first set of content and destination locations of the first set of content.
6 . The method of claim 1 , wherein displaying the cell in the user interface that displays the first document comprises displaying the cell in an editing mode of the user interface for the cell, including updating the user interface to display, within the cell, both the first set of content and the second set of content without displaying the first uniform resource identifier within the cell while in the editing mode of the user interface.
7 . The method of claim 6 , wherein updating the user interface to display, within the cell, both the first set of content and the second set of content without displaying the first uniform resource identifier within the cell while in the editing mode of the user interface comprises displaying a first link indicator adjacent to the first set of content, wherein the first link indicator provides a visual indication in the user interface that the first set of content is linked from the source location that is external to the cell.
8 . The method of claim 7 , wherein the first link indicator is an underline of the first set of content when the first set of content is a numerical value and is a box that surrounds the first set of content when the first set of content is a text value.
9 . The method of claim 1 , wherein:
inserting the first uniform resource identifier into the causal tree comprises inserting into the causal tree a first linking data structure configured to identify i) the first uniform resource identifier, ii) the first set of content, and iii) a destination location within the first document at which the first uniform resource identifier is to be processed; and
the first linking data structure is associated with an external linking system configured to monitor changes to source locations and destination locations.
10 . The method of claim 1 , wherein the first set of content includes a plurality of alphanumeric characters that are collectively represented in the causal tree as a single character that is replaced by the plurality of alphanumeric characters when displayed in the user interface.
11 . The method of claim 1 , wherein the source location of the first set of content is external to the first document.
12 . The method of claim 1 , wherein the source location of the first set of content is a different cell in the first document.
13 . The method of claim 1 , the method further comprising:
receiving, by the computing device, a notice of a change to the first set of content; and
automatically updating, by the computing device, the user interface to display the change to the first set of content, including retrieving, by the computing device, the first set of content using the first uniform resource identifier from the cell.
14 . The method of claim 1 , further comprising:
receiving, by the computing device, a notification of a change to the first set of content from an external linking system configured to monitor changes to source locations and destination locations; and
updating, by the computing device, the user interface to display, within the cell, the change to the first set of content.
15 . The method of claim 1 , wherein the first display format of the first document and the second display format of the second document are one or more of i) different number formats, ii) different date formats, and iii) different text formats.
16 . A computing device comprising a processor, wherein the processor is configured to carry out a method for rendering linked content in a first document having a table with a plurality of cells, the method comprising:
receiving, at the computing device, a first user entry of a first link in a cell of the plurality of cells, wherein i) the first link refers to a first set of content to be displayed in the cell and having a source location that is external to the cell, and ii) before the first link is added to the cell, the cell includes a second set of content that is distinct from the first set of content when displayed;
adding, by the computing device, the first link to the cell, comprising inserting a first uniform resource identifier, which identifies the source location of the first set of content, into a node of a causal tree that represents a history of edits to the cell, wherein nodes of the causal tree represent editing instructions for the cell and include nodes for the second set of content;
displaying, by the computing device, the cell in a user interface that displays the first document, including:
traversing, by the computing device, the causal tree to render the cell;
retrieving, by the computing device, the first set of content using the first uniform resource identifier from the cell; and
updating, by the computing device, the user interface to display, within the cell, both the first set of content and the second set of content that is distinct from the first set of content,
wherein updating the user interface comprises displaying the first set of content with text that is presented in a first display format of the first document that is different from text that is presented in a second display format of a second document, text that is presented in the second display format corresponds to a display of the first set of content in the second document, wherein the second document is distinct from the first document.
17 . The computing device of claim 16 , wherein:
retrieving the first set of content using the first uniform resource identifier includes retrieving the first set of content as plain text; and
displaying the first set of content with the first display format comprises formatting the plain text using the first display format.
18 . The computing device of claim 16 , wherein retrieving the first set of content using the first uniform resource identifier includes retrieving the first set of content from the second document.
19 . The computing device of claim 16 , wherein the first document contains a table having the plurality of cells and the second document is a non-spreadsheet format document.
20 . The computing device of claim 16 , wherein the method carried out by the processor further comprises displaying, by the computing device, a link properties box in the user interface, wherein the link properties box i) includes a list of sets of linked content within the cell, the list of sets including the first set of linked content, and ii) identifies source locations of the first set of content and destination locations of the first set of content.
21 . The computing device of claim 16 , wherein displaying the cell in the user interface that displays the first document comprises displaying the cell in an editing mode of the user interface for the cell, including updating the user interface to display, within the cell, both the first set of content and the second set of content without displaying the first uniform resource identifier within the cell while in the editing mode of the user interface.
22 . The computing device of claim 21 , wherein updating the user interface to display, within the cell, both the first set of content and the second set of content without displaying the first uniform resource identifier within the cell while in the editing mode of the user interface comprises displaying a first link indicator adjacent to the first set of content, wherein the first link indicator provides a visual indication in the user interface that the first set of content is linked from the source location that is external to the cell.
23 . The computing device of claim 22 , wherein the first link indicator is an underline of the first set of content when the first set of content is a numerical value and is a box that surrounds the first set of content when the first set of content is a text value.
24 . The computing device of claim 16 , wherein:
inserting the first uniform resource identifier into the causal tree comprises inserting into the causal tree a first linking data structure configured to identify i) the first uniform resource identifier, ii) the first set of content, and iii) a destination location within the first document at which the first uniform resource identifier is to be processed; and
the first linking data structure is associated with an external linking system configured to monitor changes to source locations and destination locations.
25 . The computing device of claim 16 , wherein the first set of content includes a plurality of alphanumeric characters that are collectively represented in the causal tree as a single character that is replaced by the plurality of alphanumeric characters when displayed in the user interface.
26 . The computing device of claim 16 , wherein the method carried out by the processor further comprises:
receiving, by the computing device, a notice of a change to the first set of content; and
automatically updating, by the computing device, the user interface to display the change to the first set of content, including retrieving, by the computing device, the first set of content using the first uniform resource identifier from the cell.