Data display for multiple layered screens

Abstract

A method of displaying data on a multilevel screen display is disclosed. The method comprises assigning screen designation codes to respective groups of data, and determining the physical screen on which each group of data is displayed. The screens may comprise layered liquid crystal displays. The method is suitable for use with spreadsheet software, where a user is able to see overlaying spreadsheets simultaneously.

Description

TECHNICAL FIELD

This invention relates to data display.

BACKGROUND ART

Reference throughout this specification shall be made to use of the present invention in relation to the display of data in spreadsheets. However, it should be appreciated that aspects of the present invention can be used in relation to displaying data presented in other formats, perhaps graphically or in some other format for displaying in particular relational data.

There are a number of spreadsheet programs, one of the more prolific being MICROSOFT EXCEL. These spreadsheet programs have a number of cells in rows and columns into which data can be input. Often the cells within the spreadsheet are related to each other.

For example, there may be a cell that displays a number which is calculated from the numbers represented in other cells in the spreadsheet. For instance, this particular cell may represent the total of a column of numbers. Any change to the numbers in that column will also be reflected in that cell representing the total.

This system works well when all of the data required to be reviewed can fit onto one computer screen display. However, often the user of the software creates spreadsheets which have more data entered into them than can be shown on one screen display at a time.

To accommodate this need, spreadsheet software often includes a facility akin to an old-fashioned system of having separate sheets of paper or cards except this is displayed on the computer, accessed by a virtual tab. For example, the screen may show one set of data. By clicking on a tab, a second set of data is then displayed on the screen with the first set of data being hidden by the second.

Unfortunately, this is still unsatisfactory. This is because the screen does not show all of the data that the user may wish to see. While the user can choose which spreadsheet to view, the user cannot see the effect that changing a cell on one spreadsheet has on another cell on the other spreadsheet.

Another problem is that it can take some time for a user to locate a particular cell. Not only is this another attempt to address the situation has been the ability to include multiple files on a screen which may be cross-linked in terms of having relational data. Thus, it is possible for the user to alter data on one part of the screen in relation to one file and see its effect on another part of the screen in relation to another file.

Unfortunately, these attempts are still unsatisfactory. One problem with this system is that although there may be inter-relational data, there is no physical feel of the relationship between the cells.

For example, on each spreadsheet there may be cells relating to similar data in the same columns and rows for each spreadsheet. However, positioning the spreadsheets beside each other on the screen does not provide an intuitive feel of the relationship of the cells to each other.

Another problem that occurs is that often the single cell has two lots of data assigned to it. One data element is the actual number and the other data element is the formula or relationship equation which generates that number. In traditional spreadsheet programs, the formula is usually only displayed when that particular cell is selected. Therefore, the formula for a number of related cells cannot be displayed at the same time. This is understandably frustrating, particularly when a person is desirous of quickly viewing and assessing the relationship between a number of cells to each other.

It is an object of the present invention to address the foregoing problems or at least to provide the public with a useful choice.

Further aspects and advantages of the present invention will become apparent from the ensuing description which is given by way of example only.

DISCLOSURE OF INVENTION

According to one aspect of the present invention there is provided a method for creating a visual effect in the display of software wherein the

software is for the manipulation of data,

the method characterised by the steps of

• a) assigning a particular screen designation code to a first group of data, and
• b) assigning other screen designation codes to second and other groups of data as desired,wherein the screen designation code determines which physical screen the group of data is displayed in a multi-level screen display.

As stated previously, the software in preferred embodiments is spreadsheet software, although it should be appreciated that the principles of the present invention can apply to other types of software, particularly those which relate to the display of data, such as databases, graphical analysis and so forth.

The term second and other group of data may cover such items as formula, relational information, highlights, error messages, hints and so forth which can be associated with the first group of data.

The screen designation code is merely a code that identifies which physical screen the image or software component is displayed upon.

The inventors of the present invention also invented a multi-level screen display and this is described in detail in PCT Application Nos. PCT/NZ98/00098 and PCT/NZ99/00021.

This is a device which is created by combining multiple layers of selectively transparent screens. Each screen is capable of showing an image. In preferred embodiments, the screen layers are liquid crystal displays. Preferably the screens are aligned parallel to each other with a preset distance between them.

