FREE patent keyword monitoring and additional FREE benefits. /images/triangleright (1K) REGISTER now for FREE triangleleft (1K)
Fresh Patents
Monitor Patents Patent Organizer How to File a Provisional Patent Browse Inventors Browse Industry Browse Agents Browse Locations


Data Processing: Presentation Processing Of Document, Operator Interface Processing, And Screen Saver Display Processing > Presentation Processing Of Document > Spreadsheet

Spreadsheet

Spreadsheet patent applications listed are from June 2005 to current and include Date, Patent Application Number, Patent Title, Patent Abstract summary and are linked to the corresponding patent application page.

10/25/07 - 20070250764 - Using a spreadsheet engine as a server-side calculation model
This disclosure is directed to novel solutions for processing data in a manner similar to that employed by traditional spreadsheet applications (including, merely by way of example, evaluating expressions, producing reports and the like) without the need for a spreadsheet application. In an aspect, a spreadsheet calculation engine might be ...

09/06/07 - 20070208992 - Collaborative, flexible, interactive real-time displays
The invention relates to a method and apparatus for providing information in an easily customizable, interactive and collaborative format. The invention can be looked at as the combination of one or more functional components in one aspect, the invention features aggregating raw data on at least one DataServer connected to ...

08/30/07 - 20070204212 - Dynamic thresholds for conditional formats
Generally described, embodiments of the present invention provide the ability to utilize dynamic thresholds and dynamic threshold values when generating variable formatting rules to be applied to a range of cells. Dynamic thresholds include, but are not limited to, “Highest Value,” “Middle Value,” “Lowest Value,” “Number,” “Percent,” “Percentile,” and “Formula.” ...

08/16/07 - 20070192677 - Method and a program for estimating building material quantities
A method and a computer program for estimating item quantities in a building project that includes one or more items. The method includes steps for providing a spreadsheet template including a summary worksheet and one or more input worksheets with a plurality of cells for estimating a quantity of an ...

07/19/07 - 20070168854 - User interface for presentation of solutions in multi-passenger multi-route travel planning
A graphical user interface includes a first set of columns for displaying details for a first passenger group, a second set of columns for displaying details for a second passenger group and a third set of columns for displaying details for joint solution properties of a joint solution involving the ...

07/05/07 - 20070157074 - System for and method of providing overview of a worksheet in an electronic report
A worksheet overview system comprises an item information handler, an overview element handler, an overview area handler, and an overview synchronizer. The item information handler obtains item information relating to items of a worksheet. The overview element handler manages overview elements based on the item information. Each overview element represents ...

06/21/07 - 20070143661 - Data mining and reporting
An integrated system is described that allows a user to easily mine and report data maintained by a customer relationship management (CRM) application. In general, the system automates the process of creating electronic reports, such as an electronic worksheet, in a format that can be directly manipulated and viewed from ...

06/14/07 - 20070136653 - Spreadsheet calculation as part of workflow
A workflow includes an activity that takes advantage of spreadsheet calculations. For a spreadsheet activity, calculation and extraction of values from a spreadsheet is performed. Thus, spreadsheet calculations are integrated into workflows without user intervention. Values from previous activities in the workflow may be obtained and provided to the spreadsheet ...

06/14/07 - 20070136652 - Extensible value types in cells
Individual cells within a spreadsheet may contain an extensible value as defined by an extensible value type. The extensible value type is a user defined value type that is incorporated into the spreadsheet as a supported data type. Generally, the extensible data types provide support for types that are not ...

06/07/07 - 20070130502 - Grid entry user interface extensions
A computer-readable medium has computer-executable instructions for generating a user interface on a display device, the user interface includes a grid having a plurality of cells. The user interface also includes a visual affordance presented on the grid and visually connected to one of the plurality of cells, the visual ...

05/03/07 - 20070101252 - Variable formatting of cells
Variable formatting for cells in computer spreadsheets, tables, and other documents is provided. For a selected range of cells, cell formats vary with the value in each cell (or an associated value). Formats can include color-scale backgrounds, in-cell elements (e.g., icons and data bars), and other cell formats that can ...

