Rich data types

• US 10,579,724 B2
• Filed: 11/01/2016
• Issued: 03/03/2020
• Est. Priority Date: 11/02/2015
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Campbell, John, Otero, Carlos Augusto, Rampson, Benjamin Edward, Rutherford, Allison, Canton, Christian, Radakovitz, Samuel C., Peyton Jones, Simon
• Primary Examiner(s): Baderman, Scott T
• Assistant Examiner(s): Level, Barbara M
• Application Number:
  US15/340,187
• Publication Number:
  US 20170124049A1
• Time in Patent Office: 1,218 Days
• CPC Class Codes: G06F 18/00 Pattern recognition
• CPC Class Codes: G06F 3/04817 using icons graphical or visual programming using iconic symbols G06F8/34
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence
• CPC Class Codes: G06F 3/04845 for image manipulation, e.g. dragging, rotation, expansion or change of colour
• CPC Class Codes: G06F 3/04847 Interaction techniques to control parameter settings, e.g. interaction with sliders or dials
• CPC Class Codes: G06F 3/04883 for inputting data by handwriting, e.g. gesture or text
• CPC Class Codes: G06F 3/162 Interface to dedicated audio devices, e.g. audio drivers, interface to CODECs
• CPC Class Codes: G06F 3/165 Management of the audio stream, e.g. setting of volume, audio stream path
• CPC Class Codes: G06F 40/106 Display of layout of documents; Previewing
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 40/197 Version control for software G06F8/71
• CPC Class Codes: G06T 1/0007 Image acquisition
• CPC Class Codes: G06T 11/206 Drawing of charts or graphs
• CPC Class Codes: G06T 11/60 Editing figures and text; Combining figures or text
• CPC Class Codes: G06T 2200/24 involving graphical user interfaces [GUIs]
• CPC Class Codes: G06V 30/40 Document-oriented image-based pattern recognition
• CPC Class Codes: G06V 30/412 Layout analysis of documents structured with printed lines or input boxes, e.g. business forms or tables
• CPC Class Codes: G06V 30/414 Extracting the geometrical structure, e.g. layout tree; Block segmentation, e.g. bounding boxes for graphics or text
• CPC Class Codes: G10L 13/033 : Voice editing, e.g. manipulating the voice of the synthesiser
• CPC Class Codes: G10L 15/26 : Speech to text systems G10L15/08 takes precedence
• CPC Class Codes: G11B 27/00 : Editing; Indexing; Addressing; Timing or synchronising; Monitoring; Measuring tape travel

Abstract

The present disclosure is directed to systems and methods for implementing rich data types in a spreadsheet application. Generally, a value being of a rich data type is as a type of value that has context and established relationships with other types of data. In particular, a rich data type is a data value having associated context, which may be units (e.g., inches, miles, meters, kilograms, seconds, joules, hertz, Fahrenheit, etc.) or other information about the data'"'"'s type (e.g., city, stock, NCAA football team, car, restaurant, school, etc.). Additionally, a value being of a rich data type further includes established relationships with other types of data.

Claims

1. A computer-implemented method for creating an object associated with a first cell of a spreadsheet, comprising:

receiving a data value in the first cell of the spreadsheet;

creating the object including a plurality of value fields and a plurality of type fields, wherein a value field of the plurality of value fields comprises the data value and a type field of the plurality of type fields comprises a data type of the data value;

identifying the data value as a volatile data value, wherein a volatile data value changes over time;

based on the data type of the data value, identifying at least one established relationship with a remote data source storing data for automatically updating the volatile data value with a current data value at each occurrence of a change;

adding the current data value retrieved from the remote data source to the value field of the object;

associating the object with the first cell of the spreadsheet;

receiving a partial entry of a formula into a second cell, wherein the partial entry of the formula references the object in the first cell;

causing display of a reference menu displaying a reference to each value stored in the plurality of value fields of the object in the first cell;

receiving a selection of a first reference to the current data value;

completing the formula by referencing the current data value within the object; and

performing at least one spreadsheet operation based at least in part on the current data value in the value field of the object retrieved from the remote data source.

2. The computer-implemented method of claim 1, wherein the data value is identified as a volatile data value based at least in part on:

a header associated with the cell;

the data type associated with the data value; and

a default data type associated with the first cell.

3. The computer-implemented method of claim 1, wherein a data unit associated with the data value is identified based at least in part on:

a header associated with the first cell;

a data unit associated with at least one related cell; and

a default data unit associated with the first cell.

4. The computer-implemented method of claim 3, wherein the object comprises the data value in the value field of the plurality of value fields and the identified data unit in a unit field of a plurality of unit fields, the method further comprising:

associating a reference table with the spreadsheet, the reference table comprising;

a plurality of data units including at least the identified data unit; and

a plurality of conversion factors for converting a first data unit of the plurality of data units into a second data unit of the plurality of data units.

5. The computer-implemented method of claim 4, further comprising associating the reference table with the object based on one of:

a pointer;

a reference; and

a link.

6. The computer-implemented method of claim 4, further comprising:

identifying a second data value associated with a second data unit in a related cell of the spreadsheet;

