System and methods for improved spreadsheet interface with user-familiar objects

• US 5,664,127 A
• Filed: 02/28/1996
• Issued: 09/02/1997
• Est. Priority Date: 04/08/1992
• Status: Expired due to Term

• Current Assignee: Borland Software Corporation (Open Text Corporation)
• Original Assignee: Borland International, Inc. (Open Text Corporation)
• Inventors: Anderson, Charles, Warfield, Robert W., Cseri, Istvan, Low, Murray K., Liaw, Weikuo, Bush, Alan M.
• Primary Examiner(s): Feild, Joseph H.
• Application Number:
  US08/608,448
• Time in Patent Office: 552 Days
• Field of Search: 395/155-161, 395/600, 395/326, 395/333-335, 395/339-340, 395/342, 395/348, 395/349, 395/350, 395/352-354, 395/764-765, 395/938, 395/939, 395/967 , 395/614, 395/615
• US Class Current: 715/776
• CPC Class Codes: G06F 3/0481 based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
• CPC Class Codes: G06F 3/0483 Interaction with page-structured environments, e.g. book metaphor
• CPC Class Codes: G06F 40/10 Text processing natural language analysis G06F40/20; semantic analysis G06F40/30; processing or translation of natural language G06F40/40
• CPC Class Codes: G06F 40/103 Formatting, i.e. changing of presentation of documents automatic justification G06F40/189; automatic line break hyphenation G06F40/191
• CPC Class Codes: G06F 40/117 Tagging; Marking up details of markup languages G06F40/143; Designating a block; Setting of attributes style sheets, e.g. eXtensible Stylesheet Language Transformation [XSLT], G06F40/154
• CPC Class Codes: G06F 40/12 Use of codes for handling textual entities
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 8/38 for implementing user interfaces
• CPC Class Codes: G06F 9/451 Execution arrangements for user interfaces
• CPC Class Codes: Y10S 715/973 Scroll tool, e.g. window scroll bar

Abstract

An electronic spreadsheet system includes a notebook interface having a plurality of notebook pages, each of which may contain a spread of information cells, or other desired page type (e.g., Graphs page). Methods are provided for rapidly accessing and processing information on the different pages, including displaying a plurality of page identifiers for selecting individual pages, and further including a preferred syntax for referencing information. Additional methods are provided for editing cells and blocks of cells.

Claims

1. In a computer system, a method for providing a user access to values of properties of objects appearing on screen, the method comprising:

(a) displaying a plurality of objects on screen, at least some of the objects having properties whose values can be set by the user;

(b) requesting properties of a particular object of interest, by positioning a screen cursor at or near the particular object and requesting inspection of the properties of the particular object;

(c) in response to the request for properties of the particular object, displaying a property dialog for the particular object, said property dialog including

(i) a list of properties corresponding to a plurality of properties for the particular object, and

(ii) at least one property pane corresponding to at least one property for the particular object, each property pane including one or more

screen controls for getting and setting values for the corresponding property of the particular object;

(d) receiving user input for selecting one of said properties from the list; and

(e) in response to said user input, displaying the property pane that corresponds to the selected property while continuing to display the list of properties.

2. The method of claim 1, wherein said displaying in step (e) is done so as to at least partially obscure other property panes of the property dialog.

3. The method of claim 2, wherein the selected property pane is displayed so as to substantially obscure all other property panes.

4. The method of claim 1, wherein at least one of the property panes is constructed dynamically upon receipt of said request.

5. The method of claim 1, wherein at least one of the property panes is preconstructed before receipt of said request.

6. The method of claim 1, wherein:

the list of properties is displayed as a plurality of notebook tabs; and

each property pane is associated with a particular notebook tab appearing on screen, each notebook tab indicating to the user a specific property which is associated with the property pane of the notebook tab.

7. The method of claim 6, wherein each notebook tab displays a text label indicating a name for the property associated with the notebook tab.

8. The method of claim 7, wherein said particular object is a spreadsheet cell and wherein each text label indicates to the user a particular type of property for a spreadsheet cell.

9. The method of claim 8, wherein the text label includes text selected from:

font, alignment, numeric format, color, height, and width.

10. The method of claim 1, further comprising:

(f) receiving user input for changing the value of the particular property.

11. The method of claim 1, wherein at least some of the property panes include screen controls for receiving user input for changing the value of a particular property.

12. The method of claim 11, wherein said screen controls are selected from:

edit fields, radio buttons, check boxes, scroll bars, and push buttons.

13. The method of claim 1, wherein said requesting properties of a particular object step comprises:

positioning a two-button mouse device so that the screen cursor is located proximate the particular object of interest; and

generating a selection signal by invoking one of the two mouse buttons.

14. The method of claim 13, wherein said generating a selection signal comprises generating a right-mouse button signal.

15. The method of claim 1, wherein said property dialog is displayed so that each property pane appears as a separate sheet in a tabbed notebook comprising a plurality of sheets, each sheet being associated with a tab member which displays a text label describing contents of the sheet.

16. The method of claim 1, wherein:

a particular property of said plurality of properties has associated with it a plurality of individually settable values; and

the particular property'"'"'s corresponding property pane includes a plurality of screen controls for getting and setting values for the particular property of the particular object.

