Particular Cell Content Modification Patents (Class 715/220)
  • Publication number: 20100275110
    Abstract: A network mobility server, which includes a target device inventory module, a data collection module, a data management module and a distribution module. The data management module, includes at least one data storage module, in which at least a portion of the data stored therein are identical data items stored in different selected formats suitable for use on mobile computing and telecommunication devices. The network also includes network agents, resident on numbers of the network members.
    Type: Application
    Filed: July 9, 2010
    Publication date: October 28, 2010
    Applicant: SOONR CORPORATION
    Inventors: Martin Frid-Nielsen, Steven Ray Boye, Lars Gunnersen, Song Zun Huang
  • Publication number: 20100241516
    Abstract: Systems and methods for editing online advertising campaigns from a summary interface. A summary interface can be provided. The summary interfaces shows filed fields associated with one or more advertising campaigns in a view mode. Upon receipt of a request to edit one or more of the fields, the summary interface transitions to an edit mode for editing of the selected fields and editing of hidden fields that are associated with the selected fields and that are not displayed in the view mode.
    Type: Application
    Filed: March 18, 2009
    Publication date: September 23, 2010
    Applicant: Google Inc.
    Inventors: Ye-Jeong Kim, Ambar Pansari, Jeffrey Caesar, Joseph M. Ashear
  • Patent number: 7797643
    Abstract: A user interface comprises an interactive control and method for quickly changing the amount of text displayed in each item in a list of text items. The control allows the user to choose from a large range of choices for how much text is displayed and provides live updates of the changes. The method saves the user time by eliminating the need to refresh the screen when changing the amount of text displayed.
    Type: Grant
    Filed: September 27, 2004
    Date of Patent: September 14, 2010
    Assignee: Apple Inc.
    Inventors: Steven P. Jobs, Stephen O. Lemay, Jessica Kahn, Sarah Wilkin, David Hyatt, Jens Alfke, Wayne Loofbourrow
  • Patent number: 7797621
    Abstract: A method for altering data in a first data cell during a navigation between the first cell and a second data cell includes: (a) a user selecting the first cell; (b) the user indicating navigation from the first cell to a second cell; (c) posing a query to the user inquiring whether the user wants to alter a first element in the first cell for transfer to the second cell; (d) if the user desires to alter, providing an opportunity for the user to indicate a desired alteration; (e) the user entering an factor for the alteration; (f) employing the factor for the alteration to generate a first altered element and a second altered element; and (g) before the user effects completion of the navigation, entering the first altered element in the first cell and entering the second altered element in the second cell.
    Type: Grant
    Filed: October 26, 2006
    Date of Patent: September 14, 2010
    Assignee: Bank of America Corporation
    Inventors: Matthew P. Danner, John D. MacQueen
  • Patent number: 7783966
    Abstract: A system for performing a calculation processing for each cell in a sheet by setting a calculation formula to calculate values for the cell. The system includes: an input data selection unit for sequentially selecting, in response to association of a or a plurality of cells in a sheet having a plurality of input data recorded therein with a first cell, the plurality of input data as values for the first cell; a calculation unit for performing, in response to selection of the respective input data as values for the first cell, calculations of a calculation formula set in a cell other than the first cell and referring to the first cell; and a data output unit for outputting calculation results of the calculation formula obtained by the calculation unit for each of the input data as values of a or a plurality of second cells.
    Type: Grant
    Filed: March 13, 2007
    Date of Patent: August 24, 2010
    Assignee: International Business Macines Corporation
    Inventor: Kinichi Mitsui
  • Patent number: 7770100
    Abstract: 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.” When using a dynamic threshold, dynamic threshold values are determined based on values contained in a selected range of cells.
    Type: Grant
    Filed: February 27, 2006
    Date of Patent: August 3, 2010
    Assignee: Microsoft Corporation
    Inventors: Benjamin C Chamberlain, Bruce Cordell Jones, Christopher M Street, Eric B Vigesaa
  • Patent number: 7761782
    Abstract: A user programmable deductive spreadsheet is implemented as an add-in to an existing mathematical spreadsheet program and allows the use of a logic programming language such as Prolog via a familiar spreadsheet interface. A syntax is provided whereby a set of multiple values can be stored in a cell and can be operated on recursively by an expression in another cell. Rows and columns can be given user defined names and cells can be referenced by row and column name. Cells can reference cells in other spreadsheets or can reference an entire spreadsheet in one cell. A cell expression can reference itself. Logical, arithmetic, and lifted operators are provided. Spreadsheets can be defined as a transformation of another spreadsheet. When no negative or aggregate operators are used in the cell expressions, the meaning of the spreadsheet is given in terms of least fixed points. Otherwise, the meaning is given in terms of perfect models.
    Type: Grant
    Filed: October 25, 2005
    Date of Patent: July 20, 2010
    Assignee: XSB, Inc.
    Inventors: David S. Warren, Iyer Venkat Ramakrishnan, Coimbatore Rajamani Ramakrishnan
  • Patent number: 7743317
    Abstract: A formatting tool enables “smart” copy and paste functions. The “smart” copy and paste functions can be invoked in a context-sensitive manner, depending on the conditions under which the copy and paste functions are implemented. The present invention will automatically include in a selection a paragraph marker at the end of a selected paragraph, if every other textual character in the paragraph has been selected. The present invention will discard a paragraph mark that is included in pasted text if the pasted text is pasted into the middle of another paragraph, indicating that the user prefers the formatting of the pasted-into paragraph. The present invention also reduces inconsistencies in formatting styles that may exist between source and target documents automatically redefining a style in the target document to conform to a corresponding style in the source document. The present invention also automatically adjusts paragraph spacing, in response to text being pasted into a target document.
    Type: Grant
    Filed: February 7, 2005
    Date of Patent: June 22, 2010
    Assignee: Microsoft Corporation
    Inventors: Paul Broman, Glenn Frankel, Roberto C. Taboada
  • Patent number: 7739587
    Abstract: In a method for identifying cells, line graphics are converted into vectors (12) having a canonical form without vector overlaps or crossings. Connecting vectors (22, 24, 26, 30, 32) are associated, including (i) forking vectors (22) having common starting points, and (ii) meeting vectors (24) having common ending points. A set of vectors is identified including at least two forking vectors and two meeting vectors cooperatively defining a cell.
    Type: Grant
    Filed: June 12, 2006
    Date of Patent: June 15, 2010
    Assignee: Xerox Corporation
    Inventor: Jean-Yves Vion-Dury
  • Publication number: 20100122152
    Abstract: Generally described, embodiments of the present invention relate to applying and evaluating conditional formatting rules to a given range of cells. Additionally, multiple conditional formatting rules may be evaluated to TRUE for the same cell contained in a user interface and multiple formats applied to that cell.
    Type: Application
    Filed: November 13, 2009
    Publication date: May 13, 2010
    Applicant: MICROSOFT CORPORATION
    Inventors: Benjamin C. Chamberlain, Bruce Cordell Jones, Christopher M. Street, Eric B. Vigesaa
  • Publication number: 20100107048
    Abstract: A document processing apparatus includes a spreadsheet unit which processes, in a spreadsheet sheet format, a document described in a markup language. The spreadsheet unit includes: a display unit which displays, in a spreadsheet format, data which is contained in a document and which is described in a tag set defined for a spreadsheet; and an editing unit which inserts, into the spreadsheet, data which is contained in the document and which is described in a tag set that differs from the tag set for the spreadsheet.
    Type: Application
    Filed: March 12, 2008
    Publication date: April 29, 2010
    Applicant: JUSTSYSTEMS CORPORATION
    Inventor: Takashi Takahara
  • Patent number: 7702997
    Abstract: A system architecture integrates spreadsheet functionality into text. The architecture allows insertion of discrete individual fields, referred to as “free floating fields”, inline with normal textual sentences. In an HTML document, for example, the free floating fields are elements constructed along with text elements and rendered together as an integrated document. Once rendered, the free floating fields present contents that resemble normal text consistent with the surrounding text. The free floating fields offer spreadsheet functionality, including the ability to handle complex formulas, reference values in a separate free floating field or table, and automatically recalculate the formulas when a source value changes.
    Type: Grant
    Filed: October 8, 2004
    Date of Patent: April 20, 2010
    Assignee: Microsoft Corporation
    Inventors: Matthew J. Kotler, Alexander G. Gounares, Oliver G. Fisher, Matthew D. Morgan, Christopher Matthew Franklin
  • Publication number: 20100083091
    Abstract: In some embodiments, text that includes one or more prescribed characters is represented on a pasteboard in a plurality of representations, including an escaped representation that escapes the one or more prescribed characters so that a format of the text can be preserved when the text is pasted into a cell of a spreadsheet application that does not natively support inclusion of the one or more prescribed characters in cell content.
    Type: Application
    Filed: September 30, 2008
    Publication date: April 1, 2010
    Inventors: Peter Glen Berger, Tamara Lynn Abell
  • Publication number: 20100058163
    Abstract: A spreadsheet system stores objects and formulas in the cells of the spreadsheet, along with metadata tags. Each cell may contain multiple objects (such as a group of photos). Drag-and-drop user actions automatically change tags associated with the moved objects based on a formula stored in the target cell if a forcing semantics mode is active, or automatically change a formula stored in the target cell if a non-forcing semantics mode is active. A formula in a cell selects a set of objects and may include set operators such as union, intersection, and minus. The formula may also filter sets to select a subset based on specified tag attributes of objects. The display of the spreadsheet adaptively selects a subset of objects to render in a cell and appropriately scales photos for optimal viewing.
    Type: Application
    Filed: August 26, 2009
    Publication date: March 4, 2010
    Inventors: Hector Garcia-Molina, Sean Kandel, Andreas Paepcke, Martin Theobald
  • Patent number: 7669115
    Abstract: 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 spreadsheet technology to achieve collaborative exchanges of information on an enterprise-wide basis. The method and system also facilitate efficacious remote information access and exchange, e.g., over a computer network such as the Internet and/or the World Wide Web, through a caching function that combines individual queries initiated by a spreadsheet program before transmitting across a network to a server for consideration.
    Type: Grant
    Filed: October 25, 2005
    Date of Patent: February 23, 2010
    Assignee: OutlookSoft Corporation
    Inventors: Charles J. Cho, Perlie E. Voshell
  • Patent number: 7665013
    Abstract: 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 referencing array cell includes a reference to a cell outside a bound array, the package indicates an error in the formula.
    Type: Grant
    Filed: December 23, 2005
    Date of Patent: February 16, 2010
    Assignee: International Business Machines Corporation
    Inventor: Stephen James Todd
  • Patent number: 7657830
    Abstract: Described is an information sharing method and mechanism used by a layout system to share information across related column and row user interface elements (corresponding to definitions). Definitions of a table or grid are grouped together with respect to sizing via a common group name. Scope values may be used to limit the grouping to selected subtrees of elements. When layout occurs, size sharing information is determined for the group-related definitions via a common size sharing object. Grouped definitions thus may be sized to the largest content to display of any one element. Elements corresponding to definitions may be manually sized by a user, or may be based on the size of a defined master element, such as the width of a header. The scope value of a group may be changed dynamically, such as by user interaction, which may cause groups to merge or split.
    Type: Grant
    Filed: May 4, 2005
    Date of Patent: February 2, 2010
    Assignee: Microsoft Corporation
    Inventors: Oleg V. Ovetchkine, Dmitry G. Titov, Henry D. Hahn
  • Patent number: 7647551
    Abstract: 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 cell. The data cell is formatted according to the data set and the condition without requiring that the data set be stored locally in the document.
    Type: Grant
    Filed: December 15, 2004
    Date of Patent: January 12, 2010
    Assignee: Microsoft Corporation
    Inventors: Eric Barber Vigesaa, Benjamin C. Chamberlain, Christopher M. Street, Bruce Cordell Jones
  • Publication number: 20100005382
    Abstract: A computer-implemented method for recording an asset survey or installation, comprising storing data received from an electronic database in an independent spreadsheet application operable on a portable electronic device, the data including identifying information for new and/or old assets and an employee listing. At least one field of the independent spreadsheet application is prepopulated with a set of data displayed in a drop down menu when the independent spreadsheet application is not operably connected to the asset management database. A variable is selected from the set of data presented in the drop-down menu associated with the at least one field displayed on the independent spreadsheet when the independent spreadsheet application is not operably connected to the asset management database. The selected variable is stored as a record located in a storage worksheet of the independent spreadsheet application when the spreadsheet application is not operably connected to the asset management database.
    Type: Application
    Filed: July 1, 2008
    Publication date: January 7, 2010
    Applicant: International Business Machines Corporation
    Inventors: Richard C. Curran, Scott D. Hicks, James A. Martin, Douglas G. Murray, Jeffrey E. Prince
  • Publication number: 20100005383
    Abstract: Metatag identifiers are stored in a spreadsheet, and are made available for use in metatagging various files. Steps may include: identifying the item of data in a document; activating an activation code; providing a listing of metatag choices; selecting a metatag from the listing of metatag choices; identifying the selected metatag with a column in the spreadsheet; and storing at least a portion of the item of data in a cell of the column. The listing is preferably a visually displayed listing, and selection can be made by clicking. Data previously associated with a metatag, and stored in the spreadsheet can be displayed as values. The values for a given metatag can thus be sorted and listed, providing immediate feedback to a user to assist in determining the propriety of a particular metatag.
    Type: Application
    Filed: August 20, 2009
    Publication date: January 7, 2010
    Inventor: Robert D. Fish
  • Publication number: 20090319553
    Abstract: According to some embodiments, a system, method, means, and/or computer program code are provided to facilitate use of a spreadsheet application to access information stored in a multi-dimensional data source. Some embodiments include receiving, at an analyzer module, a change indication from the spreadsheet application, the change indication being associated with an identifier entered by a user into a spreadsheet cell. In response to the change indication, a member associated with the identifier in a multi-dimensional data source may be dynamically determined. Information in the spreadsheet may then be replaced with a formula based at least in part on the determined member.
    Type: Application
    Filed: June 19, 2008
    Publication date: December 24, 2009
    Inventors: Pierre Jean Le Brazidec, Florent Migeon
  • Patent number: 7627812
    Abstract: 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 be varied with a value.
    Type: Grant
    Filed: October 27, 2005
    Date of Patent: December 1, 2009
    Assignee: Microsoft Corporation
    Inventors: Benjamin C. Chamberlain, Bruce C. Jones, Christopher M. Street, David F. Gainer, Eric B. Vigesaa
  • Patent number: 7617443
    Abstract: A method of consolidating data from multiple spreadsheets includes selecting multiple spreadsheets (52). Portions of data from files corresponding to each of the spreadsheets (52) are also selected. Automated consolidation of said portions of data is executed. The consolidation includes retrieval of the portions of data, generation of a final report spreadsheet (124), and appendage of the portions of data to the final report spreadsheet (124).
    Type: Grant
    Filed: August 4, 2003
    Date of Patent: November 10, 2009
    Assignee: AT&T Intellectual Property I, L.P.
    Inventors: Scott H. Mills, Kurt M. Joseph, Melissa L. Oldenburg, Mark A. Nixon
  • Patent number: 7617444
    Abstract: File formats, methods, and computer program products are provided for representing a workbook in a modular content framework. The modular content framework may include a file format container associated with modular parts. A file format includes logically separate modular parts that are associated with each other by one or more relationships where each modular part is associated with a relationship type. The modular parts include a workbook part operative as a guide for properties of the workbook and a worksheet part associated with the workbook part and operative to specify a definition of cells within a worksheet associated with the worksheet part. The modular parts may also include a document properties part containing built-in properties associated with the file format and a thumbnail part containing associated thumbnails. Each modular part is capable of being interrogated separately, extracted from the workbook, and/or reused in a different workbook.
    Type: Grant
    Filed: December 20, 2004
    Date of Patent: November 10, 2009
    Assignee: Microsoft Corporation
    Inventors: Chad B. Rothschillwe, Su-Piao B. Wu
  • Patent number: 7581165
    Abstract: 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 spreadsheet technology to achieve collaborative exchanges of information on an enterprise-wide basis. The method and system also facilitate efficacious remote information access and exchange, e.g., over a computer network such as the Internet and/or the World Wide Web, through a caching function that combines individual queries initiated by a spreadsheet program before transmitting across a network to a server for consideration.
    Type: Grant
    Filed: October 25, 2005
    Date of Patent: August 25, 2009
    Assignee: OutlookSoft Corporation
    Inventors: Charles J. Cho, Perlie E. Voshell
  • Patent number: 7549117
    Abstract: 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 to categorize different parts of the world. Primarily, the LCID categorizes different parts of the world by language such as English, German, French, Thai, Arabic, etc. The LCID is used to determine what language to display month names, month abbreviations, weekday names, weekday abbreviations, time designations such as AM/PM, etc. The calendar type supports both Gregorian and non-Gregorian calendars. Calendar type is a value to indicate which calendar should be used to calculate the date from the value. The number shape is a value that indicates what shape in which to represent the number.
    Type: Grant
    Filed: July 22, 2005
    Date of Patent: June 16, 2009
    Assignee: Microsoft Corporation
    Inventors: Marise Chan, Barry C. McCord, Kenneth E. Schmidt, James Sukhabut, Christopher C. Yu
  • Patent number: 7546521
    Abstract: 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 and their status. The user may select a Check Status button in the Edit Links dialog box to check the status of the links without updating the links because updating the links may require considerable time. A textual status message is displayed for each link in the Edit Links dialog box. The textual status message indicates to the user whether there is s possible problem with the link. As part of checking the status of a link, an analysis is made to determine whether any problems with the source file exist. For instance, it is determined whether the source file is open and whether it is valid. The results of this analysis determine what is displayed in the status column of the Edit Links dialog box.
    Type: Grant
    Filed: December 8, 2004
    Date of Patent: June 9, 2009
    Assignee: Microsoft Corporation
    Inventors: Jesse Raymond Bedford, Matthew C. Gauthier, Tuan E. Huynh, Ramakrishnan NataraJan, Justin M. Maguire, III, Marcella C. S. Rader
  • Patent number: 7546523
    Abstract: In an electronic multidimensional spreadsheet, a method for displaying and/or hiding on a user interface including (A) detecting a command for hiding at least one element in a selected range of cells, the command identifying a display focus level selected among a plurality of ordered display focus levels defined for the selected range of cells; (B) identifying the selected range of cells comprising the element to hide; (C) identifying the selected display focus level; (D) identifying a table associated with the selected range of cells, the table associating each defined display focus level with at least one cell content criteria to apply to the content of the at least one cell; and (E) selectively displaying the element on the user interface based on the relationship of the selected display focus level with the display focus level associated with the element.
    Type: Grant
    Filed: November 19, 2002
    Date of Patent: June 9, 2009
    Assignee: International Business Machines Corporation
    Inventors: Jean-Jacques Aureglia, Frederic Bauchot
  • Publication number: 20090100324
    Abstract: The present invention is directed to a method, system and computer program for copying and pasting, in an electronic multidimensional spreadsheet, displayed elements of a source range of cells onto a destination range of cells, the source range of cells including one or more elements displayed on a user interface and one or more hidden elements, the elements being contiguous and aligned along a given spreadsheet dimension. The method includes (A) detecting a command for copying at least one displayed element from a selected source range of cells onto a selected destination range of cells; (B) identifying the selected source range of cells; (C) identifying the at least one displayed element in the selected source range of cells; (D) identifying at least one hidden element in the selected source range of cells; (E) copying the displayed element and hidden element onto a temporary range of cells; and (F) copying the temporary range of cells onto the destination range of cells.
    Type: Application
    Filed: October 24, 2008
    Publication date: April 16, 2009
    Inventors: Jean-Jacques Aureglia, Frederic Bauchot
  • Publication number: 20090100325
    Abstract: The present invention is directed to a method, system and computer program for copying and pasting, in an electronic multidimensional spreadsheet, displayed elements of a source range of cells onto a destination range of cells, the source range of cells including one or more elements displayed on a user interface and one or more hidden elements, the elements being contiguous and aligned along a given spreadsheet dimension. The method includes (A) detecting a command for copying at least one displayed element from a selected source range of cells onto a selected destination range of cells; (B) identifying the selected source range of cells; (C) identifying the at least one displayed element in the selected source range of cells; (D) identifying at least one hidden element in the selected source range of cells; (E) copying the displayed element and hidden element onto a temporary range of cells; and (F) copying the temporary range of cells onto the destination range of cells.
    Type: Application
    Filed: October 27, 2008
    Publication date: April 16, 2009
    Inventors: Jean-Jacques Aureglia, Frederic Bauchot
  • Patent number: 7509571
    Abstract: Methods and Systems in accordance with the present invention provide a file format for storing spreadsheets compactly on PDAs. PDAs only contain a limited amount of computer memory due to their small size and processing ability. To reduce memory constraints caused by PDA spreadsheet applications, the present invention reduces memory allocated for file storage by optimizing the compression of individual spreadsheet files within a database record storage system. This method and system in accordance with the present invention uses a collection of records to represent a spreadsheet file.
    Type: Grant
    Filed: January 3, 2001
    Date of Patent: March 24, 2009
    Assignee: Sun Microsystems, Inc.
    Inventors: Paul J. Rank, David J. Proulx, Mingchi Stephen Mak, Herbert T. Ong, Akhil K. Arora
  • Patent number: 7506243
    Abstract: An architecture integrates spreadsheet functionality into tables commonly used in word processing programs and HTML documents. The architecture presents a table user interface (UI) that resembles a table when not being edited and adds spreadsheet elements to the table when being edited. Underlying the table UI, the architecture separates data handling functions from presentation functions. The architecture includes a table appearance manager to manage how the table appears in a document including such characteristics as table resizing, selection, cut, copy, paste, split, merge, table formatting and so on. The architecture also has a spreadsheet functionality manager to manage the spreadsheet functions for the table, such as recalculation, formula handling, sorting, referencing, and the like.
    Type: Grant
    Filed: October 9, 2004
    Date of Patent: March 17, 2009
    Assignee: Microsoft Corporation
    Inventors: Matthew J. Kotler, Alexander G. Gounares, Oliver G. Fisher, Richard J. Wolf, Vinod G. Anantharaman, Matthew D. Morgan, Christopher Matthew Franklin
  • Patent number: 7506242
    Abstract: An architecture integrates spreadsheet functionality into tables commonly used in word processing programs and HTML documents. The architecture presents a table user interface (UI) that resembles a table when not being edited and adds spreadsheet elements to the table when being edited. Underlying the table UI, the architecture separates data handling functions from presentation functions. The architecture includes a table appearance manager to manage how the table appears in a document including such characteristics as table resizing, selection, cut, copy, paste, split, merge, table formatting and so on. The architecture also has a spreadsheet functionality manager to manage the spreadsheet functions for the table, such as recalculation, formula handling, sorting, referencing, and the like.
    Type: Grant
    Filed: October 8, 2004
    Date of Patent: March 17, 2009
    Assignee: Microsoft Corporation
    Inventors: Matthew J. Kotler, Alexander G. Gounares, Oliver G. Fisher, Richard J. Wolf, Vinod Anantharaman, Matthew D. Morgan, Christopher Matthew Franklin
  • Publication number: 20090044093
    Abstract: Cutting and copying discontiguous selections of cells is disclosed. In some embodiments, in response to receiving an indication of a selection of a set of cells that does not include only a continuous grid of selected cells and receiving an indication of a selection of a paste destination in which the set of cells is desired to be pasted, the set of cells is pasted in the paste destination in a manner that preserves a respective relative position of each cell in the set. In some embodiments, if a paste destination is not large enough to accommodate a paste operation, the paste destination is automatically expanding so that it is large enough to accommodate the paste operation.
    Type: Application
    Filed: August 6, 2007
    Publication date: February 12, 2009
    Inventors: Peter Glen Berger, Jay Christopher Capela, Yaniv Gur, Roger Rock Rosner, Peter Su, Christopher Douglas Weeldreyer
  • Publication number: 20090044094
    Abstract: Automatically completing a remainder portion of a name as it is being entered is disclosed. In some embodiments, in response to receiving at least a prescribed number of starting characters of a name being entered into a first cell as a reference name to refer to one or more other cells, a set of one or more valid reference names that begin with the received starting characters is determined and provided as auto-completion options. In such cases, a valid reference name is one that identifies using a supported syntax a spreadsheet document or a portion of a spreadsheet document.
    Type: Application
    Filed: August 6, 2007
    Publication date: February 12, 2009
    Inventor: Peter William Rapp
  • Publication number: 20080301542
    Abstract: A digital paper-enabled system includes a spreadsheet printed on digital paper and usable with a digital writing instrument, such as a digital pen. A method of using the system includes (1) designing a digital paper-enabled spreadsheet with a spreadsheet integration module; (2) printing the designed spreadsheet to receive writing from a digital pen (3) uploading data from the digital pen to a processing system; (4) reviewing the uploaded data using a display device associated with the processing system; and (5) storing the uploaded data, which may include exporting one or more portions of the uploaded data to another display or processing system.
    Type: Application
    Filed: June 2, 2008
    Publication date: December 4, 2008
    Inventors: David McGee, Philipp Schmid, Ben McAllister, Phil Cohen, Michael Robin
  • Patent number: 7451397
    Abstract: A system and method for automatically completing a formula of a spreadsheet application, calculator application, accounting application, business application or banking application. One aspect of the present invention is a computer-implemented method for automatically completing formulaic cell data. The computer-implemented method includes a step for substantiating an autocomplete process in response to a user input of formulaic cell data and aggregating autocomplete options based on the user input. Another aspect of the present invention includes displaying a dynamic list of autocomplete options when the user input is a trigger.
    Type: Grant
    Filed: December 15, 2004
    Date of Patent: November 11, 2008
    Assignee: Microsoft Corporation
    Inventors: Brandon G. Weber, Charles David Ellis
  • Patent number: 7444584
    Abstract: Methods and systems are provided for formulaically redirecting and modifying formula set operations in a spreadsheet application. A spreadsheet application may link the contents of one spreadsheet cell to other spreadsheet cells so that changes in one cell are reflected in linked cells. Three spreadsheet functions are provided which allow for formulaically redirecting and modifying formula set operations in a spreadsheet application. A first spreadsheet function, SETATREF, redirects a formula set in one spreadsheet cell to another spreadsheet cell. The SETATREF function may also allow a formula set to one spreadsheet cell to be redirected to and modified in a second spreadsheet cell. A second spreadsheet function, SETATREFEXPR, redirects a formula set to a formulaic location within a spreadsheet cell. A third function, SETATREFEVAL, allows for an evaluation of a formula at formula set-time.
    Type: Grant
    Filed: March 30, 2004
    Date of Patent: October 28, 2008
    Assignee: Microsoft Corporation
    Inventor: Craig A. Hobbs
  • Publication number: 20080256433
    Abstract: A system and method for copying and pasting cells in a multi-dimensional spreadsheet. The method is implemented by execution of program code by a processor of a computer system. A source range of cells is copied and pasted in a multi-dimensional spreadsheet onto a destination range of cells in the spreadsheet by performance of a comprehensive paste of the source range of cells onto the destination range of cells. A graphical object in the source range of cells has an associated fastened range of cells, and an associated working range of cells identified by a first relative offset. The copying and pasting results in: the graphical object being within the destination range of cells; and the fastened range of cells and the working range of cells being respectively pasted into an associated fastened range of cells and an associated working range of cells in the destination range of cells.
    Type: Application
    Filed: August 17, 2007
    Publication date: October 16, 2008
    Inventors: Jean-Jacques Aureglia, Frederic Bauchot, Catherine Soler
  • Patent number: 7430709
    Abstract: 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 spreadsheet technology to achieve collaborative exchanges of information on an enterprise-wide basis. The method and system also facilitate efficacious remote information access and exchange, e.g., over a computer network such as the Internet and/or the World Wide Web, through a caching function that combines individual queries initiated by a spreadsheet program before transmitting across a network to a server for consideration.
    Type: Grant
    Filed: May 27, 2004
    Date of Patent: September 30, 2008
    Assignee: OutlookSoft Corporation
    Inventors: Charles J. Cho, Perlie E. Voshell
  • Publication number: 20080215959
    Abstract: Methods and systems are described for generating a media stream in a media spreadsheet. The method includes presenting, via a user interface, an electronic spreadsheet having a plurality of cells. The method also includes receiving an association of a source media stream object with a first cell of the plurality of cells. The method further includes receiving an association of a media stream transformation operation with one of the first cell and a second cell of the plurality of cells, wherein the media stream transformation operation references, respectively, one of the source media stream object and the first cell. The method also includes automatically applying the media stream transformation operation to the source media stream object to generate a resultant media stream object, based on the reference. The method further includes associating the resultant media stream object with at least one of the plurality of cells of the electronic spreadsheet.
    Type: Application
    Filed: February 28, 2007
    Publication date: September 4, 2008
    Inventor: David B. Lection
  • Patent number: 7415664
    Abstract: The present invention is directed to a method, system and program for exporting-importing the content of input cells from a source scalable template instance in a source multi-dimensional spreadsheet to a destination scalable template instance in a destination multi-dimensional spreadsheet; a multi-dimensional spreadsheet comprising a plurality of cells identified by a cell address along each dimension; a scalable template instance comprising a variable number of contiguous elements of same size ordered and aligned along a given spreadsheet dimension and structured according to information defined in an associated scalable template; an element being defined as a range of cells; a range of cells comprising one or a plurality of cells; said scalable template comprising an element profile; an element profile defining a cell content and a cell destination for each cell within each element; said cell destination specifying whether the cell is an input cell for receiving an entry or an output cell for producing a r
    Type: Grant
    Filed: July 26, 2002
    Date of Patent: August 19, 2008
    Assignee: International Business Machines Corporation
    Inventors: Jean-Jacques Aureglia, Frederic Bauchot
  • Publication number: 20080183766
    Abstract: A method for updating data within a database is described. The method includes identifying data elements within the database that need to be updated, creating a data transformation matrix for analysis of changes to the data elements, creating a database update script including an update command for each group of changes, and running the database update script to update the database.
    Type: Application
    Filed: August 14, 2007
    Publication date: July 31, 2008
    Inventors: David W. Weston, Navin V. Kurani
  • Patent number: 7395497
    Abstract: In a storage area network (SAN) management application, large data sets tend to produce unwieldy results upon display attempts. A mechanism for gathering and organizing a large data set into an ordered set of output display entries which does not require main memory storage for the entire large data set, generates a displayable portion without excessive memory consumption. Configurations employ a multiple pass gathering and organization operation. An output criteria specifies a key field and identifies a range of entries by specifying a particular screen for display from among the full range of screens. A parser retrieves and identifies the entries, during a first pass, using only the key field and an index for each of the entries in the large data set, to avoid loading all fields of each entry in entirety. A second pass fetches entries only for the identified entries corresponding to the output criteria.
    Type: Grant
    Filed: October 31, 2003
    Date of Patent: July 1, 2008
    Assignee: EMC Corporation
    Inventors: Christopher A. Chaulk, Udi Bar-On, Xiaohua Cheng
  • Patent number: RE41500
    Abstract: Input to the system is buffered by the forms manager to determine access to the tile/region and to check entered data. The tile/region will retain various information such as data entered, user, time, changes, etc. To display a form, the forms manager obtains a list of objects to be displayed. This list of objects is then edited to remove objects which are not utilized and to place the remaining objects in a prioritized order. The forms manager then generates the display.
    Type: Grant
    Filed: October 9, 2001
    Date of Patent: August 10, 2010
    Assignee: Eclipsys Corporation
    Inventors: Richard Edward Shelton, Ronald Evan Norden-Paul, Audree Anne Thurman, Stanley Carl Person