Multiple datapoint formats in spreadsheets

Patent metadata

Field	Value
Publication number	US-11893343-B2
Application number	US-202117521568-A
Country	US
Kind code	B2
Filing date	Nov 8, 2021
Priority date	Nov 8, 2021
Publication date	Feb 6, 2024
Grant date	Feb 6, 2024

Abstract

Systems, methods, and software are disclosed herein that allow multiple values to be stored and referenced individually in a spreadsheet or table cell. In an implementation, an application identifies a format of a cell in a spreadsheet with a format having multiple data points. The application receives multiple values corresponding to the multiple data points and stores each value of the multiple values in the cell as a separately referenceable value with respect to each other value of the multiple values. In some implementations, formulas in other cells or sub-routines can reference an individual one of the values in the cell.

First claim

What is claimed is:

1. A computing apparatus comprising:
one or more computer readable storage media;
one or more processors operatively coupled with the one or more computer readable storage media; and
a spreadsheet application comprising program instructions stored on the one or more computer readable storage media that, when executed by the one or more processors, direct the computing apparatus to at least:
identify a format of a first cell and a second cell in a spreadsheet hosted by the spreadsheet application, wherein the format comprises multiple data points;
receive user input from a user via a user interface to the spreadsheet application, wherein the user input comprises a selection of an option to share, via a relay service remote with respect to the computing apparatus, an instance of the first cell and an instance of the second cell with a second application of a type that differs from the spreadsheet application, wherein the second application resides on a second computing apparatus associated with a second user;
receive, from the relay service, multiple values corresponding to the multiple data points of the first cell input by the second user via a user interface to the second application and returned by the second application via the relay service to the spreadsheet application;
store each value of the multiple values in text of the first cell as a separately referenceable value with respect to each other value of the multiple values;

display at least a portion of the text of the first cell such that at least one value of the multiple values is visible in a user interface of the computing apparatus;
receive a state change to at least one of multiple data points of the second cell input by the user via the user interface to the spreadsheet application; and
send the state change to the at least one of the multiple data points of the second cell, via the relay service, to the second application.

2. The computing apparatus of claim 1 wherein the spreadsheet comprises a group of cells that include the first cell and wherein the program instructions further direct the computing apparatus to at least display the group of cells in the user interface and, in response to a selection of the first cell, display an input module in the user interface through which to enter the multiple values into the first cell.

3. The computing apparatus of claim 2 wherein the input module comprises multiple input elements corresponding to the multiple data points of the first cell, wherein each one of the multiple input elements is configured to receive an individual one of the multiple values.

4. The computing apparatus of claim 1 wherein the program instructions further direct the computing apparatus to at least:
determine that a formula defined in a different cell includes a reference to a data point of the multiple data points in the first cell;
obtain a one value of the multiple values in the first cell that corresponds to the data point referenced by the formula; and
calculate a result of the formula based at least on the one value.

5. The computing apparatus of claim 1 wherein the program instructions further direct the computing apparatus to at least:
determine that a formula defined in a sub-procedure associated with the spreadsheet includes a reference to a data point of the multiple data points in the first cell;
obtain a one value of the multiple values in the first cell that corresponds to the data point referenced by the formula; and
calculate a result of the formula based at least on the one value.

6. The computing apparatus of claim 1 wherein the format comprises a custom schema defined in accordance with a standard notation, and wherein the program instructions further direct the computing apparatus to receive user input comprising the custom schema.

7. The computing apparatus of claim 6 wherein the standard notation comprises JavaScript Object Notation (JSON), and wherein the custom schema identifies a name for each of the multiple data points and a type for each of the multiple data points.

8. A method of operating a computing device comprising:
on the computing device, identifying a format of a first cell and a second cell in a spreadsheet hosted by a spreadsheet application, wherein the format comprises multiple data points;
on the computing device, receiving user input from a user via a user interface to the spreadsheet application, wherein the user input comprises a selection of an option to share, via a relay service remote with respect to the computing device, an instance of the first cell and an instance of the second cell with a second application of a type that differs from the spreadsheet application, wherein the second application resides on a second computing apparatus associated with a second user;
on the computing device, receiving, from the relay service, multiple values corresponding to the multiple data points of the first cell input by the second user via a second user interface to the second application and returned by the second application via the relay service to the spreadsheet application;
on the computing device, storing each value of the multiple values in text of the first cell as a separately referenceable value with respect to each other value of the multiple values;
display at least a portion of the text of the first cell such that at least one value of the multiple values is visible in the user interface of the computing device;
on the computing device, receiving a state change to at least one of the multiple data points of the second cell input by the user via the user interface to the spreadsheet application; and
on the computing device, sending the state change to the at least one of the multiple data points of the second cell, via the relay service, to the second application.

9. The method of claim 8 wherein the spreadsheet comprises
a group of cells that include the first cell and wherein the method further comprises: displaying the group of cells in the user interface; and
in response to a selection of the first cell, displaying an input module in the user interface through which to enter the multiple values into the first cell.

10. The method of claim 9 wherein the input module comprises multiple input elements corresponding to the multiple data points of the first cell, wherein each one of the multiple input elements is configured to receive an individual one of the multiple values.

11. The method of claim 8 wherein the method further comprises:
determining that a formula defined in a different cell includes a reference to a data point of the multiple data points in the first cell;
obtaining a one value of the multiple values in the first cell that corresponds to the data point referenced by the formula; and
calculating a result of the formula based at least on the one value.

12. The method of claim 11 wherein the method further comprises:
determining that a formula defined in a sub-procedure associated with the spreadsheet includes a reference to a data point of the multiple data points in the first cell;
obtaining a one value of the multiple values in the first cell that corresponds to the data point referenced by the formula; and
calculating a result of the formula based at least on the one value.

13. The method of claim 8 wherein the format comprises a custom schema defined in accordance with a standard notation, and wherein the method further comprises receiving user input comprising the custom schema.

14. The method of claim 13 wherein the standard notation comprises JavaScript Object Notation (JSON), and wherein the custom schema ide

Assignees

• Microsoft Technology Licensing Llc

Inventors

• Liddell Derek

Classifications

• G06F40/18 Primary

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

• H04L67/04

  specially adapted for terminals or networks with limited capabilities; specially adapted for terminal portability · CPC title

• G06F3/04842

  Selection of displayed objects or displayed text elements (G06F3/0482 takes precedence) · CPC title

• G06F40/174

  Form filling; Merging · 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