03/29/07 - 20070074099 - Computer-implemented method, system, and program product for advising a client
Under the present invention, as an interviewer conducts interviews with interviewees, the interviewer will record the interview details (e.g., questions, interviewee comments, etc.) in one or more word processing documents. Thereafter, the comments (and optionally the questions) will be populated into a first column of spreadsheet pages, with each interview ...

03/15/07 - 20070061699 - Named object view of electronic data report
A named object view of a report is generated from an electronic data file. Objects in the file to be published are identified in the file. A named object view of the report associated with the file is generated by publishing the identified objects. A viewer at a client is ...

03/15/07 - 20070061698 - Designating, setting and discovering parameters for spreadsheet documents
For standalone spreadsheet applications and/or Web-based spreadsheet services, the ability to designate, discover and set parameters for spreadsheet documents is provided. When creating a spreadsheet document, the ability to designate certain cells or ranges of cells as parameters to a spreadsheet is enabled. Furthermore, whether viewed in a standalone spreadsheet ...

03/08/07 - 20070055922 - Autocompleting with queries to a database
An autocomplete method and system provides suggested completions for partial data entries based upon predefined coordinates, operands and/or commands. In one embodiment, the partial data entry may be in an active cell of a spreadsheet and the predefined coordinates may be queried from a separate, preconfigured, multi-dimensional database linked to ...

03/01/07 - 20070050700 - Formattable spreadsheet table elements with automatic updating
Spreadsheets are subdivided into formattable table elements that may include multiple table cells so that the multiple table cells can be formatted as a single element. As such, a gradient format can be applied across the range of multiple table cells instead of to individual table cells. A format property ...

03/01/07 - 20070050699 - Customizable spreadsheet table styles
Table styles provide a way to format an entire spreadsheet table quickly and easily. According to described implementations, table styles can be created and customized for repeated use in a spreadsheet application. As a result, a user does not have to manually modify multiple formatting options for each table included ...

03/01/07 - 20070050698 - Add-in tool and method for rendering financial data into spreadsheet compliant format
The invention is a process and tool that provides a simple, streamlined method for users to convert and integrate datasets into their spreadsheet program without cutting and pasting data while increasing confidence in the accuracy of information. Through a seamless and simple interface, users can easily access online datasets by ...

03/01/07 - 20070050697 - Integrated spreadsheet expanding table with collapsable columns
GUI selected rows of a displayed spreadsheet are collapsed based on column values such that all of the rows having the same value in the selected column are represented by a single collapsed row with an indicator indicating the row is collapsed. All column values of all the rows of ...

02/08/07 - 20070033519 - Method and system for the graphical modeling of data and calculations of a spreadsheet
A method and system for the graphical modeling of calculations in a spreadsheet which generates a graphical representation of formulas and relevant data contained in a spreadsheet. This graphical representation consists of tree or graph structures. Any changes made to the trees or spreadsheet cells can subsequently be translated to ...

02/08/07 - 20070033518 - Computer-implemented method, system, and program product for hiding columns in an electronic table
Under the present invention, when a user resizes or otherwise hides a column in the electronic table, a graphical indicia is displayed that represents the hidden column(s). If a user interacts with the indicia (e.g., by hovering a mouse/input device over it), a pop-window will be displayed that identifies the ...

02/01/07 - 20070028159 - Change-oriented electronic spreadsheet application
The present invention provides a change-oriented method for organizing electronic spreadsheet data, comprising: saving the contents of the cells in the electronic spreadsheet and valid updates into the same electronic spreadsheet document, wherein the valid updates comprise the updates to the contents of the cells and the time information associated ...

02/01/07 - 20070028158 - Data processing method
A process definition method is disclosed. The method is typically for use with a report compiled from source data stored in a database and displayed to a user as a table having a plurality of cells. The method comprises: a) presenting the table of cells to the user; b) selecting ...

