Browse Prior Art Database

Filter Basing On Object Properties

IP.com Disclosure Number: IPCOM000129992D
Original Publication Date: 2005-Oct-09
Included in the Prior Art Database: 2005-Oct-09
Document File: 2 page(s) / 185K

Publishing Venue

IBM

Abstract

In the current Spreadsheet software, only the text context of a data object can be manipulated for filtering. But this invention states the properties of an data object will be able to be manipulated for filtering. The object properties can be cell pattern, and character format . The row(s) containing object(s) with same properties will be filtered and visible by applying this condition of filtering.

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 60% of the total text.

Page 1 of 2

Filter Basing On Object Properties

1. Background:

Manipulating an object or a set of objects to make the certain rows (records) that include the object(s) in worksheet are visible is facilitated by filter mechanism in spreadsheet software. But in the current Spreadsheet software, only the text content or data of an object can be manipulated for filtering. A user can define ranges which contain the values in particular data fields. The user uses the stand filter to connect up to three conditions with either a logical AND or a logical OR operation, or advanced filter to connect to more that three conditions. However, when a user wants to filter all of the rows that contain objects with particular properties in the currently Spreadsheet software, there is no this functionality available. For example, [1] a user wants to see all of the rows containing Red background. [2] a user want to see all of the rows containing Bold data.

2. Summary of Invention:

The present invention satisfies the above-describe needs, i.e. implements data filter that bases on object properties, including data format property, and cell pattern by providing an improved method. The improved method applies filter on the object properties. The filter selects the worksheet columns containing the objects with particular properties or same properties, and then make the worksheet rows/records be visible by applying this condition of filtering. The present invention improves the usability of the Spreads...