Spreadsheet

CL 715 SC 503
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...
7017112 Importing and exporting markup language data in a spreadsheet application document
Mar-21-2006 Methods and systems are provided for importing and exporting markup language formatted data into a spreadsheet document. XML data is associated with a schema file defining data types and data type definitions...
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...
7007229 Computer-implemented system and method for web-based data access
Feb-28-2006 A computer-implemented method and system for presenting information within a document creation tool. A control is associated with the document creation tool and is used to have a web page invoked. The...
7003732 Method and system for data-driven display grids
Feb-21-2006 A method and system of automatically generating information in a grid structure on a display screen. In one embodiment, the present invention is directed to displaying and editing microcontroller chip...
7003722 Method and system for converting a schema-based hierarchical data structure into a flat data structure
Feb-21-2006 A method and system are provided for converting a hierarchical data structure into a flat data structure based on a schema. The format of the hierarchical data structure may be XML. A hierarchical data...
7000181 Dynamic data display having slide drawer windowing
Feb-14-2006 A dynamic data display system and associated method of usage. A portion of a data feed is dynamically displayed, such as in spreadsheet format, on a main drawer D0 that overlays a display screen....
6990632 Method and system for inferring a schema from a hierarchical data structure for use in a spreadsheet
Jan-24-2006 A method and system are provided for inferring a schema from an electronic document containing hierarchical data for use in a spreadsheet application program. The electronic document containing the hierarchical...
6988242 Transforming a portion of a database into a custom spreadsheet
Jan-17-2006 A method and computer system for transforming a portion (e.g., a view) of a database into a custom spreadsheet. The transforming includes determining whether to omit in the custom spreadsheet a column...
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...
6971062 Methods for rendering footnotes
Nov-29-2005 Methods are provided for rendering footnotes to a variety of media. Footnote citations and non footnote data are received and inserted into a unit of media at a beginning location within the unit of media....
6970749 Grouped palette stashing
Nov-29-2005 Methods and apparatus, including computer program products, implement techniques for representing control functions in a user application. A group of control palettes is provided in an application window...
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...
6944816 Automated system for performing kepner tregoe analysis for spread sheet output
Sep-13-2005 An automated system for performing a Kepner Tregoe analysis provides a graphical user interface having dedicated data entry screens that include i) a first screen for entering criteria to be used in the...
6920609 Systems and methods for identifying and extracting data from HTML pages
Jul-19-2005 Systems and methods for analyzing HTML formatted web pages to automatically identify and extract desired information. A computer algorithm identifies and extracts different pieces of information from different...
6920608 Chart view for reusable data markup language
Jul-19-2005 Methods and systems provide a "chart view" for a markup language referred to as Reusable Data Markup Language ("RDML"). Generally, a chart view comprises the components necessary for automatically manipulating...
6915308 Method and apparatus for information mining and filtering
Jul-5-2005 The present invention combines a data processing structure with a graphical user interface (GUI) to create an information analysis tool wherein multiple functions are combined in a network to extract information...
6915289 Using an index to access a subject multi-dimensional database
Jul-5-2005 A technique for accessing a subject multi-dimensional database stored on a data store connected to the computer. An index is created for the subject multi-dimensional database, wherein the index includes...
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...
6910071 Surveillance monitoring and automated reporting method for detecting data changes
Jun-21-2005 A surveillance monitoring and automated reporting method is used for detecting observable changes in data sources over a network, such as the internet, for accessing changing data, such as world wide web...
6907428 User interface for a multi-dimensional data store
Jun-14-2005 The invention provides a means of interacting with a subset of a large amount of related information that assists in providing a user with the overall understanding necessary to execute rapid and knowledgeable...
6898760 Reporting status of external references in a spreadsheet without updating
May-24-2005 The invention, in one embodiment, is a method and system for reporting the status of external references, or links, of a spreadsheet workbook. In an Edit Links dialog box, the user may view a list of links...
6865720 Apparatus and method for dividing document including table
Mar-8-2005 A table in an HTML document is analyzed to generate cell position data indicating a positional relationship between cells and cell vectors representing characteristics of the cells, and a table type is...
6859907 Large data set storage and display for electronic spreadsheets applied to machine vision
Feb-22-2005 An electronic spreadsheet is improved for machine vision applications by incorporating single method objects, and a data display buffer position beneath a variably transparent spreadsheet grid. The data...
6851088 Conditional highlighting of given cells in a dynamic HTML table
Feb-1-2005 A method operative at a server for generating a table having dynamic data. According to the method, a page developer may specify a given table cell in the table for conditional treatment. In response to...
6845488 Multi-line editor for compact display
Jan-18-2005 A method for displaying information, expressed as a sequence of alphanumeric characters, on a screen having a sequence of entry lines. Where a designated entry includes more than one line of characters:...
6829744 Document processing apparatus, method, and memory medium
Dec-7-2004 There is disclosed a document processing apparatus which enhances operability with respect to a character line inputted in the vicinity of a table format. When a designated area extends from the inside...
6829743 Method of acquiring environment consideration condition information
Dec-7-2004 Supplier-specific data of material items are extracted from data of various material items used for the manufacture of a product. Tabular data having a structure that allows various pieces of environment...
6792145 Pattern recognition process for text document interpretation
Sep-14-2004 The present invention is directed to a method for extracting textual as well as tabular data material from financial documents. Initially, a comparison is made to determine the type of data schedule material...
6782403 Inter-application data transmitting system and method
Aug-24-2004 An inter-application data transmitting system having an application intermediary unit which mediates data to be transmitted between a network and one of multiple business applications for exchanging the...
6779151 Storing objects in a spreadsheet
Aug-17-2004 A spreadsheet application provides a rich programming and modeling environment. The spreadsheet application of the present invention does this by recognizing a new "object" data type in addition to the...
6778834 Push content filtering
Aug-17-2004 The user of a mobile terminal enters keywords indicative of categories of messages he wishes to peruse. When the mobile terminal receives a message, keywords associated with the message are compared with...
6763498 Graphical environment for managing and developing applications
Jul-13-2004 A graphical application developing and managing environment is described capable of representing and editing program modules using multiple display formats, which include embedding source code written...
6742162 System and method for calculation using formulas in number fields
May-25-2004 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...
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...
6721713 Business alliance identification in a web architecture framework
Apr-13-2004 A system, method and article of manufacture are provided for identifying alliances among a plurality of business entities in components of a network framework. First, alliances are identified among a plurality...
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...
6701485 Binding spreadsheet cells to objects
Mar-2-2004 Spreadsheet cells are bound to external objects using a direct communication scheme having little processing overhead. A spreadsheet cell is bound to an object external to the spreadsheet, exposing a property...
6694338 Virtual aggregate fields
Feb-17-2004 A method comprising defining one or more aggregate virtual fields for a first document using meta-data associated with the first document is disclosed.
6691281 Publishing/republishing data tables in HTML documents while maintaining formatting and functionality for restoring back the data tables
Feb-10-2004 A spreadsheet program directly publishes a data table or chart into an HTML document. The table or chart is published to a predefined location within the HTML document and a user is enabled to readily...
6690399 Data display software for displaying assay results
Feb-10-2004 A method and apparatus for displaying data presents results from a single assay across multiple wells and plates on a single screen in a format that preserves the spatial relationship between the wells...
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...
6675351 Table layout for a small footprint device
Jan-6-2004 An efficient method is described for laying out a table for display. The method may be used to display tables on a small footprint device, such as a smart cellular phone, a personal data assistant, a handheld...
6654039 Method, system and program for scrolling index scans
Nov-25-2003 A method, system and program for accessing records in a database object, such as an index or table. A cursor is maintained that points to a start entry in the database object. The database object has rows...
6651216 Efficiently navigating a workbook linked to a database
Nov-18-2003 A way to navigate efficiently among worksheets in a workbook linked to a database that involves double-clicking on a cell in a page showing totals and having the detail page associated with cell be displayed.
6640234 Extension of formulas and formatting in an electronic spreadsheet
Oct-28-2003 Methods for automatically, without user instruction, extending a format and/or a formula to include a cell in an electronic spreadsheet. A previously blank newly edited cell may be determined to be an...
6631497 Binding data from data source to cells in a spreadsheet
Oct-7-2003 A method including importing data objects from different data sources to define a data source model, associating each data object with one or more cells in a spreadsheet, and binding data from the data...
6631380 Counting and displaying occurrences of data records
Oct-7-2003 Occurrences of data records in a non-relational database are counted by first selecting rows of data records. A counter field is created and appended to the selected rows. The counter field is weighted...
6626959 Automatic formatting of pivot table reports within a spreadsheet
Sep-30-2003 Automatically formatting a spreadsheet pivot table using one of a plurality of predefined formats that include banded report formats and tabular report formats. The pivot table is reformatted automatically,...