17. In a computer system for operating an application program, a method for assisting a user for getting and setting of various properties of objects which comprise the application program, the method comprising:

(a) receiving first user input which requests access to properties of a particular object;

(b) in response to said first user input, displaying a tabbed property dialog comprising a plurality of descriptive tabs corresponding to a plurality of properties for the particular object and at least one of a corresponding plurality of property sheets, each property sheet, when displayed, presenting one or more user interface controls for setting respective values for a particular property of the particular object;

(c) receiving second user input for selecting one of the property sheets, said second user input comprising at least one signal from an input device for selecting the descriptive tab of the property sheet being selected;

(d) in response to said second user input, displaying said selected property sheet while continuing to display the plurality of descriptive tabs, said selected property sheet having one or more user interface controls for effecting respective changes to values for the property associated with the selected property sheet;

(e) receiving third user input at said one or more user interface controls of the selected property sheet, for changing the value of the associated property to a new value; and

(f) in response to said third user input, changing the value of the property associated with said selected property sheet to the new value.

18. The method of claim 17, wherein said first user input includes a right-mouse button click.

19. The method of claim 18, wherein the descriptive tab for a property sheet includes user feedback indicating whether the value of the property of the associated property sheet has been changed by the user.

20. The method of claim 19, wherein said user feedback comprises a change in color.

21. The method of claim 17, wherein said particular object is a selected one of a spreadsheet cell, a spreadsheet block, a spreadsheet page, and a spreadsheet notebook.

22. The method of claim 17, wherein at least one of said values for at least one property comprises a numeric value for said at least one property.

23. The method of claim 17, wherein the descriptive tab for each property sheet is aligned to one side of the tabbed property dialog.

24. The method of claim 17, wherein said second user input comprises user input for selecting the tab for the property sheet being selected with a pointing device.

25. The method of claim 17, wherein said third user input comprises user input received from a selected one of a keyboard device and a pointing device.

26. The method of claim 17, wherein said user interface controls include selective ones of edit fields, radio buttons, check boxes, scroll bars, and push buttons.

27. The method of claim 17 wherein:

a particular property of said plurality of properties has associated with it a plurality of individually settable values; and

the particular property'"'"'s individually settable corresponding property sheet, when displayed, presents a plurality of user interface controls for setting respective values for the particular property of the particular object.

28. In a computer system including a processor;

a screen device, and a pointing device for generating a first set of at least one signal designating locations on the screen device and a second set of at least one signal indicating at least one type of event at the designated screen location, a method for allowing a computer user to inspect and modify values corresponding to properties of objects displayed on the screen device, the method comprising operating the computer system to perform the steps of;

displaying a plurality of objects on the screen device, at least some of said objects being of different types, each different type of object having a different set of properties, each property for a given type of object having one or more individually settable values, with at least one of the properties for at least one type of object having a plurality of individually settable values;

in response to signals including a given type of event at a given designated location, identifying an object of interest; and

displaying for the identified object of interest a dialog box that includes a list of properties available for the identified object, each property on the list being selectable, and a dialog pane containing user interface controls for indicating and setting values corresponding to the selected property, said list being displayed along an edge of the dialog pane with the selected property in the list being displayed to appear as a tab distinguished from the other properties in the list, said tab extending from an edge of the dialog pane.

29. The method of claim 28, wherein the pointing device is a mouse device, and further comprising the step of displaying a cursor on the screen device to provide a visible indication of the designated location.

30. The method of claim 28, wherein:

said pointing device is a mouse device;

said second set of at least one signal includes at least first and second types of signals in response to at least two respective types of user activation of said mouse device;

said first and second types of signals indicate said given type of event and an additional type of event; and

the method further includes invoking actions for an object of interest in response to said additional type of event.

31. The method of claim 28, further comprising:

changing settable values corresponding to properties for the object of interest by entering new values for selected ones of the values associated with the properties.

32. The method of claim 28, wherein:

the identified object is of a type having a particular property having a plurality of individually settable values;

the selected property in the dialog box is the particular property; and

the dialog pane has a plurality of user interface controls corresponding to the plurality of individually settable values for the selected property.

33. In a computer system including a processor, a screen device, and a pointing device for generating a first set of at least one signal designating locations on the screen device and a second set of at least one signal indicating at least one type of event at the designated screen location, a method for allowing a computer user to inspect and modify values corresponding to properties of objects displayed on the screen device, the method comprising operating the computer system to perform the steps of:

displaying a plurality of objects on the screen device, at least some of said objects being of different types, wherein

each different type of object has a different set of properties,

each property for a given type of object has one or more individually settable values, and

the types of objects include at least one type of user-created object and at least one type of object that is not created by the user;

in response to signals including a given type of event at a given designated location, identifying an object of interest;

displaying for the identified object of interest, regardless of whether the object is a type of user-created object or is a type of object that is not created by the user, a dialog box that includes a list of properties available for the identified object, each property on the list being selectable, and a dialog pane containing user interface controls for indicating and setting values corresponding to the selected property;

receiving input specifying a different selected property in the list; and

in response to the input, displaying a dialog pane containing user interface controls for indicating and setting values corresponding to the different selected property while continuing to display the list.