With this invention, images displayed on the screen furtherest from the view (background screen), will appear at some depth behind the images displayed on the screen closest to the viewer (foreground screen). The transparent portions on the foreground screen will allow viewers to see images displayed on the background screen.

This arrangement of layering multiple screens allows images to be presented at multiple levels giving the viewer true depth without use of glass or lens.

The present invention will now refer to use with a multi-level screen as described above although this should not be seen as limiting.

The group of data is in preferred embodiments a spreadsheet such as that normally viewed in a spreadsheet program, however this should not be seen as limiting.

It should be appreciated that although reference shall be made throughout this specification now to only background and foreground screens, other aspects of the present invention may utilise more than two screens. For example, various spreadsheets may be on the multiple screens behind the foreground screen.

A group of data may be that information displayed when a particular tab is selected on the screen. Therefore, that group of data or spreadsheet is displayed on one of the physical screens.

The group of data or spreadsheet that can be viewed by selecting another tab may be displayed on another physical screen. Alternatively, if there are two separate spreadsheet programs, these can be imported to an embodiment of the present invention and have separate spreadsheets from the separate files shown on the separate screens with one spreadsheet overlaying another, but with the ability to see both.

One embodiment of the present invention will be an interface that identifies the coding on existing software with these identifiers and assign various data groups to the appropriate foreground or background screen.

The ‘always on top’ functions can be made fully or partially transparent by the present invention.

In one embodiment of the present invention, one screen may have a highlight for a particular cell or group of cells positioned either in front of or behind that highlight. In a variation of this embodiment, the highlights of a number of cells may be colour coded with the codes corresponding to a particular relationship to cells of a certain type.

In another embodiment of the present invention, one group of data on one screen may be the actual values within the cells and the other group or groups of data on the other screens may be the coding or formulas or relational information that actually creates the value shown on the other screen.

In some embodiments, the groups of data may all belong to the same large spreadsheet and the second and consequent screens may merely show the wrap-around of that spreadsheet.

In other embodiments, it may be provided in cells a hyperlink that can take the user of the spreadsheet to other cells or other screens.

Sometimes, the present invention may be useful in error tracking. For example. a mistake in the relational formula between the cells or the data entered may lead to an error. The ability to see a number of cells at once can assist in tracking down where the error occurred or what cells are affected by the error.

In one aspect of the present invention there may be provided the ability to scroll through values on one cell or set of cells on a screen while still being able to view another set of cells on another screen. This is particularly useful where it is desired to be able to search for information or data on various areas of the spreadsheet or database while not disturbing the actual region of the spreadsheet or database that the user is working on.

The scrolling or rotation of data on various cells may be achieved in some instances by the use of a track ball or some other user interface.

In yet another embodiment one of the screens may display tips or hints associated with the cells being displayed on the other screen.

The interface may be a patch for existing software, a library file or a new front end for multiple existing software packages or a completely new operating system.

With existing software that does not have such coding, it may be necessary to implement the present invention by having customised software in which the software developer specifies the software routines which cause the appropriate components and images to go on the appropriate screens.

A further aspect of the present invention is the provision of media on to which instructions in accordance with the present invention has been recorded. For example. this media may be a graphics card, CD, hard drive, floppy disk and so forth.

The advantages of the present invention can now be readily seen.

Because of the physical separation between the screens, the viewer can easily see data on the front screen and on the rear screen as required. Thus, the user can see significantly more data than previously viewable with standard software or standard screens. Indeed the amount of data that the user can see is a multiple proportional to the number of screens in the multi-level screen display.

The viewer can instantly see on which screen holds the cell or data that is relevant to it and select this.

The user can also see at a glance the relational nature of the data on the screens. For example, a change on one screen may cause corresponding change on the other screen overlaying it. This gives an instant appreciation of the effect of a change.

In some embodiments of the present invention the cells which change as a consequence of altering data may be colour coded. This allows the user to more quickly identify where that change has occurred on multiple screens.

Some embodiments may have different shading to make it clear as to which screen the group of data is on, or to indicate which data is grouped together. The overall screens may also be shaded/coloured to give visual clarity.