01/25/07 - 20070022368 - Method and system for hiding sensitive data in an electronic spreadsheet environment
A method and system for hiding sensitive data in an electronic spreadsheet. A first output equation expresses output data as a function of at least one first input data and at least one first intermediary result. The at least one first and second intermediary result are assigned as content of ...

01/18/07 - 20070016850 - System for controlling the display size of a formula bar in a spreadsheet
The present invention discloses a system for controlling the display size of a formula bar in a spreadsheet. Application of this system will make operation of the spreadsheet more convenient. The system for controlling the display size of the formula bar and a formula bar module are parallel in a ...

01/18/07 - 20070016849 - System and method in a data table for managing insertion operations in recursive scalable template instances
A method and system for managing insertion operations in a recursive scalable template instance (RSTI) of an electronic data table having dimensions D1 and D2. The RSTI includes contiguous recursive element instances (REIs) ordered and aligned along D1. The REIs include scalable template instances (STIs). Contiguous elements are inserted, upon ...

12/21/06 - 20060288267 - Pre-formulated spreadsheet cell groups
A computer-readable medium having computer-executable modules includes a computer spreadsheet application including a series of cells arranged in addressable rows and columns, and at least one set of linked cells having an embedded function and position relative to other cells in the series of cells, the embedded function being linked ...

11/30/06 - 20060271841 - Generating free form reports within a data array
Free form reports may be generated within a data array system such as a spreadsheet computer application. A user may select dimension members of a data source, such as an online analytical processing (OLAP) data cube. The user may position the dimension members as headers on the data array where ...

11/02/06 - 20060248443 - System and method for exporting spreadsheet data
Exporting data from a database to a spreadsheet application is performed without losing the spreadsheet formatting by having the data in the spreadsheet application, the tabular data, locally formatted. In accessing a database through a portal application, data is retrieved therefrom. This data is formatted in accordance with database itself ...

10/05/06 - 20060224947 - Scrollable and re-sizeable formula bar
The present invention relates to new and improved embodiments of systems and methods for displaying content within a spreadsheet graphical user interface. In one embodiment, a computer system has a graphical user interface that performs a method for displaying data within a spreadsheet application. The method comprises displaying a formula ...

10/05/06 - 20060224946 - Spreadsheet programming
Spreadsheet programming model and language is extended to create objects, with their associated state and set of defined behaviors, as first-class spreadsheet cell residents. Desired object behaviors can be invoked by calling methods on the objects through an event-based imperative programming language that potentially modifies the state of an object. ...

09/28/06 - 20060218483 - System, method and program product for tabular data with dynamic visual cells
An apparatus, method and program product for providing dynamic visual cells in tabular data. A computer has an application for selecting a range of cells in said tabular data. A routine within the application recognizes a request for a graphical plot for data contained within the selected range of cells. ...

09/21/06 - 20060212791 - Method and computer-readable medium for providing spreadsheet-driven key performance indicators
A method, system, apparatus, and computer-readable medium for providing spreadsheet-driven key performance indicators are disclosed. According to the method, a spreadsheet-driven key performance indicator is created that includes a location of a spreadsheet, a location of a cell within the spreadsheet to be utilized as an indicator value, and a ...

09/14/06 - 20060206800 - Method for displaying editable characters in a divided table cell
A divided table cell is generated by selecting one cell in a table and creating a new cell to display over the selected cell. Both cells contain a constraint that define an area where that cell cannot display objects. Objects comprise alphanumeric characters, graphical symbols or any representation in a ...

09/07/06 - 20060200752 - Method and system for laying out paginated content for viewing
A method and system in a document viewing control for laying out an invisible page grid based on various criteria, including whether the pages of a document are fixed, contain reflowable content, whether the fixed pages are all the same size, and where the user has actively focused a page ...

