Spreadsheet

CL 715 SC 503
5734889 Method and apparatus for retrieving data and inputting retrieved data to spreadsheet including descriptive sentence input means and natural language interface means
Mar-31-1998 A method and apparatus for retrieving data on a database and inputting the retrieved data to an electronic spreadsheet so as to record the data thereon includes inputting, through an input apparatus by...
5721847 Method and system for linking controls with cells of a spreadsheet
Feb-24-1998 A method and apparatus for inserting a selected graphic control within a spreadsheet, chart, or dialog sheet. The graphic control can be selected from a Forms button toolbar and then positioned within...
5717939 Method and apparatus for entering and manipulating spreadsheet cell data
Feb-10-1998 A method for entering and manipulating spreadsheet cell data is described. The present invention provides a method for determining the target cell for written information and for scaling the information...
5713020 Method and system for generating database queries containing multiple levels of aggregation
Jan-27-1998 A method and system for displaying results of multiple level aggregation queries and providing hierarchical table sets in response to multiple level aggregation queries. In a preferred embodiment, a database...
5710901 Method and apparatus for validating data entered by a user
Jan-20-1998 A method and apparatus for validating data entered into a data processing system. A plurality of windows is provided, each including at least one widget area into which data is entered by the user. A "doda...
5708827 Spread sheet calculation method and apparatus by extracting an area to be updated by a calculation formula
Jan-13-1998 In a spread sheet calculation apparatus, a spread sheet data table stores spread sheet data such as a sales table, a calculation formula table stores calculation formulas defining the calculation of the...
5701499 Method and system for automatically entering a data series into contiguous cells of an electronic spreadsheet program or the like
Dec-23-1997 The present invention contemplates a method and system for automatically entering a data series into an electronic spreadsheet program or the like. After the user has selected source cells containing the...
5692173 Method and system for combining prefix and first character searching of a list
Nov-25-1997 A method and system for combining prefix and first character search methods. The present invention provides a combined search method for searching for elements in a list. The combined search method maintains...
5685001 Method and system for automatically entering a data series into contiguous cells of an electronic spreadsheet program or the like
Nov-4-1997 A method and system for automatically entering a data series into an electronic spreadsheet program or the like. After the user has selected source cells containing the start of the data series, the manipulation...
5664127 System and methods for improved spreadsheet interface with user-familiar objects
Sep-2-1997 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)....
5657437 Data processing apparatus and method including proportional updating of data
Aug-12-1997 A hierarchical database reporting and updating system is disclosed. The invention makes unique use of bit vectors to represent the relationship between various data items to enable the system to provide...
5634133 Constraint based graphics system
May-27-1997 A constraint based graphic system and method for creating graphic layouts of constraints-related graphic objects. The graphic objects are defined in a "constraint hierarchy". The constraint hierarchy defines...
5623591 System and methods for building spreadsheet applications
Apr-22-1997 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)....
5604854 System and methods for reformatting multi-dimensional spreadsheet information
Feb-18-1997 An electronic spreadsheet system of the present invention includes a Data Modeling module for creating multi-dimensional reports from spreads of information. The module includes a preferred report workspace...
5590259 System and methods for improved spreadsheet interface with user-familiar objects
Dec-31-1996 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)....
5553215 Method and system of sharing common formulas in a spreadsheet program and of adjusting the same to conform with editing operations
Sep-3-1996 A method and system of adjusting shared formulas in a spreadsheet program in response to editing operations. Upon an editing operation, the boundary line of cells that are shifted is determined with respect...
5553212 Method and apparatus for solving numerical planning problems with inequalities on a computer system
Sep-3-1996 It is aimed to solve numerical planning problems in a manner better reflecting planner's intention. Variables of a numerical planning problem are displayed as graphical objects on a display unit, guidance...
5535324 Method and system for dragging and plotting new data onto an embedded graph
Jul-9-1996 A method and system is provided for selecting data contained in a computer's memory and displayed in cells on the computer's display screen in tabular form and graphically plotting the selected data onto...
5515267 Apparatus and method for refrigeration system control and display
May-7-1996 A control and display apparatus and method for use with a heating and cooling system. Operating parameters of the system are arranged in a computer memory in a data structure comprising a plurality of...
5510980 Method and system for selecting and executing arithmetic functions and the like
Apr-23-1996 The present invention provides a method and system for automating the range selection process involved with arithmetic functions. When the sum function is selected, the system searches the cells above...
5504854 Apparatus and method for inputting cell shape and position and inter-cell calculation
Apr-2-1996 A table calculating device used in an interactive data system based on a personal computer or the like. When an operator specifies a position and a shade with respect to an entry on a display screen of...
5504848 Word processor with data table calculating function, capable of indicating necessity of re-calculations to solve mathematical expressions in changed data table
Apr-2-1996 A text processor is capable of creating table data based on numerical values and mathematical expressions entered through a keyboard, and displaying the data on a display screen. The text processor avoids...
5502805 System and methods for improved spreadsheet interface with user-familiar objects
Mar-26-1996 An electronic spreadsheet system of the present invention includes a notebook interface having a plurality of notebook pages, each of which may contain a spread of information cells, or other desired page...
5499180 System and methods for improved scenario management in an electronic spreadsheet
Mar-12-1996 An electronic spreadsheet of the present invention includes a scenario manager having a preferred interface and methods for creating and managing various versions or "scenarios" of a spreadsheet model....
5487144 Scheduling system
Jan-23-1996 A scheduling system for preparing an operational plan for a production process which is carried out by using a computer system with an improved easier programming method which does not require a human...
5485600 Computer modelling system and method for specifying the behavior of graphical operator interfaces
Jan-16-1996 A computer simulator system allows the user to specify prototype reaction to events in a pictorial manner using a visual object environment. A spreadsheet like State Table and a visual object collection...
5471612 Electronic spreadsheet system and methods for compiling a formula stored in a spreadsheet into native machine code for execution by a floating-point unit upon spreadsheet recalculation
Nov-28-1995 An electronic spreadsheet system of the present invention includes a Formula Evaluator having a preferred interface and methods for compiling spreadsheet formulas into native machine language for a target...
5471575 Interactive parameter driven iterative financial spreadsheet analysis with context and layout sensitive help screen
Nov-28-1995 A financial analysis system for mathematically modeling an investment on a computer provides an improved computer user interface and a help method for teaching a user how to use the analysis system and...
5463724 System and methods for improved spreadsheet interface with user-familiar objects
Oct-31-1995 An electronic spreadsheet system of the present invention includes a notebook interface having a plurality of notebook pages, each of which may contain a spread of information cells, or other desired page...
5455903 Object oriented customer information exchange system and method
Oct-3-1995 A computer-based information exchange system permits customers to request and receive different types of information from various sources. The operation of the system is controlled by an application created...
5442743 Electronic device for calculating and displaying a matrix
Aug-15-1995 An electronic device for calculating and displaying a matrix of the invention includes a display having a screen portion for displaying a matrix, and a keyboard by which commands are input into a CPU....
5437006 Spreadsheet command/function capability from a dynamic-link library
Jul-25-1995 A data processing system executes a spreadsheet program that supports callbacks from dynamic-link libraries. The dynamic-link libraries may callback into the spreadsheet program through an entry point...
5418902 Electronic spreadsheet system producing generalized answers including formulas
May-23-1995 An electronic spreadsheet consists of an array of cells into which a user can enter formulas and values. The contents of the spreadsheet cells are translated into a query in a high-level logic language...
5418898 Multidimensional data display system and method
May-23-1995 A data display system and method that provides for creation of multidimensional data displays in which the dimensions have one or more dimension elements and the display has display cells at dimension...
5416895 System and methods for improved spreadsheet interface with user-familiar objects
May-16-1995 An electronic spreadsheet system of the present invention includes a notebook interface having a plurality of notebook pages, each of which may contain a spread of information cells, or other desired page...
5396621 Sorting a table by rows or columns in response to interactive prompting with a dialog box graphical icon
Mar-7-1995 An improved apparatus and method for sorting of information in a computerized spreadsheet or the like. The improved system provides for display of a graphical indication in the form of an icon indicative...
5396587 Asynchronous, minimal update display system
Mar-7-1995 A display management system for use with a computer that includes a display system, the display management system including means for generating a representation of a desired screen image; means for periodically...
5390296 Method and apparatus for calculation with display data
Feb-14-1995 A method and apparatus for facilitating analysis of data in a data base. The data base data is displayed on a touch sensitive screen. A calculator icon is overlayed on the data. A user selects a function,...
5381524 Automated development of timing diagrams for electrical circuits
Jan-10-1995 A computer-implemented method and apparatus that automates the entry, modification, and verification of timing diagrams for electrical circuits. The computer-implemented method and apparatus also provides...
5375201 System and methods for intelligent analytical graphing
Dec-20-1994 An electronic spreadsheet system includes an intelligent analytical graphing module for creating complex analytical graphs from user-supplied information. Methods are described for automatically creating...
5371675 Spreadsheet program which implements alternative range references
Dec-6-1994 A computer programmed to represent a spreadsheet that can be displayed to a user, the spreadsheet including an array of cells for storing user entered data, the programmed computer including programmed...
5359729 Method for searching for a given point in regions defined by attribute ranges, then sorted by lower and upper range values and dimension
Oct-25-1994 Regions, such as those determined by attributes in a spread sheet, are defined by ranges of attribute values. Regions are distinct if they differ in their number of ranges (dimension) or because a pair...
5359711 Determination of load flow in direct current electrical systems
Oct-25-1994 A system and method (100,200) which uses a spreadsheet computer program having linked files in which the network architecture and the network element properties are entered and stored by the user. The...
5337405 Guided data presentation
Aug-9-1994 A computer system comprises a computer, a monitor, a keyboard, a mouse, and an instrumentation system. The instrumentation system is coupled to a patient to gather data about a patient over time. The data...
5317686 Data processing apparatus and method for a reformattable multidimensional spreadsheet
May-31-1994 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...
5312478 System for managing information in a three dimensional workspace
May-17-1994 An information management system for use with a computer having a display screen, the system including means for organizing information into an ordered sequence of worksheets in a workspace, each worksheet...
5303146 System and methods for improved scenario management in an electronic spreadsheet
Apr-12-1994 An electronic spreadsheet of the present invention includes a scenario manager having a preferred interface and methods for creating and managing various versions or "scenarios" of a spreadsheet model....
5293615 Point and shoot interface for linking database records to spreadsheets whereby data of a record is automatically reformatted and loaded upon issuance of a recalculation command
Mar-8-1994 A spreadsheet program providing the combination of spreadsheet and database tools, and enabling users to develop an application environment that can use all resources in the spreadsheet storage area. The...
5276607 Method for optimal recalculation
Jan-4-1994 A process and apparatus for recalculating the contents of a spreadsheet's cells when they are affected by a modification of one or more cells in the spreadsheet is disclosed. After a spreadsheet has been...
5272628 Method and system for aggregating tables having dissimilar formats
Dec-21-1993 The present invention contemplates a method and system for automatically aggregating tables having a variety of configurations or layouts into a single destination table. Specifically, tables having a...