Patent
1993-03-10
1994-05-31
Herndon, Heather R.
395157, 395161, G06F 1562
Patent
active
053176863
ABSTRACT:
Spreadsheet apparatus enables reformatting and renaming of items forming the spreadsheet. A series of items forms a dimension along an axis of the spreadsheet. A label icon or labelling entity is user nameable to describe the series of items of an axis. Repositioning of the label icons repositions respective series of items and thus redefines/rearranges the axes of the spreadsheet. Sub-axes to an axis are similarly formed by series of items associated with a respective label icon. Order of label icons in predefined areas of a working screen view determine hierarchy of main axis and sub-axes for the label icons. There is a different predefined area for the possible vertical axes, possible horizontal axes, and the possible orthogonal axes of the spreadsheet. A cell module holds spreadsheet data in a matrix of memory cells. A symbol table translates between current specified names of items in the spreadsheet and indexes to cells of the cell module. Thus, a user is able to rearrange and/or relabel icons in the spreadsheet screen view to reformat the spreadsheet, and the supporting computer members provide display of the spreadsheet rearranged according to position of the icons without losing data of the items as held in respective intersections of the spreadsheet.
REFERENCES:
patent: 4601003 (1986-07-01), Yoneyama et al.
patent: 4712191 (1987-12-01), Penna
patent: 4899136 (1990-02-01), Beard et al.
patent: 4901221 (1990-02-01), Kodosky et al.
patent: 5018077 (1991-05-01), Healey
patent: 5033009 (1991-07-01), Dubnoff
patent: 5043916 (1991-08-01), Kawai
patent: 5055998 (1991-10-01), Wright et al.
patent: 5065347 (1991-11-01), Pajak et al.
patent: 5093907 (1992-03-01), Hwong et al.
1-2-3 Release 2.2 Quick Reference, 1989, pp. 1-13, 18-19, 38-49, 57-58, 62-65, 86-154.
Microsoft Works User's Guide, 1989, pp. 103-143.
Antonoff, "New Dimensions for Spreadsheets", Personal Computing, Mar. 1988, pp. 122-130.
Jackson, "Graphic Expansion", PC User, Apr. 11, 1990, p. 48(6).
Stinson, "1-2-3, Release 3", PC Magazine, Sep. 12, 1989, pp. 33-36.
Lucid 3-D Tutorial Guide, Personal Computer Support Group, Inc., 1987, pp. 15-26-15-27, Chpts. 16, 22-23, 17-1.
"Number Crunching Takes On New Dimensions" by Judy Duncan, Info World, Product Comparison Section pp. 51-59, Jul. 9, 1990.
Tore Risch et al., "A Functional Approach to Integrating Database and Expert Systems", Communications of the ACM, Dec. 1988, vol. 31, No. 12, pp. 1424-1437.
Weichang Du et al., "A 3D Spreadsheet Based on Intensional Logic", IEEE Software, May 1990, No. 3, Los Alamitos, Calif., pp. 78-89.
Edelson Glenn D.
Kleppner Paul S.
Salas R. Pito
Shaver Robert S.
Breene John E.
Herndon Heather R.
Lotus Development Corporation
LandOfFree
Data processing apparatus and method for a reformattable multidi does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Data processing apparatus and method for a reformattable multidi, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Data processing apparatus and method for a reformattable multidi will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1634369