Particular Cell Content Modification Patents (Class 715/220)
  • Patent number: 9881396
    Abstract: Concepts and technologies are described herein for displaying temporal information in a spreadsheet application. In accordance with the concepts and technologies disclosed herein, spreadsheet data can be obtained at a computer system. The spreadsheet data can include data values, temporal information, and geographic information. The computer system can generate a visualization of the spreadsheet data based, at least partially, upon the data values, the temporal information, and the geographic location information. The computer system also can output the visualization.
    Type: Grant
    Filed: April 3, 2013
    Date of Patent: January 30, 2018
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: B. Scott Ruble, Curtis G. Wong, Igor Borisov Peev, Kevin Fan, Jai Srinivasan, Ehab Sobhy, Jonathan Edgar Fay
  • Patent number: 9875227
    Abstract: A method and system for entry of data into content of cells belonging to an output field. Entered into cells of a multidimensional table located within a header record in the table are: input field labels respectively corresponding to input fields in the table entered into a respective unique cell within the header record; and an output label corresponding to the output field entered into a specifically unique cell within the header record and expressed as a mathematical expression of input field labels. The mathematical expressions are translated into the cell address of the cell containing each input field label and then pasted in each cell of the output field. The cell address of the cell containing each input field label is replaced in the pasted mathematical expression by the corresponding cell address of each input field in the same record that contains each cell of the output field.
    Type: Grant
    Filed: April 16, 2014
    Date of Patent: January 23, 2018
    Assignee: International Business Machines Corporation
    Inventor: Frederic Bauchot
  • Patent number: 9785637
    Abstract: Systems and methods are disclosed herein for computing, applying, and displaying document deltas. Snapshots are stored of documents, and the stored snapshots are flattened. Deltas of the flattened snapshots are computed. The deltas are converted to representations of changes in the document by inverting the flattening. The representations of changes are displayed to a user via a feed. Users of the systems and methods can accept, reject, and comment on the changes.
    Type: Grant
    Filed: March 11, 2015
    Date of Patent: October 10, 2017
    Assignee: Google Inc.
    Inventors: Kartik Ayyar, Christopher Jienping Han
  • Patent number: 9645801
    Abstract: The compilation of a transformation chain of a recalculation user interface that displays an electronic canvas that contains one or more displayed result of a transformation chain. The transformation chain includes transforms between a respective data source and data sink. User editing of the recalculation user interface could cause one or more of the transforms to be re-executed, thereby causing recalculation. The compilation involves analyzing the transformation chain of the recalculation user interface for dependencies to create a dependency graph of dependencies between entities. For instance, some dependencies might be between entities so as to indicate that if one entity is evaluated, then the other should be also. The dependency graph is then used to create a lower level of execution steps. The dependency graph is further provided to a runtime for the program, so that the dependency graph may be available during operation of the recalculation user interface.
    Type: Grant
    Filed: July 26, 2016
    Date of Patent: May 9, 2017
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Andrew Douglas Reddish, Olivier Colle, Radu B. Gruian, Nizam Anuar, Jaideep Sarkar, Vijay Mital
  • Patent number: 9613018
    Abstract: Described are methods, systems and computer readable media for GUI display effect formatting.
    Type: Grant
    Filed: May 14, 2016
    Date of Patent: April 4, 2017
    Inventors: Mark Zeldis, Ryan Caudy, David R. Kent, IV, Charles Wright, Radu Teodorescu, Nathaniel J. Dorfman
  • Patent number: 9460207
    Abstract: Technologies pertaining to fact lookup queries are described herein. A relational database is automatically built by extracting attribute identities and attribute values from a one dimensional table, wherein the one dimensional table does not include an entity identity that corresponds to the attribute identity and the attribute value. The entity identity is inferred, and the attribute value is indexed in a relational database by the entity identity and the attribute identity. When a query is issued by a user that includes the entity identity and the attribute identity, the corresponding attribute value in the relational database is returned to the user.
    Type: Grant
    Filed: December 8, 2010
    Date of Patent: October 4, 2016
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Xiaoxin Yin, Wenzhao Tan, Chao Liu
  • Patent number: 9235756
    Abstract: A technique is described for table grid detection and separation during the analysis and recognition of documents containing table contents. The technique includes the steps of table detection, grid separation, and table cell extraction. The technique is characterized by the steps of detecting the grid lines of a table using, for example, inverse cell detection, separating noise and touching text from the grid lines, and extracting the cell contents for OCR recognition.
    Type: Grant
    Filed: December 5, 2013
    Date of Patent: January 12, 2016
    Assignee: The Neat Company, Inc.
    Inventor: Huanfeng Ma
  • Patent number: 9043693
    Abstract: A system may include reception, from a planning application, of a spreadsheet including a plurality of values, presentation of the plurality of values, reception of a first instruction to change a first value of the plurality of values to a second value, presentation, in response to the instruction, of a visual indication in association with the second value, the visual indication indicating that the second value is a fixed value, reception of a second instruction to refresh the spreadsheet, and in response to the second instruction, determination of one or more of the plurality of values of the spreadsheet, each of the determined one or more of the plurality of values presented in association with a visual indication indicating that the value is a fixed value, and transmission of the determined one or more of the plurality of values and a request to refresh the spreadsheet to the planning application.
    Type: Grant
    Filed: December 28, 2011
    Date of Patent: May 26, 2015
    Assignee: SAP SE
    Inventors: Christian Baeck, Peter Tillert, Tahar El Idrissi-Lamghari, Henrik Arndt, Jan Matthes
  • Patent number: 9032284
    Abstract: Green printing is utilized to repurpose a document. An indication is received that a printout of a document from a printer has been requested. The document has content with a format that would result in a first quantity of pages being printed. The content is grouped into one or more regions. Further, one or more transformations are applied to the content for each region such that the printer prints the document with the content in a transformed format that results in a second quantity of pages being printed without falling below a predetermined readability threshold. The second quantity of pages is less than the first quantity of pages. Further, the one or more transformations being applied to the document may result in a second quantity of ink being utilized to print the document such that the second quantity of ink being less than the first quantity of ink.
    Type: Grant
    Filed: August 3, 2010
    Date of Patent: May 12, 2015
    Assignee: Adobe Systems Incorporated
    Inventors: Kapil Arora, Harsh Vardhan Chopra, Naveen Goel, Mayur Hemani, Himanshu Jindal, Neha Rastogi, Hemant Virmani
  • Patent number: 8984392
    Abstract: Example systems, methods, and data structures are directed at synchronizing documents. One example data structure includes receiving a request from a first client to edit a document, and sending short-term check out metadata to the first client to begin an editing session. The data structure includes a plurality of cells and a plurality of data objects defining content of the document. Each data object is associated with one of the cells and has an object identifier that uniquely identifies the data object within the associated cell, and is configured to communicate with other cells and with objects within the associated cell. In addition, each of the cells is defined so that each other cell remains unaffected by changes to data objects of the cell.
    Type: Grant
    Filed: December 8, 2011
    Date of Patent: March 17, 2015
    Assignee: Microsoft Corporation
    Inventors: Simon P. Clarke, Miko Arnab Sakhya Singha Bose, Peter P. Baer, Hani Saliba, Xuelei Sun
  • Patent number: 8972905
    Abstract: The present invention relates to a method and apparatus for explicit filtering in ambiguous text entry. The invention provides embodiments including various explicit text entry methodologies, such as 2-key and long pressing. The invention also provides means for matching words in a database using build around methodology, stem locking methodology, word completion methodology, and n-gram searches.
    Type: Grant
    Filed: June 13, 2014
    Date of Patent: March 3, 2015
    Assignee: Nuance Communications, Inc.
    Inventors: Ethan Robert Bradford, Keith Charles Hullfish, David Kay, Pim Van Meurs, Michael R. Longé
  • Patent number: 8972844
    Abstract: A field attraction module attracts/detracts interaction to/from particular fields of a digital document. The module detects interaction in the digital document corresponding to a plurality of fields of the digital document is detected. The module determines field attraction weights associated with the plurality of fields. The field attraction weights represent a degree to which presentation of the digital document is modified for selectively attracting interaction to at least one of the plurality of fields. The module determines that a first of the plurality of fields is associated with a greatest of the field attraction weights. The module modifies presentation of the digital document to attract interaction to the first field in the digital document in accordance with the greatest of the field attraction weights.
    Type: Grant
    Filed: October 28, 2011
    Date of Patent: March 3, 2015
    Assignee: International Business Machines Corporation
    Inventors: Matthew G. Marum, Samuel Padgett, Steven K. Speicher, Michael J. Tabb
  • Patent number: 8954837
    Abstract: Context sensitive delimiter insertion when adding references is disclosed. In some embodiments, a plurality of indications of selections of a cell or cell range while in a formula editing mode in a host cell into which a formula is being entered is successively received, and in response to receiving each indication of selection of the plurality a reference to the selected cell or cell range is successively inserted into the formula, wherein the references inserted into the formula are delimited by a first delimiter type if in a first context and wherein the references inserted into the formula are delimited by a second delimiter type if in a second context.
    Type: Grant
    Filed: May 16, 2011
    Date of Patent: February 10, 2015
    Assignee: Apple Inc.
    Inventor: Peter William Rapp
  • Patent number: 8954838
    Abstract: Some embodiments provide a system for displaying cells of a table. During operation, the system can receive a sort-and-merge request for sorting the rows of the table using a sort column. Next, the system can sort the rows of the table based at least on cell values in the sort column to obtain a sorted table. The system can then merge a set of consecutive cells in a merge column of the sorted table to obtain a merged cell, wherein the set of consecutive cells are associated with the same cell value. Note that the sort column and the merge column can be the same column, or they can be different columns. Next, the system can display the merged cell and other cells in the sorted-and-merged table. Displaying a cell can involve positioning the cell's value in a visible area of the cell.
    Type: Grant
    Filed: December 4, 2009
    Date of Patent: February 10, 2015
    Assignee: Synopsys, Inc.
    Inventors: Anil P. Balaram, Takashi Toyooka
  • Publication number: 20150007008
    Abstract: A method and system associate conditional formats with selected data points or groups of data points within a summary table. In one embodiment, related groups of data are determined based upon currently highlighted cells in a summary table. A user then selects from the groups and identifies conditional formats to be associated with the specified data points. The conditional formats are associated with currently displayed well as non-displayed data within the summary table. The associated conditions are saved relative to the data points rather than the original cell positions so that the conditions remain associated with the data points following a reorganization of the summary table.
    Type: Application
    Filed: September 8, 2014
    Publication date: January 1, 2015
    Inventors: Eric B. Vigesaa, Allan Folting, Bruce Cordell Jones, Robert C. Collie
  • Patent number: 8924843
    Abstract: A plurality of time series having corresponding sets of data over time are received. Visual indicators for display in a display region are presented for values of at least a first attribute of the plurality of time series in corresponding cell-based lines, where the cell-based lines have cells to display the corresponding visual indicators for the values of the at least first attribute over time. The plurality of time series in the display region are ordered according to an aggregate of at least one attribute of the plurality of time series.
    Type: Grant
    Filed: April 30, 2007
    Date of Patent: December 30, 2014
    Assignee: Hewlett-Packard Development Company, L.P.
    Inventors: Ming C. Hao, Umeshwar Dayal, Rodney L. Watson
  • Patent number: 8922579
    Abstract: A VCI (visual context indicator) color is assigned deterministically and proactively at runtime to user data contexts, and is not stored in the database, spreadsheet, or other context. VCI colors can be high contrast friendly colors. The same color is assigned to a given context each time the application runs unless the context's identifying property has changed. Color assignments are not made by users or by the application's designer, but are done instead by hashing from a context's identifying property into a VCI color palette containing, e.g., eight to sixteen colors. Unlike text-selection coloring, VCI coloring is based on the user data context's identifying property. The color assignment visually indicates context by displaying the context's name in the VCI color, or by displaying a graphical element in the VCI color near the context name. VCI color assignment also shows the occurrence and result of changes in user data context.
    Type: Grant
    Filed: March 5, 2012
    Date of Patent: December 30, 2014
    Assignee: Microsoft Corporation
    Inventors: Zheng Mi, Nigel Christopher Wolters, Hua Wang, Jennifer Lee Beckmann, Joseph Dallas Milan, Steven Merlin Twitchell
  • Publication number: 20140372857
    Abstract: A smart fill feature is provided, which may be utilized to provide suggestions to a user and to prepopulate fill results in a spreadsheet. Characteristics associated with a set of data may be recognized and used to help determine fill results Suggestions may be determined from internal and or/external data sources, and may use contextual information in a data set to determine what a user may be trying to accomplish. External data sources may include one or more Internet data sources or internal corporate databases, providing a large amount of data from which to search for potential fill results. A split column command may be used to split a column into two or more columns. Data may be split between columns or combined by various methods, which may include, by example, by direct manipulation via tokens, or via a slider UI.
    Type: Application
    Filed: June 14, 2013
    Publication date: December 18, 2014
    Inventors: Carlos Augusto Otero, John Campbell, Uhl Albert, Daniel Parish, Aaron Lamar Wilson, Steve Tullis
  • Publication number: 20140372854
    Abstract: A smart selection engine is provided. The smart selection engine may run in the context of a spreadsheet application on any device, service, or general endpoint capable of running the spreadsheet application. The smart selection engine reduces the cognitive load and complexity for performing spreadsheet operations by clearly presenting the user with easy to use and understand options that are big, simple, and lend themselves nicely to natural user interfaces, touch enabled devices, and devices with small displays as well as with graphical user interfaces, larger displays, and traditional input devices. By making contextually based suggestions, the smart selection engine reduces or eliminates the need for the user to be aware of the available operations or how to perform the operations. Further, the smart selection engine improves the consistency and efficiency of working with a spreadsheet.
    Type: Application
    Filed: June 14, 2013
    Publication date: December 18, 2014
    Inventors: Carlos Augusto Otero, John Campbell, Uhl Albert, Pablo Rochat
  • Publication number: 20140372855
    Abstract: Systems and methods are described to manage the exchange of information between multiple networked devices in a shared electronic document environment. In an embodiment, a computer implemented method of exchanging information in a collaborative networked environment is performed. The method may include receiving a first active region from a first client, receiving indicia of a change to a shared electronic document, and determining that the first client requires an update. The determining step may include determining the change will affect the first active region, and determining the relevant-change data to send to the first client. Additionally, the method may include sending the relevant-change data to the first client.
    Type: Application
    Filed: June 14, 2013
    Publication date: December 18, 2014
    Inventors: Micah Myerscough, Tarek Hefny, Nagamani Kusampudi, Tony Valey
  • Publication number: 20140372856
    Abstract: Natural gestures for interacting with spreadsheet documents are provided. A user may interact with a spreadsheet document using a variety of touch-based gestures. Gestures applied to a spreadsheet document may be used for making structural and display changes to the document. For example, gestures may be used on the spreadsheet document for inserting new columns and rows; for revealing hidden columns and rows; for deleting columns and rows; for extending functionalities across columns and rows; for moving objects displayed in a spreadsheet document; and for navigating various parts of a spreadsheet document.
    Type: Application
    Filed: June 14, 2013
    Publication date: December 18, 2014
    Inventors: Sam C. Radakovitz, John Campbell, Carlos Augusto Otero, Allison Jane Rutherford, Uhl Albert
  • Publication number: 20140372858
    Abstract: Seamless grid and canvas integration in a spreadsheet application is provided. One or more data items may be pulled from a grid-structured spreadsheet and may be allowed to “float” on the grid-structure spreadsheet without regard to the underlying grid. The floating object may be pushed or inserted back into the grid of the same or different spreadsheet at any location. A pulled data object also may be dropped onto a grid-less canvas user interface object and may be moved about on the canvas object in a free form manner. References between data and computations in the moved data object are structured and maintained so that the data object may be manipulated and increased/decreased without adversely affecting the underlying grid and such that both data and computational references between the data object and the underlying grid are maintained.
    Type: Application
    Filed: June 15, 2013
    Publication date: December 18, 2014
    Inventors: John Campbell, Sam C. Radakovitz
  • Patent number: 8881043
    Abstract: Provided is an information processing apparatus including a position determination unit for determining whether or not a position of an information input area included in a display area of a first application and a position of an information output area included in a display area of a second application satisfy a predetermined first positional relationship, and a coordination processing unit for inputting, in a case it is determined that the predetermined first positional relationship is satisfied, output information of the second application that is associated with the information output area to the first application as input information associated with the information input area.
    Type: Grant
    Filed: June 19, 2012
    Date of Patent: November 4, 2014
    Assignee: Sony Corporation
    Inventors: Shunichi Kasahara, Yuya Aoki, Mitsuru Nishibe, Takahiro Okayama
  • Publication number: 20140281870
    Abstract: Users may collaborate on a document and be notified of changes (e.g. comments, changes) made to the document using different notification methods. A comment may be added to the document from within the document and/or externally from the document. A comment may also be added to a comment stream (e.g. a thread of related comments). The different notification mechanisms may include mechanisms such as: Short Message Service (SMS), Multimedia Messaging Service (MMS), electronic mail, phone call, Instant Messaging (IM), social network post/message, toast message, live tile, and the like. A user may configure the desired notification methods. A newsfeed may display a feed of collaboration items that reflect comments/changes to the document. The user may select a displayed collaboration item from the newsfeed to access the document. A user may also respond (e.g. comment) to a notification that may be added as a comment in the document.
    Type: Application
    Filed: March 14, 2013
    Publication date: September 18, 2014
    Inventors: Matthew Vogel, Avijit Sinha, Olivier Destrebecq, John Sanders, Steven Novick, Neha Monga, Shaun Bennett, Darron Stepanich, Sunder Raman
  • Patent number: 8799761
    Abstract: A spreadsheet is repurposed to save paper and ink. An indication that a printout of a spreadsheet from a printer has been requested is received. The spreadsheet has content with a format that would result in a first quantity of pages being printed. Further, a printable range for the spreadsheet is determined. In addition, an overlap analysis of the spreadsheet is performed to determine if any of the plurality of shapes in the spreadsheet overlap one another. Each print zone is isolated in the spreadsheet. The print zone includes a group of cells. Each print zone is transformed into a transformed print zone. Further, a green spreadsheet is generated, without falling below a predetermined readability threshold, based on each transformed print zone such that the green spreadsheet has a second quantity of pages that is less than the first quantity of pages.
    Type: Grant
    Filed: August 3, 2010
    Date of Patent: August 5, 2014
    Assignee: Adobe Systems Incorporated
    Inventors: Naveen Goel, Mayur Hemani, Himanshu Jindal
  • Publication number: 20140215300
    Abstract: An FT diagram aid device is provided with an import portion for obtaining a connection relationship of ruled lines and character strings from first data which is data of an FT diagram expressing a tree structure by the ruled lines and the character strings on a sheet of a spreadsheet program, acquiring an event included in the FT diagram and a connection relationship between events from an obtained connection relationship of the ruled lines and the character strings, and generating second data describing the tree structure of the FT diagram in a markup language based on the same and an editing portion for editing the second data to generate third data describing the tree structure of the edited FT diagram in the markup language.
    Type: Application
    Filed: September 6, 2012
    Publication date: July 31, 2014
    Applicant: JATCO Ltd.
    Inventors: Katsunari Yamamoto, Youji Hiraoka, Yoshiyuki Furukawa
  • Patent number: 8793567
    Abstract: Technologies are described herein for generating field sets of a data summary table. Multiple fields in a spreadsheet document are identified. Multiple field scores for each field of the plurality of fields are determined. A field set incorporating two or more of the plurality of fields is generated based on the plurality of field scores. The field set is inserted into the data summary table, thereby transforming the data summary table without the field set to the data summary table with the field set.
    Type: Grant
    Filed: November 16, 2011
    Date of Patent: July 29, 2014
    Assignee: Microsoft Corporation
    Inventors: Amit Velingkar, Weng Keong Peter Anthony Leong, Allan Folting, Carl Brenn Sutter, IV, Diego M. Oppenheimer, Stephen Van de Walker Handy
  • Patent number: 8782508
    Abstract: A method is disclosed for data entry into the content of cells belonging to an output field, said data being expressed as a mathematical expression of the cell contents of at least one input field in a data multidimensional table used by a data management application.
    Type: Grant
    Filed: March 18, 2004
    Date of Patent: July 15, 2014
    Assignee: International Business Machines Corporation
    Inventor: Frederic Bauchot
  • Patent number: 8782509
    Abstract: Embodiments of the present invention provide a table graphics management method and apparatus. The table graphics management method includes: displaying a table on a display apparatus; detecting a control track for the table input by an input device; determining a moving direction of the control track according to the detected control track; and along the moving direction of the control track, transposing original information in the frames of the row that are sequentially arranged along the first dimension into the frames of the column that are sequentially arranged along the second dimension, and transposing original information in the frames of the column that are sequentially arranged along the second dimension into the frames of the row that are sequentially arranged along the first dimension, so as to acquire a transposed table; and displaying a transposed table on the display apparatus.
    Type: Grant
    Filed: July 24, 2013
    Date of Patent: July 15, 2014
    Assignee: Huawei Technologies Co., Ltd.
    Inventor: Wenfang Tang
  • Publication number: 20140157098
    Abstract: By means of this system, the interaction among spreadsheets is completely integrated within the Spreadsheet Management System whereas it does not require the usage of other tools supporting the communication over a network such as web browsers, mailers, and file transfer clients. The interaction is implemented by the Enabling Platform, integrated within the Spreadsheet Management System, and by the Service Platform, located on a computing system that can be reached over the Internet or on a different private network making the Service Platform's intervention not visible to users.
    Type: Application
    Filed: December 2, 2013
    Publication date: June 5, 2014
    Inventor: Massimo Maresca
  • Publication number: 20140149839
    Abstract: A client receives data from a server that includes a dashboard generated at the server by converting each of a spreadsheet file and a dashboard structure file into a text-based, language-independent data interchange format. In addition, the dashboard includes at least one component dependent on at least one prompt. Thereafter, the at least one prompt is asynchronously rendered in a graphical user interface at the client. Data is later received that includes answers to one or more prompts. At least one query is subsequently executed based on the received answers. After results of the executed at least one query is received, the component having a corresponding received answer is rendered in the dashboard. Related apparatus, systems, techniques and articles are also described.
    Type: Application
    Filed: November 29, 2012
    Publication date: May 29, 2014
    Inventors: Jason Bedard, Viren Kumar
  • Patent number: 8736763
    Abstract: According to one embodiment, a content synchronizing method includes: first transmitting when receiving an acquiring request for reference time to determine a timing to synchronize a plurality of pieces of content executed by a plurality of modules with each other from a first module out of the modules, the acquiring request for the reference time to a second module out of the modules; receiving source information indicating an acquisition source of the reference time from the second module; and acquiring reference time information indicating the reference time from the acquisition source indicated by the source information, wherein second transmitting to the first module, together with the reference time information, processing time information indicating processing time from receiving the acquiring request until transmitting the reference time information, the processing time information being used to calculate a time lag between time in the first module and the reference time.
    Type: Grant
    Filed: April 30, 2012
    Date of Patent: May 27, 2014
    Assignee: Kabushiki Kaisha Toshiba
    Inventor: Yoshikata Tobita
  • Patent number: 8726143
    Abstract: A spreadsheet application or other application supporting formulaic cells that automatically provides support for a number of diverse formulaic functions. The automatically provided diverse formulaic functions include a function returning the value of the formula logic if the logic can be evaluated without an error. Another function finds a value in a formulaic cell that is in the same row as a particular value from the first column and the same column as a particular value in the first row. Other functions allow a selection of a set of multiple lookup rows and columns for matching the values used as variables in the function. The spreadsheet application is further configured to automatically supply other functions in addition to those described.
    Type: Grant
    Filed: January 14, 2005
    Date of Patent: May 13, 2014
    Assignee: Microsoft Corporation
    Inventors: Roy Simkhay, Charles D. Ellis, Alexander Babanov, David F. Gainer, Daniel P. Cory, Matthew J. Androski, Andrew J. Becker, Jeremy R. Pankratz, Monica McAmis, Simon Loftus Peyton Jones
  • Patent number: 8719689
    Abstract: In a method for the implementation of a medical examination via the user interface of at least one imaging device, parameter values in a group of measurement parameters are determined, and are entered via an input device of the user interface. Spatially resolved image information are generated by the at least one imaging device depending on the group of measurement parameters, and the image information is stored on a storage medium. The image information are presented as a data symbol on a screen of the user interface. In order to present the parameters and dependencies to enable a more efficient work process, each measurement parameter of the group of measurement parameters is respectively presented on the screen in a measurement parameter cell of a matrix with multiple rows and multiple columns. The measurement parameters can be contained at least in part in multiple measurement parameter cells.
    Type: Grant
    Filed: April 8, 2009
    Date of Patent: May 6, 2014
    Assignee: Siemens Aktiengesellschaft
    Inventors: Karlheinz Glaser-Seidnitzer, Johannes Kling, Martin Requardt
  • Patent number: 8713423
    Abstract: A request for differential data relative to a first data element within a group of data elements is received via a user input device. A first differential data value for each of the group of data elements relative to the first data element is calculated. The first differential data value for each of the group of data elements relative to the first data element are displayed on a display in response to the received request. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract.
    Type: Grant
    Filed: March 28, 2009
    Date of Patent: April 29, 2014
    Assignee: International Business Machines Corporation
    Inventor: Frank Lawrence Jania
  • Patent number: 8707156
    Abstract: A render engine for a spreadsheet application is described. The render engine facilitates the rendering of cell regions containing data that are maintained by both a spreadsheet application (user-defined cell region) and/or a third-party application (application-defined cell region). In particular, an embodiment of the render engine facilitates the repositioning of one or more existing cell regions within a spreadsheet interface, when the insertion of a new cell region is determined to cause a layout conflict with one or more existing cell regions. Repositioning of the existing cell regions is achieved without overwriting any cell information, and without breaking any formulas contained within an affected cell.
    Type: Grant
    Filed: April 2, 2009
    Date of Patent: April 22, 2014
    Assignee: Business Objects, S.A.
    Inventors: Wei Xue, Shuai Zhao, Leo Chi-Lok Yu
  • Publication number: 20140108899
    Abstract: A data filtering system includes a display device and a data filtering engine coupled to the display device. The data filtering engine is configured to display a cell set containing data of a common data type on a display device with at least one cell containing a cell entry. The data filtering engine is further configured to display a filter icon within at least one cell of the cell set and apply a filter to the cell set in response to selection of the filter icon by a user.
    Type: Application
    Filed: October 15, 2012
    Publication date: April 17, 2014
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Ryan L Brissette, Sameer V. Jorapur, Somil Kulkarni, Michael L Pauser
  • Patent number: 8656348
    Abstract: 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 language is presented. The system includes an Object Model with Data Structures representing entities involved in spreadsheets. The system includes a Parser and Code Generator that extracts data from a body of spreadsheet data, instantiates instances of Data Structures of the Object Model to represent the spreadsheet data, parses the data and formulas contained in the cells of the spreadsheets, iterates through the instantiated instances of the Data Structures, and generates source code that performs the calculations and data transformations embodied in the spreadsheet data. The system includes a Calculation Engine with software base classes that implement the common structural and data access features of spreadsheet data, and further implement the operations of common spreadsheet functions and operators.
    Type: Grant
    Filed: May 4, 2012
    Date of Patent: February 18, 2014
    Assignee: Knowledge Dynamics, Inc.
    Inventors: Michael R. Smialek, Michael H. Rubin
  • Patent number: 8656271
    Abstract: A method for use with a spreadsheet includes storing a cell object, where the cell object includes a location in the spreadsheet of a cell to which the cell object relates and a process associated with the cell, and performing the process on a complex object to produce a result, where the complex object includes a construct comprised of data and code. A display is generated for the cell that is based on the result.
    Type: Grant
    Filed: July 31, 2006
    Date of Patent: February 18, 2014
    Assignee: SAP AG
    Inventors: Julien Jean-Pierre Vayssiere, Regis Francois Bernard Saint-Paul, Boualem Benatallah
  • Patent number: 8656272
    Abstract: Various technologies and techniques are disclosed for persisting instance-level report customizations. Input is received from a user to run an original report. An original query associated with the original report is executed against a data store. The original report is displayed to the user. At least one instance-level customization is received from the user to customize an instance of the original report. The instance-level customizations that the user makes to the customized report are tracked in a manner that allows a history of changes from the original report to the customized report to be determined. The customized report is generated in subsequent executions of the report. The instance-level changes the user made to the report can be audited to allow users to see the changes made to the original report.
    Type: Grant
    Filed: April 28, 2006
    Date of Patent: February 18, 2014
    Assignee: Microsoft Corporation
    Inventor: Robert A. Meyers
  • Patent number: 8614833
    Abstract: A printer driver for holding the setting of various parameters for a printer and effecting conversion of print data from an application, the printer driver includes: a specific character string detecting unit which detects from the print data a specific character string designated by a user; a code converting unit which converts the specific character string detected by the specific character string detecting unit to a code; and a code imparting unit which imparts the code converted by the code converting unit to the print data.
    Type: Grant
    Filed: February 13, 2006
    Date of Patent: December 24, 2013
    Assignee: Fuji Xerox Co., Ltd.
    Inventors: Takashi Oda, Koei Hoshino, Hideyuki Kobayashi, Hiroo Yoshida, Takashi Tomizuka
  • Publication number: 20130339833
    Abstract: Methods, program products, and systems for layout synchronization are described. A first device can share with a second device a layout designed according to display properties of the first device, even if display properties of the second device differ from those of the first device. The layout can be synchronized between the devices, where each device can adapt the layout in a manner specific to the display properties of the device. Two-dimensional views of same data can have a consistent appearance on multiple devices each having distinct display properties.
    Type: Application
    Filed: June 15, 2012
    Publication date: December 19, 2013
    Inventors: Ben Chen, Ryan Christopher Griggs, Yifeng Gui, Jonathan Sigler, Kevin Iversen Smith
  • Patent number: 8601360
    Abstract: Methods and computerized apparatus for shared business modeling involving multiple spreadsheet-based business models in a network of computers, report generation involving consolidation from at least two different spreadsheet-based business models as well as report generation involving multiple different spreadsheet-based business models are described.
    Type: Grant
    Filed: October 19, 2012
    Date of Patent: December 3, 2013
    Assignee: Morgan Stanley
    Inventors: Milliken Fernandes, Robert I. Lee, Jr., Dragan Masnikosa, Supriya Samanta
  • Publication number: 20130311865
    Abstract: Embodiments of the present invention provide a table graphics management method and apparatus. The table graphics management method includes: displaying a table on a display apparatus; detecting a control track for the table input by an input device; determining a moving direction of the control track according to the detected control track; and along the moving direction of the control track, transposing original information in the frames of the row that are sequentially arranged along the first dimension into the frames of the column that are sequentially arranged along the second dimension, and transposing original information in the frames of the column that are sequentially arranged along the second dimension into the frames of the row that are sequentially arranged along the first dimension, so as to acquire a transposed table; and displaying a transposed table on the display apparatus.
    Type: Application
    Filed: July 24, 2013
    Publication date: November 21, 2013
    Applicant: Huawei Technologies Co., Ltd.
    Inventor: Wenfang TANG
  • Publication number: 20130298002
    Abstract: Methods for structuring electronic documents having an ordered set of cells (e.g., spreadsheets or web documents) are provided. In general, the methods provide for multidimensionality by allowing cells to be split by splitting operators, thus allowing cells to contain additional groups of cells, and recursively so. Disclosed are tools and operations for building and modifying various multi-dimensional structures and for interacting with them. Splitting operators provide a two-dimensional equivalent of lexical scopes and iterators in programming languages and allow a direct mapping to external data structures. With these features, the disclosed methods are able to combine the flexibility and unstructured nature of traditional spreadsheet with the structuring capabilities of online analytic processing (OLAP)-based tools.
    Type: Application
    Filed: May 7, 2012
    Publication date: November 7, 2013
    Inventor: Patrick Viry
  • Publication number: 20130262975
    Abstract: A distributed spreadsheet application executes at a server and a client in a network. The networked spreadsheet application can generally be used without requiring a user to install any specific spreadsheet software prior to using the application. In one implementation, the spreadsheet application may include a client engine that executes within browser programs of a plurality of client computing devices and server logic. The server logic may be configured to distribute the client engines to the plurality of client computing devices of the spreadsheet application when requested through the browser programs of each of the plurality of client computing devices. The server logic synchronizes a single spreadsheet document that is simultaneously open at the plurality of client computing devices.
    Type: Application
    Filed: May 20, 2013
    Publication date: October 3, 2013
    Applicant: GOOGLE INC.
    Inventors: Jonathan ROCHELLE, Micah Lemonik, Farzad Khosrowshahi, John Stephen Danaher
  • Patent number: 8533583
    Abstract: Disclosed is an application software generation device to generate an application software for a data collection device having a reading unit to read discrimination information to carry out collection of data based on the discrimination information including a table data generation unit to generate table data for defining arbitrary items, an application software generation unit to generate an application software which is executed by the data collection device in order to collect the data based on the item which is defined in the table data and a transfer unit to transfer the generated application software to the data collection device.
    Type: Grant
    Filed: January 22, 2010
    Date of Patent: September 10, 2013
    Assignee: Casio Computer Co., Ltd.
    Inventors: Kouji Miyahara, Koji Nishitani, Hideki Takamura, Noriyoshi Katsumura
  • Patent number: 8516389
    Abstract: An application is executed which provides a grid display and which includes: a spreadsheet generator for generating a screen comprising a group of display elements; a scroll controller for accepting a scroll operation of a screen displayed on a display device and for controlling the scrolling of the screen. If a cell is excluded from and a cell is newly included in a visible region displayed on the display device as a result of a scrolling operation, the scroll controller causes the cell included in the visible region to be displayed on the display device by modifying a content of an attribute, including location information, of a display element used to display the cell excluded from the visible region to a content for displaying the cell included in the visible region.
    Type: Grant
    Filed: February 10, 2009
    Date of Patent: August 20, 2013
    Assignee: International Business Machines Corporation
    Inventors: Shunsuke Fujimoto, Ken Kumagai, Kinichi Mitsui, Yuhki Sakuma
  • Patent number: 8484549
    Abstract: In an embodiment, a computer-implemented method facilitates optimization analysis and sensitivity analysis of a data model. The method comprises a computer: receiving first data identifying a value function, a plurality of parameters for the value function, and one or more specific parameter values for one or more of the parameters; storing a data model based on the value function and the specific parameter values; determining which parameters of the data model are capable of taking variable values; receiving second data identifying one or more selected parameters; receiving third data specifying a value selection approach for each of the selected parameters; determining a plurality of result values by substituting, based on the value selection approach, a plurality of input values for each of the selected parameters and evaluating the value function using the selected parameters and the substituted values; generating and causing displaying a table of the result values.
    Type: Grant
    Filed: June 5, 2009
    Date of Patent: July 9, 2013
    Assignee: Palantir Technologies, Inc.
    Inventors: Brandon Burr, Derek Cicerone, Kevin Simler
  • Publication number: 20130174005
    Abstract: A system may include reception, from a planning application, of a spreadsheet including a plurality of values, presentation of the plurality of values, reception of a first instruction to change a first value of the plurality of values to a second value, presentation, in response to the instruction, of a visual indication in association with the second value, the visual indication indicating that the second value is a fixed value, reception of a second instruction to refresh the spreadsheet, and in response to the second instruction, determination of one or more of the plurality of values of the spreadsheet, each of the determined one or more of the plurality of values presented in association with a visual indication indicating that the value is a fixed value, and transmission of the determined one or more of the plurality of values and a request to refresh the spreadsheet to the planning application.
    Type: Application
    Filed: December 28, 2011
    Publication date: July 4, 2013
    Inventors: Christian Baeck, Peter Tillert, Tahar El Idrissi-Lamghari, Henrik Arndt, Jan Matthes