Slicer elements for filtering tabular data

Patent metadata

Field	Value
Publication number	US-10324592-B2
Application number	US-201615222842-A
Country	US
Kind code	B2
Filing date	Jul 28, 2016
Priority date	Oct 31, 2011
Publication date	Jun 18, 2019
Grant date	Jun 18, 2019

Abstract

Slicers are configured to filter tabular data arranged in columns. A user may use the slicers to filter tabular data from a client application and/or a server based application/service. Slicers may be created for one or more columns and for all/portion of the tabular data within a column. Selection of a slicer element filters the associated tabular data and updates a display of the other slicers. Interaction with the slicers may also update other user interface controls that filter the tabular data (e.g. selecting a slicer element changes a value of a filtering setting in a drop down menu and/or selecting the filtering setting in the drop down menu changes a state of a slicer element). A slicer element may be associated with other objects in the spreadsheet and/or included within one or more functions of a spreadsheet.

First claim

What is claimed is:

1. A system comprising at least one processor operatively coupled to at least one computer storage device, the computer storage device having computer-executable instructions configured for:
displaying slicer elements associated with tabular data, wherein the tabular data does not include a pivot table and the slicer elements comprise a first slicer element and a second slicer element;
receiving a selection of the first slicer element;
based on the selection of the first slicer element, automatically updating a display of the tabular data to only display the tabular data associated with the first slicer element; and
based on a change to the tabular data, automatically updating the display of the slicer elements based on the change to the tabular data.

2. The system of claim 1 , wherein receiving the selection of the first slicer element comprises one of:
receiving a touch input to the first slicer element; or
hovering over the first slicer element.

3. The system of claim 1 , wherein automatically updating the display of the tabular data comprises automatically hiding one or more rows of displayed tabular data that is associated with the second slicer element.

4. The system of claim 1 , wherein displaying the slicer elements comprises displaying a first slicer and associated two or more slicer elements separately from a second slicer and associated two or more slicer elements, wherein the two or more slicer elements associated with the first slicer include the first slicer element and the two or more slicer elements associated with the second slicer include the second slicer element.

5. The system of claim 1 , wherein receiving the selection of the first slicer element occurs at a client computing device.

6. The system of claim 1 , further comprising defining a slicer element in the slicer elements as an object within a spreadsheet that is referenced by a user-defined function.

7. The system of claim 1 , further comprising filtering the tabular data in response to the selection of the first slicer element, wherein the filtering of the tabular data is configurable to filter hidden tabular data within a spreadsheet; non-hidden data within the spreadsheet; and a query associated with the filter.

8. A computer implemented method comprising:
displaying slicer elements associated with tabular data, wherein the tabular data does not include a pivot table;
receiving a selection of at least one slicer element;
based on the selection of the at least one slicer element, updating a display of the tabular data to only display the tabular data associated with the at least one slicer element; and
based on a change to the tabular data, automatically updating the display of the slicer elements based on the change to the tabular data, wherein updating the display comprises at least one of:
stop displaying a slicer element associated with data deleted from the tabular data; or
adding a new slicer element based on an addition of data to the tabular data.

9. The method of claim 8 , wherein receiving the selection of each slicer element comprises at least one of:
receiving a touch input to a slicer element; or
hovering over a slicer element.

10. The method of claim 8 , wherein updating the display of the tabular data comprises hiding one or more rows of displayed tabular data that is associated with the one or more slicer elements.

11. The method of claim 8 , wherein displaying the slicer elements comprises displaying a first slicer and associated slicer elements separately from a second slicer and associated slicer elements.

12. The method of claim 8 , wherein receiving the selection of the at least one slicer element occurs at a client computing device.

13. A computer implemented method comprising:
generating slicer elements associated with tabular data, wherein the tabular data does not include a pivot table and the slicer elements comprise a first slicer element and a second slicer element;
displaying the slicer elements;
receiving a selection of the first slicer element;
based on the selection of the first slicer element, updating a display of the tabular data to only display the tabular data associated with the first slicer element; and
based on a change to the tabular data, automatically updating the display of the slicer elements based on the change to the tabular data, wherein updating the display comprises at least one of:
based on a deletion of data from the tabular data, stop displaying a slicer element associated with the deleted data;
based on a modification to data in the tabular data, modifying a slicer element associated with the modified data; or
based on an addition of data to the tabular data, adding a new slicer element.

14. The method of claim 13 , wherein receiving the selection of the first slicer element comprises at least one of:
receiving a touch input to the first slicer element; or
hovering over the first slicer element.

15. The method of claim 13 , further comprising updating the display of the tabular data by hiding one or more rows of displayed tabular data that is associated with the second slicer element.

16. The method of claim 13 , wherein displaying the slicer elements comprises displaying a first slicer separately from a second slicer, wherein the first slicer element is associated with the first slicer and the second slicer element is associated with the second slicer.

17. A hardware-device storing instructions that, when executed, cause at least one processor to execute a method, the method comprising:
generating slicer elements associated with tabular data, wherein the tabular data does not include a pivot table;
displaying the slicer elements;
receiving a selection of a first slicer element;
based on the selection of the first slicer element, automatically filtering the tabular data based on the selection of the first slicer element;
based on the automatic filtering, automatically updating a display of the tabular data to only display the tabular data associated with the first slicer element; and
based on a change to the tabular data, automatically updating the display of the slicer elements based on the change to the tabular data.

18. The hardware-device of claim 17 , wherein updating the display of the tabular data comprises hiding one or more rows of displayed tabular data that is associated with a second slicer element.

Assignees

• Microsoft Technology Licensing Llc

Inventors

• Campbell Johnny Sterling
• Monroe Jenefer
• Tupaj Konrad
• Grewal Amarinder Singh
• Hawking Robert George
• Folting Allan

Classifications

• G06F40/177 Primary

  of tables; using ruled lines · CPC title

• G06F40/18

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

• G06F3/04886

  by partitioning the display area of the touch-screen or the surface of the digitising tablet into independently controllable areas, e.g. virtual keyboards or menus · CPC title

• G06F9/451

  Execution arrangements for user interfaces · CPC title

• G06F3/04847

  Interaction techniques to control parameter settings, e.g. interaction with sliders or dials · CPC title