08/31/06 - 20060195780 - Psychology hierarchical experiment spreadsheet with pre-release event time synchronization
Creating and executing real-time psychological experiments with sub-millisecond time precision uses a Hierarchical Experiment Spreadsheet (HES) providing a hierarchical data structure and interface. The user adds/modifies experiment levels in a spreadsheet multilevel table representation. New objects and properties are added while maintaining the hierarchical structure of the experiment and prohibiting ...

08/03/06 - 20060174189 - Focusing on areas of the display of tabular data through hierarchical collapsing and expanding of cell areas
A method, apparatus and program product for focusing the display of tabular data wherein the display has multiple rows and columns of cells. A computer running a tabular data application includes a display for displaying the tabular data. The tabular data application includes a routine for defining a user defined ...

07/27/06 - 20060168508 - Method and apparatus for preparing source data files
Methods and systems for preparing source data files by a processing system. The processing system receives, either through an automated process or through manual entry, source data for a source computer system. Next, the processing system compares the value of the dimensions of the source data to the value of ...

06/22/06 - 20060136808 - Block properties and calculated columns in a spreadsheet application
Block properties and improved calculated columns properties are provided in a spreadsheet application. Once block properties are set for a group of spreadsheet cells or a spreadsheet list, the properties may be applied to the entire group of selected cells or list as opposed to requiring application of properties to ...

06/22/06 - 20060136807 - Method and system for creating a table in a text editing application
A table is created using keystrokes on a keyboard. Text to the left of a cursor is contained in a first column of the table when the table is created. Text to the right of the cursor is contained in a second column of the table when the table is ...

06/15/06 - 20060129913 - System and method for formatting a cell in response to data stored in a separate location
A data cell included in a document supporting cell structured data is conditionally formatted according to data that is stored in a separate location from the document. A user is allowed to select from a drop-down menu of related data sets a particular data set for conditionally formatting the data ...

06/01/06 - 20060117246 - System and method for performing over time statistics in an electronic spreadsheet environment
A method and system for computing statistical parameters for sets of data items, by executing instructions of a computer program that is coded within a spreadsheet. Each set is generated in a time sequence that is specific to each set. For each time sequence, each data item is one data ...

05/18/06 - 20060107196 - Method for expanding and collapsing data cells in a spreadsheet report
Data cells in a spreadsheet report are collapsed and expanded without disrupting other spreadsheet data. A user may want to drill down on data corresponding to a parent member of the report to display more detailed information about the parent member. Likewise, a user may want to drill up the ...

05/11/06 - 20060101326 - Error correction mechanisms in spreadsheet packages
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 referred to from a referencing array formula. If a formula within a ...

05/11/06 - 20060101325 - Liquid crystal display device and driving method of the same
The invention relates to an active matrix type liquid crystal display device and its driving method and provides a liquid crystal display device capable of omitting frame memory in image averaging processing among pixels for improving the smoothness of display and its driving method. For example, by providing an accumulated-charge-averaging ...

05/11/06 - 20060101324 - Data viewer
Methods, systems, and machine readable mediums are disclosed for viewing multidimensional data. In one embodiment, a method is disclosed which comprises displaying multidimensional data in a table format, the table format having a plurality of rows, a plurality of columns, and a plurality of cells displaying data, a first column ...

05/04/06 - 20060095833 - Method and apparatus for automatically producing spreadsheet-based models
A designer builds a condensed, generic form of a spreadsheet which is a definition file. This can be designed in Microsoft Excel, following a set of guidelines, or using a high level symbolic language. If required, HTML files, can be produced directly from the Excel definition file to enable the ...

05/04/06 - 20060095832 - Embedded spreadsheet commands
A cell of a spreadsheet is automatically updated and a comment is determined to have a command associated with the update. In response to detecting the command, the command is processed. ...

04/27/06 - 20060090125 - Interface-controlled display of a matrix document in regions
A method for displaying regions of a matrix. The matrix has at least one column and one or more rows having one or more fields related to individual data records. The method comprises: displaying a starting region of the matrix, the starting region having one or more rows with each ...

