Extensibility of compound data objects

Patent metadata

Field	Value
Publication number	US-10963635-B2
Application number	US-201615340251-A
Country	US
Kind code	B2
Filing date	Nov 1, 2016
Priority date	Nov 2, 2015
Publication date	Mar 30, 2021
Grant date	Mar 30, 2021

Abstract

Aspects of the present disclosure further provide the ability to define, among other features, the layout of the cell view of the cell in which the compound object is stored as well as the card view of the compound object. Aspects of the present disclosure further provide the ability to modify properties associated with the values stored in a compound object, including, but not limited to properties of calculated values, value formatting, and permissions.

First claim

What is claimed is:

1. 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 operations comprising:
creating a compound object associated with a spreadsheet cell, the compound object including:
a first field with a first value,
a first visibility property defining whether the first value is visible or not visible in a cell view contained by the spreadsheet cell,
a second field with a second value, and
a second visibility property defining whether the second value is visible or not visible in the cell view contained by the spreadsheet cell;

providing, for display, the cell view of the spreadsheet cell with the first value visible based on the first visibility property and the second value visible based on the second visibility property;
receiving an indication of a change to the first visibility property; and
providing, for display, an updated cell view of the spreadsheet cell with the first value not visible based on the change to the first visibility property and the second value maintained as visible based on the second visibility property.

2. The system of claim 1 , wherein the indication of the change to the first visibility property is received at a schema properties user interface.

3. The system of claim 2 , wherein the schema properties user interface displays the first field, the first visibility property, the second field, and the second visibility property.

4. The system of claim 3 , wherein the first visibility property defines a permission level of the first field, the permission level defining one or more users who can view the first value.

5. The system of claim 1 , wherein the computer executable instructions that, when executed by the at least one processing unit, cause the system to perform the operations comprising:
receiving an indication of a second change to the first visibility property;
determining, based on the indication of the second change, to update the cell view; and
based on a determination, updating the cell view.

6. The system of claim 1 , wherein the computer executable instructions that, when executed by the at least one processing unit, cause the system to perform the operations comprising, based on the change to the first visibility property, updating a card view of the compound object.

7. The system of claim 1 , wherein the computer executable instructions that, when executed by the at least one processing unit, cause the system to perform the operations comprising updating a schema of the compound object in response to receiving the indication of the change to the first visibility property.

8. A method comprising:
creating a compound object associated with a spreadsheet cell, the compound object including:
a first field with a first value,
a first visibility property defining whether the first value is visible or not visible in a cell view contained by the spreadsheet cell,
a second field with a second value, and
a second visibility property defining whether the second value is visible or not visible in the cell view contained by the spreadsheet cell;
providing, for display, the cell view of the spreadsheet cell with the first value not visible based on the first visibility property and the second value visible based on the second visibility property;
receiving an indication of a change to the first visibility property; and
providing, for display, an updated spreadsheet cell with the first value visible based on the change to the first visibility property and the second value maintained as visible based on the second visibility property.

9. The method of claim 8 , wherein the indication of the change to the first visibility property is received at a schema properties user interface.

10. The method of claim 9 , wherein the schema properties user interface displays the first field, the first visibility property, the second field, and the second visibility property.

11. The method of claim 10 , wherein the first visibility property defines a permission level of the first field, the permission level of the first field defining a first set of one or more users who can view the first value.

12. The method of claim 10 , wherein the second visibility property defines a permission level of the second field, the permission level of the second field defining a second set of one or more users who can view the second value.

13. The method of claim 10 , further comprising based on the change to the first visibility property, updating a card view of the compound object.

14. The method of claim 10 , further comprising updating a schema of the compound object in response to receiving the indication of the change to the first visibility property.

15. The method of claim 8 , further comprising:
receiving an indication of a second change to the first visibility property;
determining, based on the indication of the second change, to update the cell view; and
based on a determination, updating the cell view.

16. A computer-readable storage medium storing computer executable instructions that, when executed by at least one processing unit, cause a computing device to:
create a compound object associated with a spreadsheet cell, the compound object including:
a first field with a first value,
a first visibility property defining whether the first value is visible or not visible in a cell view contained by the spreadsheet cell,
a second field with a second value, and
a second visibility property defining whether the second value is visible or not visible in the cell view contained by the spreadsheet cell;
provide, for display, the cell view of the spreadsheet cell with the first value visible based on the first visibility property and the second value not visible based on the second visibility property;
receive an indication of a change to the first visibility property; and
provide, for display, an updated cell view of the spreadsheet cell with the first value not visible based on the change to the first visibility property and the second value maintained as not visible based on the second visibility property.

17. The computer-readable storage medium of claim 16 , wherein the first visibility property defines a permission level of the first field, the permission level defining one or more users who can view the first value.

18. The computer-readable storage medium of claim 16 , wherein the indication of the change to the first visibility property is received at a schema properties user interface.

19. The computer-readable storage medium of claim 18 , wherein the schema properties user interface displays the first field, the first visibility property, the second field, and the second visibility property.

20. The computer-readable storage medium of claim 16 , wherein the computer executable instructions that, when executed by at least one processing unit, further cause the computing device to update a schema of the compound object in response to receiving the indication of the change to the first visibility property.

Assignees

• Microsoft Technology Licensing Llc

Inventors

• Campbell John
• Rampson Benjamin Edward
• Canton Christian
• Peyton Jones Simon

Classifications

• G06F3/04883

  for inputting data by handwriting, e.g. gesture or text · CPC title

• G06F40/18 Primary

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

• G06F3/0486

  Drag-and-drop · CPC title

• G06F3/0482

  Interaction with lists of selectable items, e.g. menus · CPC title

• G06F3/04842

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