The present invention also allows the user to easily access a desired cell. Not only is this more desirable for the user in terms of mental satisfaction, but this also is significant in terms of physical relief. A problem that frequent computer users have is occupational overuse syndrome (oos) which is the repeated use of muscles, particularly when typing or using a mouse. Easier access means that the mouse is used less in order to find a particular cell and thus a potentially unpleasant medical condition is avoided.

In some embodiments of the present invention some cells are presented as 3-dimensional blocks which can be selected, moved or removed like blocks in a wall to reveal data on other screens.

It can be appreciated that the present invention overall literally provides an added dimension to the ability of a user to work with data manipulation programs such as spreadsheets and databases. There is considerably more flexibility and also a reduction in the time and effort required by the user to see the relationship between groups of data to each other.

Aspects of the present invention may extend to other standard functions on a spreadsheet program.

For example, spreadsheet programs often come with the ability to present the data graphically. Thus, for multi-relational data sheets, the present invention can also be used to produce 3-dimensional graphs showing the data on x, y and z axes as required.

BRIEF DESCRIPTION OF DRAWINGS

Further aspects of the present invention will become apparent from the following description which is given by way of example only and with reference to the accompanying drawings in which:

FIG. 1 illustrates a screen display of a prior art spreadsheet software, and

FIG. 2 illustrates another prior art screen display, and

FIG. 3 is a concept drawing showing the 3-dimensional nature of the present invention.

BEST MODES FOR CARRYING OUT THE INVENTION

FIG. 1 is a screen display from a MICROSOFT EXCEL program. This illustrates a group of data on a spreadsheet generally indicated by arrow 1 on the screen. The associated tab (2) indicates that the data we are looking at relates to “FBT Calc—Lease”.

The screen also shows that there is a second group of data (not shown) and positioned visually under the first group of data. The indicator that there is a second group of data is the tab (3) which reads “FBT Calc—Lease to Own”.

To view the second group of data, it is necessary to select the tab (3). However, in doing so the first group of data is obscured by the second group of data. Thus, the effect of a change on one group of data is not immediately discernable as the user cannot see the other group of data.

It can also be seen that it can be difficult for the user to select a particular cell given that half of the data is obscured at any one time.

It should also be appreciated that spreadsheet programs of this type have the ability to have multiple tabs, not just the two shown.

FIG. 2 illustrates a screen display whereby two separate files have been imported into the one screen display and are positioned side by side. This enables the user to change data on file and view its corresponding effect on the other file.

However, because the files are side by side, this is not intuitive with there being no real physical relationship between cells having the same common row and column. Further, the screen size is still limited and only a certain amount of data can be fitted onto the screen.