determining that the second data unit is inconsistent with the identified data unit;

identifying a conversion factor within the reference table for converting the identified data unit into the second data unit;

converting the second data value into a third data value by applying the conversion factor to the second data value;

replacing the second data value with the third data value in the value field of the object; and

replacing the identified data unit with the second data unit in the unit field of the object.

7. The computer-implemented method of claim 1, the method further comprising:

associating a reference table with the spreadsheet, wherein the reference table comprises a plurality of data values associated with the data type.

8. The computer-implemented method of claim 7, further comprising associating the reference table with the object based on one of:

a pointer;

a reference; and

a link.

9. The computer-implemented method of claim 7, further comprising:

identifying a second data value associated with a related cell of the spreadsheet;

determining that the second data value is inconsistent with the data type of the volatile data value;

accessing the reference table;

providing one or more suggested data values of the plurality of data values associated with the data type; and

receiving a selection of one of the suggested data values.

10. The computer-implemented method of claim 9, further comprising:

replacing the second data value with the selected data value in the related cell of the spreadsheet.

11. A system comprising:

at least one processing unit; and

at least one memory storing computer executable instructions that, when executed by the at least one processing unit, cause the system to perform a method, the method comprising;

identifying a first data value in a first cell of a spreadsheet, wherein a first object associated with the first cell comprises;

the first data value in a first value field of a plurality of value fields; and

a first data type in a first type field of a plurality of type fields;

identifying a second data value as a volatile data value in a second cell of a spreadsheet, wherein the second data value changes over time, wherein a second object associated with the second cell comprises;

the second data value in a second value field of a plurality of value fields; and

a second data type in a second type field of a plurality of type fields;

in response to identifying the second data type, identifying at least one established relationship with a remote data source storing data for automatically updating the second data value with a current data value at each occurrence of a change;

adding the current data value retrieved from the remote data source to the second value field of the second object;

receiving a partial entry of a formula into a third cell, wherein the partial entry of the formula references the second object in the second cell;

causing display of a reference menu displaying a reference to each value stored in the plurality of value fields of the second object in the second cell;

receiving a selection of a reference to the current data value; and

completing the formula by referencing the current data value within the second object.

12. The system of claim 11, wherein the second cell is within at least one of a same column and a same row as the first cell.

13. The system of claim 11, further comprising:

determining that the first data value is inconsistent with the current data value based at least in part on determining that the first data type is different than the second data type.

14. The system of claim 11, further comprising:

providing at least one suggestion for converting the first data value into a third data value associated with the second data type; and

replacing the first data value with the third data value in the first value field of the first object.

15. The system of claim 11, further comprising:

providing at least one suggestion for converting the current data value into a third data value associated with the first data type; and

replacing the current data value with the third data value in the second value field of the second object.

16. A system comprising:

at least one processing unit; and

at least one memory storing computer executable instructions that, when executed by the at least one processing unit, cause the system to perform a method, the method comprising;

identifying a first data value in a first cell of a spreadsheet, wherein a first object associated with the first cell comprises;

the first data value in a first value field of a plurality of value fields; and

a first data unit in a first unit field of a plurality of unit fields;

identifying a second data value as a volatile data value in a second cell of a spreadsheet, wherein the second data value changes over time, wherein a second object associated with the second cell comprises;

the second data value in a second value field of a plurality of value fields; and

a second data unit in a second unit field of a plurality of unit fields;

in response to identifying the second data type, identifying at least one established relationship with a remote data source storing data for automatically updating the second data value with a current data value at each occurrence of a change;

adding the current data value retrieved from the remote data source to the second value field of the second object;

receiving a partial entry of a formula into a third cell, wherein the partial entry of the formula references the second object in the second cell;

causing display of a reference menu displaying a reference to each value stored in the plurality of value fields of the second object in the second cell;

receiving a selection of a reference to the current data value; and

completing the formula by referencing the current data value within the second object.

17. The system of claim 16, wherein the second cell is within at least one of a same column and a same row as the first cell.

18. The system of claim 16, further comprising identifying a reference table associated with the spreadsheet, the reference table comprising:

a plurality of data units including at least the first data unit and the second data unit; and

a plurality of conversion factors for converting a first data unit of the plurality of data units into a second data unit of the plurality of data units.

19. The system of claim 18, further comprising:

identifying a conversion factor between the first data unit and the second data unit;

converting the first data value into a third data value associated with the second data unit; and

associating the third data value and the second data unit with the first object.

20. The system of claim 19, further comprising:

receiving a selection to convert the first data value into the third data value associated with the second data unit.

21. The system of claim 19, further comprising:

automatically converting the first data value into the third data value in response to determining that the first data value and the current data value are inconsistent.

22. The system of claim 18, further comprising:

identifying a conversion factor between the first data unit and the second data unit;

converting the current data value into a third data value associated with the first data unit; and

associating the third data value and the first data unit with the second object.

23. The system of claim 22, further comprising:

receiving a selection to convert the current data value into the third data value associated with the first data unit.

24. The system of claim 16, further comprising:

determining that the first data value is inconsistent with the current data value based at least in part on determining that the first data unit is different than the second data unit.