A method for displaying, in a window on a computer display screen, tabular data arranged in rows and columns, wherein the sum of the widths of the columns is greater than the width of the workspace available within the window. The method includes the steps of determining the width of each column, determining the height of each row, and determining the dynamic height and width of the workspace available for the display of tabular data within said window. The method further includes the step of dividing said tabular data into table segments, each table segment comprising one or more columns of said tabular data. The method also includes the step of dividing said workspace into panes, each pane having a height determined by dividing the height of the window by the number of table segments, and displaying within each pane all of the columns of a table segment and one or more rows, wherein different columns are displayed in each pane and the same rows are displayed in each pane.

A macro program management system for facilitating edit operations of macro programs by clarifying associations between objects on a worksheet and macro programs. The macro program management system is equipped with a name information extraction unit for extracting names of worksheets, objects, and macro programs from application programs, and name list generation unit for listing the extracted names. This name list clarifies the association among the worksheets, objects, and macros. Further, the system has a listing/editing switching unit, coupled to the name list generation unit and to the macro editing unit, for switching the display screen either to a screen for showing the name list or to another screen for editing a macro program. With this unit, the operator can alternately select the listing screen or macro edit screen, thus facilitating development and maintenance of the application program.

A portable computer system manages data for a user using a processor; a program storage device coupled to said processor; an input recognizer embodied in said program storage device, said input recognizer adapted to receive non-cursive handwritings from said user and convert said non-cursive handwritings into text data; and a computer readable code embodied in said program storage device and coupled to said input recognizer for receiving said non-cursive handwritings, said computer readable code storing said data and allowing said user to process said data.

In an electronic spreadsheet, if an absolute cell or absolute cell range reference does not comprise the same information in a source environment and in a destination environment, errors may occur. Therefore, a buffer is created for temporarily storing a source cell range. Any material in the buffer not needed, is cleared. Any absolute reference content remaining that points to a source cell range, has a relative position within the source cell range determined. Then, a corresponding absolute reference within the destination cell range is determined. Prior to copying the buffer content into corresponding cells within a destination cell range, each absolute reference pointing to a source is replaced by a corresponding absolute reference with the destination cell range.

The present invention provides apparatus and methods for use in computer display systems, and in particular, a graphical user interface for use in computer systems. The user interface of the present invention includes a function palette that displays a variety of function icons. Each function icon corresponds to a function that a user may wish to perform. The user selects a function icon from the palette corresponding to the desired function and the user places a copy of the icon at that point in the display where the function is to be performed. For example, in the context of a multimedia video editor, the user may place an icon on a timeline that corresponds to source material. The desired function will then be performed on the source material at that point where the user placed the icon, either immediately or upon subsequent command from the user.