US 8,510,645 B2Granted

Method of applying a function to a data set

AssigneeCanon Kabushiki Kaisha

InventorsJoel Timothy Beach, Alexander Will

Life of this patent

Estimating the term…

Loading patent…

Abstract

Disclosed is a method of applying a function to a set of data. Initially a tabular representation of the set of data is displayed, the representation comprising a plurality of columns. The data in the representation is grouped in each column based upon an order of the at least one column in the tabular representation. The method also generates a new column of data comprising a transform of existing column data contained in the tabular representation, wherein transform data within the new column depends upon a grouping context of the existing column data. Desirably the method further repositions the new column of data in the tabular representation and updates the transform data in the new column in accordance with a destination grouping context of a destination position of the new column in the tabular representation.

Claims11

Dependent claims

A computer-implemented method of updating a display of a tabular representation, said method comprising the steps of:

(i) generating a tabular representation of a set of data, said representation comprising a plurality of columns containing the set of data;
(ii) grouping the set of data by grouping a plurality of identical rows in at least one column to form a plurality of groups in each column of the tabular representation, said grouping being based on data in at least one column of the tabular representation;
(iii) generating an aggregate column in the tabular representation comprising aggregate data derived from an aggregate function applied to at least some of the set of data based on the grouping of the data in an existing column;
(iv) displaying the tabular representation with the aggregate column of data;
(v) moving the aggregate column in the tabular representation;
and
(vi) updating the display of the tabular representation,
wherein vertically adjacent cells within the moved aggregate column are grouped according to grouping of vertically left adjacent data within a second column of the tabular representation adjacent the moved aggregate column, and wherein the aggregate data in the moved aggregate column is determined by applying the aggregate function to at least some of the set of data in the existing column selected according to the grouping of the data in the second column adjacent the moved aggregate column to calculate an aggregate value for each group in the aggregate column when the aggregate column is moved, wherein the vertically left adjacent data within the second column corresponds to the set of data in the existing column,
wherein at least first and second columns of the tabular representation display a grouping hierarchy relationship, so that the first column is displayed to the left of the second column and occupies a higher position in the hierarchy than the second column.

6 more elements

A non-transitory computer readable storage medium encoded with a computer program executable to perform a method of updating the display of a tabular representation, said method comprising:

(i) generating a tabular representation of the set of data, said representation comprising a plurality of columns containing the set of data;
(ii) grouping the set of data by grouping a plurality of identical rows in at least one column to form a plurality of groups in each column of the tabular representation, said grouping being based on data in at least one column of the tabular representations;
(iii) generating an aggregate column in the tabular representation comprising aggregate data derived from an aggregate function applied to at least some of the set of data based on the grouping of the data in an existing column;
(iv) displaying the tabular representation with the aggregate column of data;
(v) moving the aggregate column of data in the tabular representation;
and
(vi) updating the display of the tabular representation,
wherein vertically adjacent cells within the moved aggregate column are grouped according to grouping of vertically left adjacent data within a second column of the tabular representation adjacent the moved aggregate column, and wherein the aggregate data in the moved aggregate column is determined by applying the aggregate function to at least some of the set of data in the existing column selected according to the grouping of the data in the second column adjacent the moved aggregate column to calculate an aggregate value for each group in the aggregate column when the aggregate column is moved, wherein the vertically left adjacent data within the second column corresponds to the set of data in the existing column,
wherein at least first and second columns of the tabular representation display a grouping hierarchy relationship, so that the first column is displayed to the left of the second column and occupies a higher position in the hierarchy than the second column.

6 more elements

Computer apparatus for updating a display of a tabular representation applying a function to a set of data, said apparatus comprising:

a memory storing the set of data;
a display for displaying a tabular representation of a set of data, said representation comprising a plurality of columns containing the set of data;
and
a processor configured for:
detecting a user input associated with a grouping of the set of data by grouping a plurality of identical rows in at least one column to form a plurality of groups in each column of the tabular representation, said grouping being based on data in at least one said column of the tabular representation;
generating an aggregate column in the tabular representation comprising aggregate data derived from an aggregate function applied to at least some of the set of data based on the grouping of the data in an existing column;
displaying the tabular representation with the aggregate column of data;
moving the aggregate column of data in the tabular representation;
and updating the display of the tabular representation,
wherein vertically adjacent cells within the moved aggregate column are grouped according to grouping of vertically left adjacent data within a second column of the tabular representation adjacent the moved column, and wherein the aggregate data in the moved aggregate column is determined by applying the aggregate function to at least some of the set of data in the existing column selected according to the grouping of the data in the second column adjacent the moved aggregate column to calculate an aggregate value for each group in the aggregate column when the aggregate column is moved,
wherein the vertically left adjacent data within the second column corresponds to the set of data in the existing column,
wherein at least first and second columns of the tabular representation display a grouping hierarchy relationship, so that the first column is displayed to the left of the second column and occupies a higher position in the hierarchy than the second column.

9 more elements

Dependencies are inferred from the claim text.