The present invention provides for the separate groups of data (whether from separate files of merely separate spreadsheets to be displayed on separate physical screens aligned with each other.

FIG. 3 shows an example of a multi-level spreadsheet using only 2 layers. Information can be stored on both layers. The layout of the cells can be used to enhance user information by positioning related cells close to or behind one another so as to improve the visual feedback to the user speeding up the development time and improving error detection. The positioning of the cells can also be used to increase the information available on a given cell as illustrated by the text and numbering chosen for FIG. 3. The front screen is ready to receive the monthly information such as income generated or expenses incurred while the back screen provides the user with immediate information about the day on which the income was generated or expense total incurred, thus reducing the need to look away from the cell to gain this information.

A greater number of layers of course can be used.

The 3-dimensional spreadsheet enables the user to see far greater quantities of data in the one visual display than before.

It also enables the user to quickly select a desired cell. Further, the relational nature of the data to each other can be intuitively perceived.

Aspects of the present invention have been described by way of example only and it should be appreciated that modifications and additions may be made thereto without departing from the scope of the appended claims.

Claims

1. A method of displaying spreadsheet objects, said method comprising: assigning a first screen designation code to a first portion of a spreadsheet object, said first screen designation code associated with a first display screen of a multi-component display;assigning a second screen designation code to a second portion of said spreadsheet object, said second screen designation code associated with a second display screen of said multi-component display; andsimultaneously displaying said first and second portions of said spreadsheet object in accordance with said first and second screen designation codes, wherein said simultaneously displaying further comprises simultaneously displaying said first and second portions of said spreadsheet object on a respective display screen of said first and second display screens, wherein said simultaneously displaying comprises generating said first and second portions of said spreadsheet object using at least one pixel of said first display screen and at least one pixel of said second display screen.

2. The method of claim 1, wherein said first and second portions of said spreadsheet object are selected from a group consisting of a window portion, menu portion, a tab portion, an icon portion, a user-modifiable field portion, a cell portion, and a grouping of cells.

3. The method of claim 1, wherein said first and second portions of said spreadsheet object are each associated with a respective user-selectable tab.

4. The method of claim 1, wherein said first portion of said spreadsheet object comprises a formula, and wherein said second portion of said spreadsheet object comprises at least one of data associated with said formula and a result of said formula.

5. The method of claim 1, wherein said first and second portions of said spreadsheet object comprise adjoining data wrapped from said first display screen to said second display screen.

6. The method of claim 1, wherein said first portion of said spreadsheet object comprises a first color and said second portion of said spreadsheet object comprises a second color.

7. The method of claim 1, wherein said first portion of said spreadsheet object displayed on said first display screen comprises a link to said second portion of said spreadsheet object displayed on said second display screen.

8. The method of claim 1, wherein said second portion of said spreadsheet object comprises at least one of an error message related to said first portion of said spreadsheet object and information about said first portion of said spreadsheet object.

9. The method of claim 1 further comprising: in response to a user interaction, updating a position of said first portion of said spreadsheet object on said first display screen with respect to a position of said second portion of said spreadsheet object on said second display screen.

10. The method of claim 1, wherein at least one of said first and second portions of said spreadsheet object comprise an active cell, an active spreadsheet, and a user-selected cell.

11. The method of claim 1, wherein said first and second display screens are physically spaced apart from one another, and wherein said first display screen is positioned in front of said second display screen.

12. The method of claim 1 further comprising: increasing the transparency of said first portion of said spreadsheet object to increase the visibility of said second spreadsheet object.

13. The method of claim 1, wherein said first portion of said spreadsheet object is associated with a first spreadsheet and said second portion of said spreadsheet object is associated with a second spreadsheet, and wherein said first and second spreadsheets overlap.

14. The method of claim 1 further comprising: automatically modifying said second portion of said spreadsheet object in response to a modification of said first portion of said spreadsheet object.

15. The method of claim 14, wherein said automatically modifying said second portion of said spreadsheet object comprises changing a color of said second portion of said spreadsheet object.

16. The method of claim 1, wherein an overlap of said first and second portions of said spreadsheet object indicates a relationship of said first and second portions of said spreadsheet object.

17. The method of claim 1, wherein said first and second portions of said spreadsheet object comprise at least one of a three-dimensional graph, a three-dimensional chart, and a three-dimensional object.

18. The method of claim 1, wherein said first and second portions of said spreadsheet object are associated with a single spreadsheet cell.

19. The method of claim 1 further comprising: displaying said first and second portions of said spreadsheet object in accordance with said first and second screen designation codes to enable a viewer to contemporaneously view said first and second portions of said spreadsheet object.

20. A computer-usable medium having computer-readable program code embodied therein for causing a computer system to perform a method of displaying spreadsheet objects, said method comprising: assigning a first screen designation code to a first portion of a spreadsheet object, said first screen designation code associated with a first display screen of a multi-component display;assigning a second screen designation code to a second portion of said spreadsheet object, said second screen designation code associated with a second display screen of said multi-component display; andsimultaneously displaying said first and second portions of said spreadsheet object in accordance with said first and second screen designation codes, wherein said simultaneously displaying further comprises simultaneously displaying said first and second portions of said spreadsheet object on a respective display screen of said first and second display screens, wherein said simultaneously displaying comprises generating said first and second portions of said spreadsheet object using at least one pixel of said first display screen and at least one pixel of said second display screen.

21. The computer-usable medium of claim 20, wherein said first portion of said spreadsheet object comprises a formula, and wherein said second spreadsheet object comprises at least one of data associated with said formula and a result of said formula.

22. The computer-usable medium of claim 20, wherein said first and second portions of said spreadsheet object comprise adjoining data wrapped from said first display screen to said second display screen.

23. The computer-usable medium of claim 20, wherein said first portion of said spreadsheet object comprises a first color and said second portion of said spreadsheet object comprises a second color.

24. The computer-usable medium of claim 20, wherein said first portion of said spreadsheet object displayed on said first display screen comprises a link to said second portion of said spreadsheet object displayed on said second display screen.

25. The computer-usable medium of claim 20, wherein said method further comprises: in response to a user interaction, updating a position of said first portion of said spreadsheet object on said first display screen with respect to a position of said second portion of said spreadsheet object on said second display screen.

26. The computer-usable medium of claim 20, wherein said first and second portions of said spreadsheet object are selected from a group consisting of an active cell, an active spreadsheet, and a user-selected cell.

27. The computer-usable medium of claim 20, wherein said method further comprises: increasing the transparency of said first spreadsheet object to increase the visibility of said second portion of said spreadsheet object.

28. The computer-usable medium of claim 20, wherein said method further comprises: automatically modifying said second portion of said spreadsheet object in response to a modification of said first portion of said spreadsheet object.

29. The computer-usable medium of claim 20, wherein said first and second portions of said spreadsheet object comprise at least one of a three-dimensional graph, a three-dimensional chart, and a three-dimensional object.

30. A multi-component display comprising: a first display screen operable to display a first portion of a spreadsheet object in accordance with a first screen designation code assigned to said first portion of said spreadsheet object, wherein said first screen designation code is associated with said first display screen, and wherein said first display screen is operable to display said first portion of said spreadsheet object using at least one pixel of said first display screen;a second display screen operable to display a second portion of said spreadsheet object in accordance with a second screen designation code assigned to said second portion of said spreadsheet object, wherein said second screen designation code is associated with said second display screen, and wherein said second display screen is operable to display said second portion of said spreadsheet object using at least one pixel of said second display screen.

31. The multi-component display of claim 30, wherein said first and second display screens are further operable to display said first and second portions of said spreadsheet object simultaneously.

32. The multi-component display of claim 30, wherein said first and second portions of said spreadsheet object are selected from a group consisting of a window portion, menu portion, a tab portion, an icon portion, a user-modifiable field portion, a cell portion, and a grouping of cells.

33. The multi-component display of claim 30, wherein said first and second portions of said spreadsheet object are each associated with a respective user-selectable tab.

34. The multi-component display of claim 30, wherein said first portion of said spreadsheet object comprises a formula, and wherein said second portion of said spreadsheet object comprises at least one of data associated with said formula and a result of said formula.

35. The multi-component display of claim 30, wherein said first and second portions of said spreadsheet object comprise adjoining data wrapped from said first display screen to said second display screen.

36. The multi-component display of claim 30, wherein said first portion of said spreadsheet object comprises a first color and said second portion of said spreadsheet object comprises a second color.

37. The multi-component display of claim 30, wherein said first portion of said spreadsheet object displayed on said first display screen comprises a link to said second portion of said spreadsheet object displayed on said second display screen.

38. The multi-component display of claim 30, wherein said second portion of said spreadsheet object comprises at least one of an error message related to said first portion of said spreadsheet object and information about said first portion of said spreadsheet object.

39. The multi-component display of claim 30, wherein said first and second display screens are further operable to update relative positions of said first and second portions of said spreadsheet object in response to a user interaction.

40. The multi-component display of claim 30, wherein at least one of said first and second portions of said spreadsheet object comprise an active cell, an active spreadsheet, and a user-selected cell.

41. The multi-component display of claim 30, wherein said first and second display screens are physically spaced apart from one another, and wherein said first display screen is positioned in front of said second display screen.

42. The multi-component display of claim 30, wherein said first and second display screens are further operable to vary the transparency of a respective portion of said spreadsheet object displayed thereon to change the visibility of a portion of said spreadsheet object selected from a group consisting of said first and second portions of said spreadsheet object.

43. The multi-component display of claim 30, wherein said first portion of said spreadsheet object is associated with a first spreadsheet and said second portion of said spreadsheet object is associated with a second spreadsheet, and wherein said first and second spreadsheets overlap.