The present invention relates generally to manipulating tabular data and, more particularly, to a system and method for scrolling within tabular data displayed on electronic devices.
Analysis frequently involves evaluating large amounts of tabular data. For example, analysis of a mathematical function may involve an analysis of independent and dependent variables organized in a tabular manner. Many times, this analysis involves creating a worksheet showing the interrelationship of independent variables and dependent variables, and may involve tabular data comprising tens or hundreds of columns and/or rows. This type of analysis is frequently performed in all types of work, such as financial models, simulations, function analysis, mathematical models, and the like.
Because the size of the tabular data may be very large, it may be difficult to scroll through the data. This problem may be particularly troublesome when using a handheld computing device with a small display size. For example, handheld calculators are widely used in professional arenas as well as in academic studies. Handheld calculators, however, have small displays, some of which range in size from 2 inches to 3.5 inches. Although desktop computing systems may have a larger display, it may be difficult to analyze tabular data comprising tens or hundreds of rows and columns.
Therefore, there is a need for a system and method to enable flexible manipulation of tabular data displayed on an electronic device.
These and other problems are generally solved or circumvented, and technical advantages are generally achieved, by preferred embodiments of the present invention which provides independent scrolling of tabular data.
In an embodiment of the present invention, a method of manipulating a display of tabular data is provided. The method comprises displaying tabular data, selecting a selected row or column, and scrolling the selected row or column independently of other rows and/or columns.
In another embodiment of the present invention, a calculator is provided. The calculator generally includes a screen, a keypad, and a processor communicatively coupled to the screen and the keypad. The processor is configured to display a portion of tabular data on the screen in rows and columns and to select a first group of the tabular data in response to a user activating one or more selection keys of the keypad. Once selected, the processor is configured to scroll the first group independently of other groups of the tabular data in response to the user activating one or more input devices, such as directional keys, mouse, stylus on a touchscreen, or the like. The first group may include rows of the tabular data and/or columns of the tabular data.
In yet another embodiment of the present invention, an electronic device comprising a memory, a keypad, a display, and a processor is provided. The processor is configured to perform program instructions stored in the memory to display tabular data on the display and to allow a user to select a line of data and to scroll the line of data independently of other lines of data through activation of one or more keys of the keypad. The line of data may be one or more rows and/or one or more columns of tabular data.
It should be appreciated by those skilled in the art that the conception and specific embodiment disclosed may be readily utilized as a basis for modifying or designing other structures or processes for carrying out the same purposes of the present invention. It should also be realized by those skilled in the art that such equivalent constructions do not depart from the spirit and scope of the invention as set forth in the appended claims.
The following is a brief description of the drawings, which illustrate exemplary embodiments of the present invention and in which:
a-4c are screen shots illustrating scrolling of an individual column in accordance with an embodiment of the present invention;
a-5b are screen shots illustrating scrolling of an individual row in accordance with an embodiment of the present invention; and
Referring now to the drawings, wherein like reference numbers are used herein to designate like or similar elements throughout the various views, illustrative embodiments of the present invention are shown and described. The figures are not necessarily drawn to scale, and in some instances the drawings have been exaggerated and/or simplified in places for illustrative purposes only. One of ordinary skill in the art will appreciate the many possible applications and variations of the present invention based on the following illustrative embodiments of the present invention.
Embodiments of the present invention are discussed below with respect to embodiments in which a graphing calculator or a personal computer are used. It should be noted, however, that embodiments of the present invention may be useful for other types of electronic devices, handheld computing devices, desktop devices, and mainframe devices. Examples of other types of handheld computing devices in which embodiments of the present invention may be useful include scientific calculators, advanced calculators able to upload and run software applications, handheld-sized limited-purpose computer devices, handheld-sized educational computer devices, handheld-sized portable computer devices, portable computer devices, personal digital assistants (PDA), palmtop computers, personal communicators, personal intelligent communicators, cellular or mobile telephones, global positioning system (GPS) devices, portable inventory logging computer devices, handheld monitoring devices, handheld portable email devices, handheld portable Internet browsing devices, handheld portable gaming devices, and any combination thereof.
An optional input/output port 114 provides connectivity to other electronic devices, such as other computers, hubs, displays, or the like. In an embodiment, the input/output port 114 comprises a bi-directional connection such as a mini-A USB port. In this manner, the handheld computing device 100 may transmit information to and receive information from another electronic device. Also included in the handheld computing device 100 are a display 116 and a keypad 118.
As shown in
In an embodiment, the desktop computing system 300 comprises a processing unit 310 equipped with one or more input devices 312 (e.g., a mouse, a keyboard, or the like), and one or more output devices, such as a display 314, a printer 316, or the like. Preferably, the processing unit 310 includes a central processing unit (CPU) 318, memory 320, a mass storage device 322, a video adapter 324, and an I/O interface 326 connected to a bus 328. The bus 328 may be one or more of any type of several bus architectures including a memory bus or memory controller, a peripheral bus, video bus, or the like. The CPU 318 may comprise any type of electronic data processor. For example, the CPU 318 may comprise a Pentium™ processor from Intel Corp., an Athlon processor from Advanced Micro Devices, Inc., a Reduced Instruction Set Computer (RISC), an Application-Specific Integrated Circuit (ASIC), or the like. The memory 320 may comprise any type of system memory such as static random access memory (SRAM), dynamic random access memory (DRAM), synchronous DRAM (SDRAM), read-only memory (ROM), a combination thereof, or the like. In an embodiment, the memory 320 may include ROM for use at boot-up, and DRAM for data storage for use while executing programs.
The mass storage device 322 may comprise any type of storage device configured to store data, programs, and other information and to make the data, programs, and other information accessible via the bus 328. In a preferred embodiment, the mass storage device 322 is configured to store a software program to be executed by the CPU 318. The mass storage device 322 may comprise, for example, one or more of a hard disk drive, a magnetic disk drive, an optical disk drive, or the like.
The video adapter 324 and the I/O interface 326 provide interfaces to couple external input and output devices to the processing unit 310. As illustrated in
It should be noted that the handheld computing system 100 and the desktop computing system 300 may include other components. For example, the handheld computing system 100 and the desktop computing system 300 may include power supplies, cables, a motherboard, removable storage media, cases, a network interface, and the like. These other components, although not shown, are considered part of the handheld computing system 100 and the desktop computing system 300.
a-4c are screen shots of a first embodiment of the present invention in which one or more columns are scrolled independently of other columns on an electronic device such as those discussed above with reference to
Referring now to
c illustrates the screen shot of
a-5b are screen shots of a second embodiment of the present invention in which one or more rows are scrolled independently of other rows on an electronic device such as those discussed above with reference to
Preferably, a column number indicator 512 and a row scroll bar 514 are displayed adjacent the selected row 510 as visual aids for the user. The column number indicator 512 indicates the current columns being displayed for the selected row 510, and the row scroll bar 514 provides a visual indication of the location of the currently displayed columns of the selected row as well as a mechanism to scroll among the various columns of the selected row 510.
As one of ordinary skill in the art will appreciate, other mechanisms may be used to scroll among the columns of the selected row and to indicate the current position. For example, in another embodiment a single value may be given to indicate a specific column such as the first row, last row, or an intermediate row, and in another embodiment arrow or cursor keys may be used to control scrolling within the row.
b illustrates the screen shot of
Once selected, the process proceeds to step 612, wherein a scroll bar and position indicator is preferably displayed. In step 614 the displayed data is adjusted as the user scrolls. Then, in step 616, the row/column indicator is updated as the user scrolls amongst the various columns/rows.
It should be noted that the embodiment discussed above illustrates scrolling a single row or column, but embodiments of the present invention may be used to scroll multiple rows and/or columns independently of each other. It should also be noted that all functions described herein may be performed in either hardware or software, or some combination thereof. In a preferred embodiment, however, the functions are performed by a processor such as a computer or an electronic data processor in accordance with code such as computer program code, software, and/or integrated circuits that are coded to perform such functions, unless indicated otherwise. In other embodiments, a hardware system may be specifically designed to perform one or more of the functions described herein.
Although embodiments of the present invention and at least some of its advantages have been described in detail, it should be understood that various changes, substitutions, and alterations can be made herein without departing from the spirit and scope of the invention as defined by the appended claims. Moreover, the scope of the present application is not intended to be limited to the particular embodiments of the process, machine, manufacture, composition of matter, means, methods, and steps described in the specification. As one of ordinary skill in the art will readily appreciate from the disclosure of the present invention, processes, machines, manufacture, compositions of matter, means, methods, or steps, presently existing or later to be developed, that perform substantially the same function or achieve substantially the same result as the corresponding embodiments described herein may be utilized according to the present invention. Accordingly, the appended claims are intended to include within their scope such processes, machines, manufacture, compositions of matter, means, methods, or steps.
This application claims the benefit of U.S. Provisional Application No. 60/876,977 filed on Dec. 22, 2006, entitled Independent Scrolling of Tabular Data, which application is hereby incorporated herein by reference.
Number | Date | Country | |
---|---|---|---|
60876977 | Dec 2006 | US |