04/13/06 - 20060080596 - Dynamic update of changing data in user application via mapping to broker topic
A method and service for enabling a smallest unit of variable data within a data space of a user application to be dynamically updated using an external source. The application GUI is enhanced with a dynamic update utility (DUU) that enables the data unit to be selected and linked to ...

04/13/06 - 20060080595 - Methods, systems and computer program products for processing cells in a spreadsheet
Methods, systems and computer program products are provided for processing cells in a spreadsheet. A first formula contained in a first cell and a second formula contained in a second cell to provide a consolidated formula, wherein the second formula references the output of the first cell are automatically consolidated. ...

04/13/06 - 20060080594 - Methods, systems and computer program products for facilitating visualization of interrelationships in a spreadsheet
Methods, systems and computer program products are provided for visually indicating relationships among cells in a spreadsheet. Each of a first graphical linking element extending between cells in a first branch of a dependency tree of a root cell and a second graphical linking element extending between cells in a ...

04/06/06 - 20060075328 - Design of spreadsheet functions for working with tables of data
The present invention provides several database formulas that can manipulate large sets of data. Each database formula is customizable and repeatable without user intervention. Thus, users may enter numerous options that can cover the user's desire for data output in certain forms or formats, select a set of input data, ...

03/09/06 - 20060053363 - Graphically defining a formula for use within a spreadsheet program
A graphically defined formula is used within a spreadsheet implemented by a spreadsheet computer program by placing a reference to the graphically defined formula created by a tool. The reference is used to interface the spreadsheet computer program to an engine for evaluating the graphically defined formula. The graphically defined ...

03/02/06 - 20060048044 - Logical spreadsheets
A computerized spreadsheet system includes a set of cells and a separate set of logical constraints on the values of cells. The constraints may be many-to-many relationships that permit omni-directional propagation of values between cells. The constraints may be expressed in a language encompassing first-order logic. Cells are dynamically reclassified ...

02/23/06 - 20060041833 - Method and system for facilitating information exchange
A method and system for facilitating information exchange between individuals and entities interacting on a shared project are provided, and more particularly to a method and system for horizontal. i.e.. non-hierarchical, participation in and/or contribution to a spreadsheet-based project. The method and system is Web-based and utilizes conventional browser and ...

02/16/06 - 20060036939 - Support for user-specified spreadsheet functions
A facility for enabling the use of user-defined function in a spreadsheet document made up of cells is described. The facility receives a trigger to evaluate cells that include a distinguished cell. In response to receiving the trigger, the facility determines that the distinguished cell contains an invocation of a ...

02/16/06 - 20060036938 - Efficient method of migrating lotus domino documents to a non-domino web server, while preserving sections, using portable javascript
A method of mirroring Lotus Notes Domino documents to a non-Domino web server, while preserving document sections. Each request for expansion or collapsing of a section is handled at the client end when serving the mirrored copies of the original document. The number of fetches is reduced during retrieval of ...

02/02/06 - 20060026499 - Calendar based graphical user interface for manipulation of spatial operations and information
A computerized graphical user interface is provided for temporal manipulation of spatial operations and information. The interface comprising a general-purpose computer adapted for execution of instructions, wherein the instructions include a graphical user interface, and data for use by the general-purpose computer and adapted to be acted upon by the ...

02/02/06 - 20060026498 - Systems and methods for controlling report properties based on aggregate scope
A plurality of scope declarations can be provided to delineate various portions of any data structure, such as a matrix, a table, or a chart. Some scope declarations may correspond to portions of a horizontal axis, or columns, while other scope declarations may correspond to portions of a vertical axis, ...

01/19/06 - 20060015806 - Networked spreadsheet template designer
A networked spreadsheet template designer allows administrators to easily create and deploy robust reporting and input applications that leverage existing spreadsheet templates and knowledge in an easy to use user interface. Templates are created to operate directly in the particular spreadsheet program environment, such as Microsoft Excel®, and can be ...

