Cell format control

CL 715 SC 504
7039874 Interface for modifying data fields in a mark-up language environment
May-2-2006 A method for modifying a data field is described, illustrated and claimed. The novel system and method allows for quick and efficient modification of all or a portion of a plurality of data fields, while...
7020592 Method of analyzing chemical processes
Mar-28-2006 When chemical process conditions and chemical species are input on a spreadsheet software (1), a chemical model is selected according to the chemical species by a software (4, 5, 6) different...
7010779 Parser, code generator, and data calculation and transformation engine for spreadsheet calculations
Mar-7-2006 A system including spreadsheet sheets, makes calculations and data transformations, which is available through a programming interface, and conforms to the grammar and syntax of a target software development...
6988241 Client side, web-based spreadsheet
Jan-17-2006 A method and system that that allows a designer to create "spreadsheet" web pages, which can then be viewed and used by the designer and/or by other users. The described embodiments of the present invention...
6986099 Error correction mechanisms in spreadsheet packages
Jan-10-2006 A spreadsheet package allows a base formula to be copied to at least one adjacent cell to form a referencing array. The package maintains a list of bound arrays, at least one cell of a bound array being...
6981209 Automatic layout of vertical flow oriented characters within a defined area
Dec-27-2005 The method uses an HTML table cell sizing method designed to measure and layout horizontal HTML table cell elements, and implements a logical view and a search algorithm to layout table cells with the...
6961898 System and method for calculation using vertical parentheses
Nov-1-2005 Systems and methods for computer-based numerical calculation using a calcsheet are provided. A calcsheet may provide one or more columns for vertical calculation, each column having a plurality of fields...
6957385 Worldwide number format for a spreadsheet program module
Oct-18-2005 A worldwide number format for use with a spreadsheet program module is disclosed. The worldwide number format includes a locale specifier comprising a number shape, a calendar type and a locale identification...
6912690 Method and system in an electronic spreadsheet for persistently copy-pasting a source range of cells onto one or more destination ranges of cells
Jun-28-2005 A system and method is disclosed for persistently copying and pasting a source range of cells of a multidimensional spreadsheet onto one or more destination ranges of cells. When the source cells are first...
6883136 Simultaneous display and formatting of disparate values in a tabular form
Apr-19-2005 The present invention provides for simultaneous display of a tabular and a form view of the records, (b) displaying multiple disparate values in a single control, and (c) formatting the values based on...
6856972 Automated method for analyzing and comparing financial data
Feb-15-2005 An improved and automated method of analyzing data is provided. The method includes the steps of: gathering data from at least one field in financial statements from at least two different time periods...
6779152 Method for rotating a dynamic HTML table
Aug-17-2004 A method, operative at a web server, for generating an HTML table having dynamic data, wherein the table can be oriented in any horizontal or vertical orientation. The method preferably utilizes a table...
6766512 Methods and systems for generating a structured language model from a spreadsheet model
Jul-20-2004 In one embodiment of the present invention, there is provided a method for easily allowing a user of little to no programming language knowledge to convert a computerized spreadsheet model to a structured...
6757867 Method and system in an electronic spreadsheet for adding or removing elements from a cell named range according to different modes
Jun-29-2004 Some "summary" information in a cell named range is preserved when some spreadsheet elements rows, columns, or pages are added or removed from the cell named range. A range summary cell is defined by specifying...
6725422 Method and system in an electronic spreadsheet for introducing new elements in a cell named range according to different modes
Apr-20-2004 A named range defined by a cell address range in a spreadsheet comprises a plurality of cells identified in each dimension by an address, each dimension comprising two directions. An open named range is...
6711715 Method and system for efficient storage and restoration of display state data
Mar-23-2004 Storage and restoration of display state data for a display object having a display state that can be altered by display state changes made to other display objects in a hierarchical data structure where...
6708177 Method of formatting values in a fixed number of spaces using the java programming language
Mar-16-2004 A computer implemented method of and apparatus for printing values in a fixed number of column spaces using Java is described. A value desired to be formatted to a predetermined length string and an indexed...
6687875 Table editing apparatus
Feb-3-2004 A table editing apparatus spares users wasteful editing work in determining relative positional relations between cell boundaries of a table. The apparatus includes a cell boundary movement designating...
6625499 Tabular range editing mechanism
Sep-23-2003 A method of manipulation of cells within a table on an interactive user display comprising the steps of: (a) selecting a subset of cells of the table as a block on the display, the block having an orientation...
6613098 Storage of application specific data in HTML
Sep-2-2003 A spreadsheet program saves data into a hypertext markup language (HTML) document that can be viewed with a browser program, but persists all of the information associated with that data necessary to maintain...
6579324 Method for indicating a selected region on a computer display while allowing the user to see the formatting of the background and content items within the selected region
Jun-17-2003 A method for using an indicator, known as "See Through View," that allows a user to select a region on the display device and still see the visual attributes of the contents as they will appear when the...
6549878 System and method for editing a spreadsheet via an improved editing and cell selection model
Apr-15-2003 Editing cells within a spreadsheet to change the contents of a spreadsheet. To enter edit mode and alter the contents of a cell, the user first selects a cell by single clicking a mouse button while the...
6523167 Spreadsheet recalculation engine version stamp
Feb-18-2003 A recalculation engine version stamp is employed to determine whether a spreadsheet program file should be fully recalculated upon opening. When a spreadsheet program file is recalculated and saved, a...
6496832 Visualization spreadsheet
Dec-17-2002 A system for analyzing data organized into data sets and for transforming the data sets into a visual representation of the data sets is provided. The system includes a memory, a first processor, and an...
6467078 Program development system, method for developing programs and storage medium storing programs for development of programs
Oct-15-2002 There is disclosed a program development system, a method for developing programs and a storage medium storing programs for development of programs by which the reduction in development periods of a program...
6460059 Visual aid to simplify achieving correct cell interrelations in spreadsheets
Oct-1-2002 A method and apparatus for displaying a spreadsheet on a display device in a computer system to facilitate easy recognition of errors. More specifically, with this invention one cell is selected, and there...
6317758 Method and system for detecting and selectively correcting cell reference errors
Nov-13-2001 In a computer implemented spreadsheet, a method for detecting and selectively correcting cell reference errors after a cell is copied includes identifying at least one destination cell containing a formula...
6285998 System and method for generating reusable database queries
Sep-4-2001 An improved user interface and query method permits a computer user to quickly specify field names, operators, and desired values for a database query. One or more of the desired values can be specified...
6154748 Method for visually mapping data between different record formats
Nov-28-2000 A computer system, computer program product, and method for visually mapping data between different record formats provides for the mapping of source data fields of a dump file to the target data format...
6061689 Object aggregation representation of relational database rows having nontraditional datatypes
May-9-2000 A program product is described in which a class library is provided to permit object oriented applications to access and to manipulate, in accordance with the object model, nontraditional data values of...
5960415 Forecasting control system and method
Sep-28-1999 This invention concerns a forecasting control system which takes data and processes it to provide selective data reports including forecasts as a continuum of post results. The system makes use of arrays...
5937155 Interactive report generation system and method of operation
Aug-10-1999 A computer software system (10) is provided. The computer software system (10) includes a compiler (12) operable to receive a worksheet definition (20) and to access a plurality of model interface functions...
5933638 Method and apparatus for creating application computer programs using an objects evaluation matrix
Aug-3-1999 An Objects Evaluation Matrix.TM. is provided which links together "objects" (i.e., areas in computer memory that serve as basic structural units of analysis) to create a complete (or partial) application...
5933634 Mock-up method and mock-up control system for displaying pseudo operation
Aug-3-1999 A screen layout corresponding to a transaction routine is input to a FORM, and an item and a code of design information corresponding to a screen input are generated as a table. A location of the screen...
5893123 System and method of integrating a spreadsheet and external program having output data calculated automatically in response to input data from the spreadsheet
Apr-6-1999 A system and method integrate a spreadsheet and an externally implemented program. The system includes a set of input cells in the spreadsheet, which contain input data for the external program; a set...
5890174 Method and system for constructing a formula in a spreadsheet
Mar-30-1999 A method and system for assisting a user in constructing a formula in a cell of a spreadsheet operating on a computer system. A function dialog box is displayed that lists various functions that may be...
5890151 Method and system for performing partial-sum queries on a data cube
Mar-30-1999 Disclosed is a method and system for performing a partial-sum query in a database in which the data is represented as a multi-dimensional data cube. The data cube is partitioned into multi-dimensional...
5842180 Method and system for detecting and correcting errors in a spreadsheet formula
Nov-24-1998 In association with a computer system, a method and system for detecting and correcting errors in a spreadsheet formula. A token is created corresponding to each entry in the formula. As the formula is...
5768158 Computer-based system and method for data processing
Jun-16-1998 An electronic spreadsheet, formed in accordance with the present invention, providing a user with improved data processing capability, includes displaying a visual presentation to the user, the visual...
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...
5652889 Alternate execution and interpretation of computer program having code at unknown locations due to transfer instructions having computed destination addresses
Jul-29-1997 It is not always possible or practical to fully translate an original computer program because execution transfer instructions may have computed destination addresses that cannot be determined until program...
5621876 Method and apparatus for modifying a display matrix in a computer window by adding one column or row at a time
Apr-15-1997 A method of modifying a display matrix in a matrix display area in a window on a computer display screen. The method includes the steps of displaying data in a matrix format, thereby forming a display...
5600584 Interactive formula compiler and range estimator
Feb-4-1997 A method for tracking errors in a system of numerical formulas. It uses confidence intervals and special encodings, and is suitable for use in an interactive computer program. Maximum efficiency and accuracy...
5598519 Method and system for direct cell formatting in a spreadsheet
Jan-28-1997 A method and system wherein data elements in cells of a spreadsheet may be assigned character attribute information, such as font type, font size, bold, italics, underline, etc., wherein the character...
5280575 Apparatus for cell format control in a spread sheet
Jan-18-1994 A data structure for tabular data arranged in rows and columns. The data structure includes a header portion including a generic columnar processing information table, and a data portion for storing data...
5255356 Method for hiding and showing spreadsheet cells
Oct-19-1993 A method for hiding and showing spreadsheet cells of a worksheet being displayed on a computer system display means. The hiding and showing is based upon hierarchical relationships among the spreadsheet...
5247611 Spreadsheet cell having multiple data fields
Sep-21-1993 A spreadsheet comprised of a plurality of cells is described wherein each cell is separately identified by one or more parameters. The cells are dynamically configured so that the size may be changed depending...
5231577 Method and system for processing formatting information in a spreadsheet
Jul-27-1993 A method and system wherein characters in cells of a spreadsheet may be assigned character attribute information, such as font type, font size, bold, italics, underline, etc., wherein the character attribute...
5021973 Method for assisting the operator of an interactive data processing system to enter data directly into a selected cell of a spreadsheet
Jun-4-1991 A method for use in an interactive data processing system which includes a processor for controlling data entered into said system from an input device, and a display device which functions to display...