Computing device for multiple cell linking

Patent metadata

Field	Value
Publication number	US-12541640-B2
Application number	US-202016871512-A
Country	US
Kind code	B2
Filing date	May 11, 2020
Priority date	Apr 30, 2015
Publication date	Feb 3, 2026
Grant date	Feb 3, 2026

Abstract

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.

First claim

What is claimed is:

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

Assignees

• Workiva Inc

Inventors

• Anderson Taylor
• Beam Joshua Allen
• Bolton Brian David
• Childers Kaitlyn Alise
• Erickson Mark David
• Nelson Grant
• Pillar John Christopher
• Stephens Madelyn Renee

Classifications

• G06F16/93

  Document management systems · CPC title

• G06F16/2246

  Trees, e.g. B+trees · CPC title

• G06F3/0481

  based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance · CPC title

• G06F40/18 Primary

  of spreadsheets (form-filling G06F40/174) · CPC title

• G06F40/177

  of tables; using ruled lines · CPC title