Filter and sort by color

Details Filter and sort by color Filter and sort by color

2004-12-15

2010-12-07

Desai, Rachna S (Department: 2176)

Data processing: presentation processing of document, operator i

Presentation processing of document

Spreadsheet

C715S217000, C715S218000, C715S220000

Reexamination Certificate

active

07849395

ABSTRACT:
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.

REFERENCES:
patent: 5861885 (1999-01-01), Strasnick et al.
patent: 6613098 (2003-09-01), Sorge et al.
patent: 6738770 (2004-05-01), Gorman
patent: 6988241 (2006-01-01), Guttman et al.
patent: 2001/0045965 (2001-11-01), Orbanes et al.
patent: 2002/0036656 (2002-03-01), Francis et al.
patent: 2002/0116417 (2002-08-01), Weinberg et al.
patent: 2002/0143780 (2002-10-01), Gorman
patent: 2003/0051209 (2003-03-01), Androski et al.
patent: 2003/0188256 (2003-10-01), Aureglia et al.
patent: 2003/0188257 (2003-10-01), Aureglia et al.
patent: 2004/0049730 (2004-03-01), Ishizaka
patent: 2004/0163039 (2004-08-01), Gorman
patent: 2004/0249852 (2004-12-01), Aureglia et al.
patent: 2005/0197894 (2005-09-01), Fairbanks et al.
patent: 2005/0232055 (2005-10-01), Couckuyt et al.
patent: 2006/0041834 (2006-02-01), Chen et al.
patent: 2006/0074866 (2006-04-01), Chamberlain et al.
patent: 2006/0075328 (2006-04-01), Becker et al.
patent: 2006/0085742 (2006-04-01), Harold et al.
patent: 2006/0106844 (2006-05-01), Naick et al.
patent: 2006/0107196 (2006-05-01), Thanu et al.
patent: 2006/0190814 (2006-08-01), Collie et al.
patent: 2007/0143661 (2007-06-01), Machalek
Goshen College, “Lesson 4: Filtering & Sorting”, Aug. 2003, Available Online at: http://www.goshen.edu/edtech/tutorials/excel/filter.htm.
DigDB.com, “Excel Sorting by Text Value, Text Length, Cell Color, Font Style” (as supplied by the IDS submitted on Dec. 23, 2009), pp. 1-5, Nov. 9, 2004, Retrieved from the Internet at the following URL: http://web.archive.org/web/20041109064316/http://www.digdb.com/excel—add—ins/sort—custom—text—length—color/.
Communication from the EPO for Application No. 05112248.9, dated May 20, 2008 (Reference EP36918RK900aha).
Notice of First Office Action, Patent Office of the People's Republic of China, dispatched Aug. 8, 2008, Application No. 200510125033.X.
Notice of Second Office Action, Patent Office of the People's Republic of China, dispatched Jul. 10, 2009, Application No. 200510125033.X (6 pages).
Official Communication from the EPO for Application 05 112 248.9, dated Feb. 4, 2009 (3 pages).
Communication from the EPO for Application 05 112 248.9, dated Nov. 11, 2009 (7 pages).
Barton, M. “Custom Sort Order” Internet Publication [Online] Feb. 24, 2004, Retrieved from the Internet: URL: http://www.keyongtech.com/196738-custom-sort-order> [retrieved on Oct. 5, 2009] (3 pages).
Schneider, D. “Sort Order Best practice Request” Internet Publication [Online] Oct. 17, 2003, Retrieved from the Internet: URL: http://www.mail-archive.com/cf-talk@houseoffusion.com/msg156700.html [retrieved on Oct. 5, 2009] (4 pages).
Notice of Allowance dated Dec. 4, 2009, issued in Chinese Application No. 200510125033.X (4 pages).
European Search Report for EP 05 11 2248.9.
Darling, Jeff et al. “Sort by Color?” Internet publication [online], Jun. 5, 2002 [retrieved on Mar. 6, 2008], search report reference XP002468614. Retrieved from the internet: <URL: http://groups.google.de/group/microsoft.public.excel.worksheet.functions/browse—thread/thread/55feeaa307ef93de/e35677aec50ad972?h1=en&Ink=st&q=excel+%22sort+by+color%22#e35677aec50ad972>.
“Excel Sorting by Text Value, Text Length, Cell Color, Font Style,” DigDB.com [online], Nov. 9, 2004 [retrieved on Mar. 6, 2008], search report reference XP002468612. Retrieved from the internet: <URL: http://web.archive.org/web/20041109064316/http://www.digdb.com/excel—add—ins/sort—custom—text—length—color/>.
Microsoft: “Microsoft Excel 2000—Lesson 7 and 18” (Microsoft Press, 1999). ISBN 1-57231-974-7, search report reference XP002468615.
Rees, Gareth et al., “Putting code in standard module, Sort by Color,” Internet publication [online], Nov. 8, 2002 [retrieved on Mar. 6, 2008], search report reference XP002468613. Retrieved from the intemet: <URL: http://groups.google.de/group/microsoft.public.excel.worksheet.functions/browse—thread/thread/81463226c7dbb883/926f479d5dbd0ba6?h1=en&1nk=st&q=excel+%22sort+by+color%22#926f479d5bdd0ba6>.

Affiliated with

Also associated with

Rating

Filter and sort by color does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Filter and sort by color, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Filter and sort by color will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4179219