01/19/06 - 20060015805 - Spreadsheet user-interface for an enterprise planning system having multi-dimensional data store
A spreadsheet environment is utilized to interact with a multidimensional data store associated with the enterprise planning session. In general, a conventional spreadsheet application is extended to provide additional functionality for interacting with the multidimensional data store maintained by the enterprise planning system. Instances of the extended spreadsheet application execute ...

01/19/06 - 20060015804 - Method and system for presenting editable spreadsheet page layout view
A page layout view of a spreadsheet is presented for display. The page layout view presents a single interface screen enabling a user to enter and revise data in a cell area of the spreadsheet, as well as manipulate a format of the spreadsheet as it will appear on a ...

01/12/06 - 20060010367 - System and method for spreadsheet data integration
A system and method for integrating data into a spreadsheet. According to one embodiment, a spreadsheet application provides authentication information to a data server by a spreadsheet application, the authentication information pertaining to a user of the spreadsheet application, receives query formulation data from the data server upon approval of ...

01/05/06 - 20060005115 - Method for facilitating the entry of mathematical expressions
A method of facilitating the entry of a mathematical expression into a workspace provided by a software application is described. The method includes receiving a plurality of characters input into the workspace by a user and, preferably, determining whether the characters represent a mathematical expression having at least a predetermined ...

12/08/05 - 20050273695 - Representing spreadsheet document content
A representation of a spreadsheet is displayed on a mobile communication device after receiving a description of a spreadsheet. The description relates to a plurality of map cells, where each map cell corresponds to a cell block, and the description includes location information and primary data type information for each ...

12/01/05 - 20050268215 - Method and apparatus for viewing and interacting with a spreadsheet from within a web browser
A method, system, and apparatus are provided for enabling a spreadsheet to be viewed and modified within the context of a Web browser application program. According to a method, a request is received to view a spreadsheet document in the Web browser application program. In response to the request, a ...

11/17/05 - 20050257133 - Worldwide number format for a spreadsheet program module
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 (LCID). The worldwide number format also includes a base number format and a value. The LCID is used ...

11/17/05 - 20050257132 - End user customizable computer spreadsheet application based expert system
The present invention provides an end user customizable computer spreadsheet application based expert system enabling end user customization without the need for the intervention of the expert system developer. The present invention achieves this objective by utilizing a commercially available computer spreadsheet application as a platform for enabling an end ...

11/10/05 - 20050251734 - Distribution matrix in an allocation table
A method, apparatus and program product are provided for displaying planned quantities of articles in a computerized allocation system. The method comprises displaying an allocation table having a listing of articles along one dimension and data regarding the articles along another dimension. The data regarding each article includes a total ...

11/10/05 - 20050251733 - Data insertion from a database into a fixed electronic template form
One embodiment in accordance with the invention relates to inserting data into a fixed electronic template form. For example, any publicly provided template form (e.g., IRS Tax Form for a Business) that may be provided in Portable Document Format (PDF) can be filled in with the proper data (e.g., XML ...

09/22/05 - 20050210369 - Methods of updating spreadsheets
The present invention provides methods of updating spreadsheet-based cells. One method of updating spreadsheet-based cells involves tapping on a cell and automatically increasing the value of the cell by a predetermined increment each time the cell is tapped. Another method of updating spreadsheet-based cells involves tapping on a cell, automatically ...

08/25/05 - 20050188298 - Displaying a web page in a browser window and a method for handling a web page
In the method for displaying a web page, a web page received from a server and comprising a frameset is displayed in the browser window of a terminal in such a manner that the frameset is converted into a different format. In the method, the frameset is converted into a ...

08/04/05 - 20050172217 - System and method for schemaless data mapping with nested tables
A system and method for mapping payload data to a spreadsheet list. The present invention comprises a system for mapping payload data to a spreadsheet list while supporting the implementation of nested tables, without the use of a schema. After receiving a spreadsheet list, the present invention generates the parent ...



###

FreshPatents.com Support