Filter and sort by format

摘要

The present invention comprises methods and user interfaces for organizing data displayed within a data application. Specifically, the present invention provides methods and systems for arranging the display of the data by a format applied to one or more portions of the data. The formats comprise different visual characteristics of the displayed data. In exemplary embodiments, the data application organizes the data by the fill color of the cell, the font color of the data within the cell, or the type of icon inserted into the cell. The organizations comprise any type of rearrangement of the data. In exemplary embodiments, the data application sorts or filters the displayed data according to the format.

主权项

1. A method executable on a computer system for organizing data cells, the computer system having a graphical user interface including a display device and one or more user interface selection devices, the method comprising:
displaying a sheet comprising a plurality of data cells, wherein at least one data cell of the plurality of data cells is associated with a first format, wherein at least one data cell of the plurality of data cells is associated with a second format, wherein at least one data cell of the plurality of data cells is associated with a third format, and wherein the first format, the second format, and the third format are different formats of a same format type; receiving a selection of data cells, wherein the selected data cells comprise less than all of the plurality of data cells, wherein the selected data cells comprise at least one data cell associated with the first format and at least one data cell associated with the second format, wherein the selected data cells are not associated with the third format, and wherein at least one non-selected data cell of the plurality of data cells is associated with the third format; displaying on the display device a menu, wherein the menu includes options for organizing the selected data cells, and wherein the options comprise the first format and the second format but not the third format; organizing the selected data cells based on the first format; displaying the organized data cells, including displaying the at least one data cell having the first format and the at least one data cell having the second format; and simultaneously displaying the at least one non-selected data cell associated with the third format.