Spreadsheet Patents (Class 715/212)
  • Patent number: 10282406
    Abstract: The present invention relates to a system for modifying a table comprising generating means for generating a table, wherein the table contains one or more columns and one or more lines containing data, wherein the columns and the lines are related to one or more first categories, respectively, and wherein at least one of said first categories is divided into one or more sub-categories, wherein the system further comprises changing means for changing the distance between data related to two neighboring first categories and/or for changing the distance between data related to two neighboring sub-categories and/or for changing the line height and/or the column width, wherein the changing means are adapted to increase and/or decrease said distance and/or line height and/or the column width in order to increase legibility of the table.
    Type: Grant
    Filed: October 31, 2013
    Date of Patent: May 7, 2019
    Inventor: Nicolas Bissantz
  • Patent number: 10275517
    Abstract: Detecting overnegation in text is provided. A plurality of word lists are compiled. An input text is received. One or more combined weightings are determined, wherein each combined weighting is based, at least in part, on a portion of the input text and the plurality of word lists. A total overnegation score of the input text is generated based, at least in part, on a statistical aggregation of the one or more combined weightings. In response to determining that the total overnegation score exceeds a pre-determined threshold, it is determined that the input text contains a logical error. In response to the total overnegation score exceeding a pre-determined level, one or more actions are executed.
    Type: Grant
    Filed: May 31, 2016
    Date of Patent: April 30, 2019
    Assignee: International Business Machines Corporation
    Inventors: Agnia Barsukova, David M. Curran, Amelia C. Kelly
  • Patent number: 10229154
    Abstract: A method, system, and computer program product for subject-matter analysis of tabular data are provided in the illustrative embodiments. A first document including the tabular data is received. A library of functional signatures for a first subject-matter domain is selected. A determination is made whether a threshold number of functional signatures from the selected library are applicable to the tabular data, wherein a functional signature is applicable to the tabular data when values in the tabular data correspond to an operation and a table structure specified in the functional signature. Responsive to the threshold number of functional signatures from the selected library being applicable to the tabular data, a processor and a memory process the first document according to a process for the first subject matter domain selected from a plurality of processes for respective subject matter domains.
    Type: Grant
    Filed: November 28, 2016
    Date of Patent: March 12, 2019
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Donna K. Byron, Scott N. Gerard, Alexander Pikovsky, Matthew B. Sanchez
  • Patent number: 10216372
    Abstract: A method and apparatus for retrieving selected information in a graphical model environment originates with the provision of the graphical model environment. The selected information is selected by, or provided to, a block diagram simulation application operating the graphical model environment. The selected information can be in the form of data or a reference to data. The selected information is automatically incorporated into the graphical model environment.
    Type: Grant
    Filed: May 7, 2013
    Date of Patent: February 26, 2019
    Assignee: The MathWorks, Inc.
    Inventors: Mazen A. Kachmar, Witold Robert Jachimczyk, Donald Paul Orofino, II
  • Patent number: 10210152
    Abstract: A display structure that includes data items mapped based on relationships among the data items is visually presented on a user interface. The displayed data includes blocks of data received over a block data interface. The display structure may include a first portion indicative of availability of multiple 2-dimensional views of the data items and a second portion for the user to select one of the multiple 2-dimensional views to become an active view that is viewable by the user.
    Type: Grant
    Filed: February 20, 2014
    Date of Patent: February 19, 2019
    Assignee: Quick Eye Technologies Inc.
    Inventor: Andrei Paraschivescu
  • Patent number: 10198465
    Abstract: Described are methods, systems and computer readable media for providing a current row position query language construct and array processing query language constructs and associated processing.
    Type: Grant
    Filed: May 14, 2016
    Date of Patent: February 5, 2019
    Assignee: Deephaven Data Labs LLC
    Inventors: David R. Kent, IV, Ryan Caudy, Charles Wright, Mark Zeldis, Radu Teodorescu
  • Patent number: 10191897
    Abstract: The system includes an input interface and a processor. The input interface is to receive a spreadsheet and an indication of a spreadsheet cell of interest. The processor is to determine a first set of spreadsheet cells that the spreadsheet cell of interest depends on, determine a second set of spreadsheet cells that depend on the spreadsheet cell of interest, provide a spreadsheet cell data flow view for the spreadsheet cell of interest based at least in part on the first set of spreadsheet cells and the second set of spreadsheet cells, and in the event an indication of a new spreadsheet cell of interest is received, provide a spreadsheet cell data flow view for the new spreadsheet cell of interest.
    Type: Grant
    Filed: April 19, 2016
    Date of Patent: January 29, 2019
    Assignee: Workday, Inc.
    Inventor: Terry M. Olkin
  • Patent number: 10185478
    Abstract: Various embodiments of system and methods of creating a filter for a list of objects are described herein. The method includes receiving a selection of a set of objects from the list of objects composed of one or more fields having field values, and comparing the field value in each field of an object with the field values in each of the corresponding fields of the other objects in the set of objects. Based on the comparison, identifying that the field values are the same across the one or more fields of the set of objects. The method further includes generating a list of filter criteria based on the identified field values. The filter may be created using the list of filter criteria.
    Type: Grant
    Filed: September 24, 2014
    Date of Patent: January 22, 2019
    Assignee: SAP SE
    Inventor: Martin Hoffmann
  • Patent number: 10180934
    Abstract: Systems and methods are provided for automatically translating one or more electronic spreadsheets into scripts. One or more electronic spreadsheets containing data arrays and formula arrays may be accessed. The electronic spreadsheet(s) may implement various logic using the data arrays and the formula arrays. The range(s) of the formula arrays may be determined. The range(s) of the data arrays may be determined based on the range(s) of the formula arrays. Conversion ranges may be determined based on the range(s) of formula arrays and the range(s) of data arrays. One or more dependencies between the conversion ranges may be determined and used to generate source code modeling the logic implemented by the electronic spreadsheet(s).
    Type: Grant
    Filed: July 24, 2017
    Date of Patent: January 15, 2019
    Assignee: Palantir Technologies Inc.
    Inventors: Eliot Ball, Dustin Janatpour, Nicholas White
  • Patent number: 10169317
    Abstract: Rendering common cell formatting for adjacent cells is disclosed. In some embodiments, when rendering cells, a set of adjacent cells that have at least one type of cell formatting in common is identified, and the at least one type of cell formatting is rendered as a single entity rather than individually for each cell in the set to prevent visual artifacts between adjacent cells from arising.
    Type: Grant
    Filed: April 23, 2015
    Date of Patent: January 1, 2019
    Assignee: Apple Inc.
    Inventor: Tsurishaddai Williamson
  • Patent number: 10165095
    Abstract: An electronic device in an industrial control system may be connected as a network device, such as via EtherNet/IP. The device may be configured to provide an “unconnected” message notification (or “active report”) when the device detects an enumerated condition, such as an error or deviation. An unconnected message may be a message sent between two or more applications (which may be of the same or different devices) without pre-established communication channel bindings. An unconnected message may include routing path information for routing the message to the host computer, application path information for associating the applications, and data payload information related to at least one of a state of the electronic device and the enumerated condition.
    Type: Grant
    Filed: June 22, 2015
    Date of Patent: December 25, 2018
    Assignee: Rockwell Automation Technologies, Inc.
    Inventors: Dayin Xu, David Brandt, Yi Yu, Clifford J. Whitehead, Jr., Guolin Zhang
  • Patent number: 10152460
    Abstract: Methods, systems, and apparatus, including computer programs encoded on computer storage media, for adaptive column selection. One of the methods includes obtaining a size of a display area. The method includes obtaining column descriptors, each column descriptor identifying a column and a column width. The method includes determining a set of columns to present, including comparing the column width of a column to an available size remaining, and including the column in the set in response to determining that the column size is less than the available size. The method includes calculating an aggregate width of all the columns in the set. The method includes allocating a portion of the size to each column in the set of columns based on a ratio of width of the respective column and the aggregate width. The method also includes presenting the columns in the set of columns on the display area.
    Type: Grant
    Filed: June 29, 2016
    Date of Patent: December 11, 2018
    Assignee: Vinyl Development LLC
    Inventor: Thomas R. Kennedy, Jr.
  • Patent number: 10146409
    Abstract: User interface (UI) manipulations may be performed by eliminating noticeable process boundaries associated with or generated by different applications. The techniques herein describe dynamically splitting manipulations across multiple pieces of content without regard to various types and/or states of the user interface manipulations and/or without regard to whether the multiple pieces of content are associated with different individual processes. In at least one example, the techniques described herein enable quick, responsive, and seamless UI manipulations with complex configurations of content on a UI and/or with multiple pieces of content associated with more than one application. Additionally, the techniques described herein further enable content on a UI to “stick” to the user input manipulation or move with the user input manipulation such that the content appears to stay directly in contact with the user input manipulation.
    Type: Grant
    Filed: August 29, 2014
    Date of Patent: December 4, 2018
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Nathan Pollock, Lindsay Kubasik, Peter Benjamin Freiling, Nicolas Brun, Krishnan Menon
  • Patent number: 10140352
    Abstract: Systems, methods, and computer-readable mediums are presented that may provide for an interface to a relational database. A request may be received for data stored in a relationship database, wherein the request is received from a spreadsheet application. In response to the request for data stored in the relational database, a plurality of tables in the relational database may be accessed to retrieve the data indicated in the request. The retrieved data may be translated from the plurality of tables of the relational database into a format for output to the spreadsheet application. The translated data may be output to the spreadsheet application.
    Type: Grant
    Filed: July 17, 2014
    Date of Patent: November 27, 2018
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Sreeram Hariharan, Swathi Uppala, Mohammed Hussain Shirkol, Usha Arora, Ashish Pathak, Kashif Suleman, Ramchand Raman
  • Patent number: 10127021
    Abstract: The programming notebook system, methods, and user interfaces described herein provide software developers with enhanced tools by which a programming notebook workflow and session history associated with code cells in a programming notebook may be tracked and maintained. As a developer progresses through a development workflow, the developer can select an option to save a program code card representing some or all of the program code cell inputs. A card editor user interface may present an aggregated listing of all program code the developer has provided across multiple code cells during the current session which the developer can edit, refine, and/or comment. The card editor may also allow the developer to add associated user interface code to display a UI component associated with the program code card, and allow the developer to add a description and tags for the card so that the card can be searched for and reused.
    Type: Grant
    Filed: December 28, 2016
    Date of Patent: November 13, 2018
    Assignee: PALANTIR TECHNOLOGIES INC.
    Inventors: Mark Elliot, Punyashloka Biswal, Ankit Shankar, Omar Ali, John Chakerian, Ben Duffield, Adam Borochoff
  • Patent number: 10127330
    Abstract: A computer-implemented method includes receiving, from a first network application, a first unbounded list of objects of a first type and a second unbounded list of objects of a second type, wherein the second type is distinct from the first type, and producing a third unbounded list of objects of a third type, wherein the third type is distinct from both the first type and the second type. The computer-implemented method further includes providing the third unbounded list to a second network application. A corresponding computer program product and computer system are also disclosed.
    Type: Grant
    Filed: October 9, 2017
    Date of Patent: November 13, 2018
    Assignee: International Business Machines Corporation
    Inventors: Robert J. Connolly, Michael J. Hudson
  • Patent number: 10108681
    Abstract: This disclosure describes systems, methods, and apparatus for expanding a row or column in an existing report, sourced from a relational database, where a column or row, respectively, of an opposite axis has already been expanded. Such a need often arises in reports sourced from a SQL database, and overcomes the storage-draining need to pre-compute all possible arrangements of data from the database prior to displaying the report. In some embodiments, a client can make a request for a multi-axis expansion, and a server can create filters for use in sub queries, one for each level of expansion in an axis of the report opposite to the axis where expansion is requested, the sub queries can be executed, results sets can be combined/formatted to form a new report, and the new report can be returned to the client for stitching into the existing report.
    Type: Grant
    Filed: October 23, 2017
    Date of Patent: October 23, 2018
    Assignee: insightsoftware.com International Unlimited
    Inventors: Paul Duffy, Amir Kashani
  • Patent number: 10102241
    Abstract: The techniques described herein use statistical reasoning to determine whether a spreadsheet (e.g., cells) includes potential errors. The techniques determine a partition within a spreadsheet where the partition includes cells that share characteristics (e.g., same row or column, same type of content, same formatting, etc.). Once determined, the partition is evaluated based on defined properties. A property is applied to generate property values so that an anomaly can be identified. An anomaly can occur when a cell in the partition has a property value that is inconsistent with other property values of other cells in the same partition (e.g., an intra-partition anomaly). An anomaly can also occur when a cell in the partition has a property value that is inconsistent with property values of cells in a different partition (e.g., an inter-partition anomaly). The techniques analyze the anomalies to determine a priority value indicative of a likelihood of a potential error.
    Type: Grant
    Filed: May 20, 2016
    Date of Patent: October 16, 2018
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Benjamin G. Zorn, Emery Berger
  • Patent number: 10096028
    Abstract: An information processor includes a defining unit that defines a set of metadata items, and a set of data values of metadata corresponding to the set of metadata items, the set of metadata items and the set of data values being associated with each of multiple specifying areas displayed on a screen, and an associating unit that associates two or more sets of data values with actual data, the two or more sets of data values being each defined for each of two or more specifying areas specified from among the multiple specifying areas.
    Type: Grant
    Filed: February 16, 2016
    Date of Patent: October 9, 2018
    Assignee: FUJI XEROX CO., LTD.
    Inventor: Yosuke Kogure
  • Patent number: 10089689
    Abstract: Lists of tradeable objects may be generated and displayed to enable a user to define a trading strategy having multiple legs. The lists of tradeable objects may be used to define and display different combinations of the tradeable objects that are included in each of the lists. Each combination of tradeable objects may define the different legs of a spread that may be tradeable on one or more exchanges. A combination of tradeable objects may be selected to display contract information associated with the different legs of the spread. The contract information for each leg may be used to define and display spread information for the legs of the trading strategy. The spread information may allow the user to view information related to the spreads for different combinations of tradeable objects in a display.
    Type: Grant
    Filed: October 24, 2017
    Date of Patent: October 2, 2018
    Assignee: Trading Technologies International, Inc.
    Inventor: Charles W. Cunnick
  • Patent number: 10083165
    Abstract: Disclosed herein is a method of controlling data display device. The method includes: loading a monitoring view to initialize it; determining whether to display a tabular view; setting a tabular module if it is determined that the tabular view is to be displayed; displaying the tabular view according to set conditions; and checking whether to perform a view update mode during the displaying the tabular view.
    Type: Grant
    Filed: November 30, 2016
    Date of Patent: September 25, 2018
    Assignee: LSIS CO., LTD.
    Inventors: Yeo-Chang Yoon, Myung-Hwan Lee, Seok-Chan Lee, Seung-Ju Lee
  • Patent number: 10073824
    Abstract: A method for creating a spreadsheet template to facilitate creation of a spreadsheet is disclosed. The method comprises marking a cell in the range of cells as being a potential record cell; and creating a save map to define attributes to be assembled into a record for an actual record cell.
    Type: Grant
    Filed: November 6, 2013
    Date of Patent: September 11, 2018
    Assignee: APTTEX CORPORATION
    Inventor: Kirk Krappe
  • Patent number: 10067928
    Abstract: A method for creating a spreadsheet template to facilitate creation of a spreadsheet is disclosed. The method comprises determining at least one dimension for the spreadsheet; creating logic to dynamically determine a dimension range for each dimension when the spreadsheet template is run, and saving said logic in a memory device; and creating logic to map each cell within each dimension range to a remote application object.
    Type: Grant
    Filed: November 6, 2013
    Date of Patent: September 4, 2018
    Assignee: APTTEX CORPORATION.
    Inventor: Kirk Krappe
  • Patent number: 10055395
    Abstract: An electronic device is configured to perform a method for editing an object. The method includes determining one or more edit references with respect to one or more objects displayed on a display unit, detecting a motion input, and editing the one or more objects based on at least one of the one or more edit references and a characteristic of the motion input.
    Type: Grant
    Filed: July 16, 2014
    Date of Patent: August 21, 2018
    Assignee: SAMSUNG ELECTRONICS CO., LTD.
    Inventors: Jung-Woo Lee, Keum-Ju Jang, Hyung-Suk Hwang, Sook-Kyung Choi
  • Patent number: 10025481
    Abstract: Embodiments provide electronic spreadsheet viewing and interaction features and functionalities, but the embodiments are not so limited. In an embodiment, a computer-implemented method can be configured to provide a cell view launch indicator or interface that alerts a user that a selected cell includes additional content not being currently displayed. The cell view launch indicator can be activated and use a cell view mode to launch a separately controllable cell view window or portion. Other embodiments are included.
    Type: Grant
    Filed: October 5, 2015
    Date of Patent: July 17, 2018
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Rajat Bhargav, Pankaj Jain, Mitushi Jain, Abhijit Kumar Bairagi
  • Patent number: 10025769
    Abstract: Systems and methods for generating a two-dimensional graphical grid representation of the treatment of a document are disclosed. A method includes receiving a request to generate the two-dimensional graphical grid representation of the treatment of the document with respect to at least one variable. In response to the received request, the method further includes retrieving, by a computer, treatment information associated with the document with respect to the at least one variable from a database. The method further includes generating a message containing the retrieved treatment information of the document with respect to the at least one variable, transmitting the generated message, and providing for display the two-dimensional graphical grid representation of the treatment of the document with respect to the at least one variable based on the transmitted message.
    Type: Grant
    Filed: December 8, 2015
    Date of Patent: July 17, 2018
    Assignee: LexisNexis, A Division of Reed Elsevier Inc.
    Inventors: Richard D. Miller, Thomas J. Goedde, Jacob Aaron Myers, Gaurav Mehra, Lisa Peterson
  • Patent number: 10013413
    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: Grant
    Filed: June 2, 2016
    Date of Patent: July 3, 2018
    Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
    Inventors: Carlos Augusto Otero, John Campbell, Uhl Albert, Daniel Parish, Aaron Lamar Wilson, Steve Tullis
  • Patent number: 10002120
    Abstract: The present disclosure includes techniques pertaining to computer implemented systems and methods for data usage monitoring. In one embodiment, user manipulations of spreadsheets are translated into backend actions and executed against spreadsheet data. The actions of users on different spreadsheets automatically generate data records to track each action. The data records are stored in a data structure and portions of the records may be accessed to generate usage information.
    Type: Grant
    Filed: April 30, 2015
    Date of Patent: June 19, 2018
    Assignee: SAP SE
    Inventors: Khuan Tan, Chien Yueh, Ying Liu, Min He
  • Patent number: 9983768
    Abstract: A computer-implemented method, system, and program product for selecting tabulated data are provided, which include: displaying a tabulated data structure on a computer display, the tabulated data structure including a plurality of data fields; receiving a user input indicative of a selection of one of the data fields; searching the tabulated data structure to generate at least one set of data fields, the data fields in each set sharing a relationship with the user-selected data field; and highlighting the at least one set of data fields in the displayed tabulated data structure, in which each of the highlighted sets of data fields is user-selectable.
    Type: Grant
    Filed: October 20, 2016
    Date of Patent: May 29, 2018
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Paul R. Bastide, Sean Callanan, Mark Gargan, Fred Raguillat
  • Patent number: 9971812
    Abstract: Systems and methods provide for data management and governance to enforce proper usage of data. Data is tagged with data governance metadata dictating usage of the data. Standard types of data governance metadata are set forth with each type having predefined options such that applications can share data and understand the associated data governance metadata. For a given data, one or more options are selected for each type of data governance metadata and tagged to the data to control usage of the data.
    Type: Grant
    Filed: April 26, 2016
    Date of Patent: May 15, 2018
    Assignee: Adobe Systems Incorporated
    Inventors: Christine Elaine Drost-Hansen, Christopher Reid Error, Philip John Grieshaber
  • Patent number: 9965721
    Abstract: Disclosed is a computer-implemented method of generating a plurality of selectable design experiments in a design of experiments (DOE) process for analyzing at least one data set from a process to determine a relationship of a plurality of process factors of interest to a process output of interest. The method entails receiving as user input into a computing apparatus, a base number of trials and a number of center point trials. From the computing apparatus, a graphical user interface is generated on a display connected with the computing apparatus. This includes presenting a display containing a plurality of experiment each defined, at least partially, by a combination of number of replicates (replicates count) and effect size. The display further includes a predicted power value for each combination of replicates count and effect size.
    Type: Grant
    Filed: September 16, 2014
    Date of Patent: May 8, 2018
    Assignee: Moresteam Development, LLC
    Inventors: Lars Maaseidvaag, Smita Kulkarni Skrivanek, Alan Gao
  • Patent number: 9959103
    Abstract: Computer programming is aided by way of automatic code generation, and more specifically generation of deployment code automatically. An application can be analyzed and deployment code, including installation, maintenance (e.g., update/upgrade), and removal (e.g., un-install) code, can be generated as a function of the analysis as well as a particular execution environment.
    Type: Grant
    Filed: November 19, 2010
    Date of Patent: May 1, 2018
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Danny Van Velzen, Henricus Johannes Maria Meijer
  • Patent number: 9940312
    Abstract: Systems and methods for transferring a web content display from one container to another container are disclosed. A request to transfer a first web content display hosted in a first container having a first document object model (DOM) tree to a second container having a second DOM tree is received. The first web content display has a state comprising a plurality of state components. A second web content display hosted in the second container is created. If a first state component is dependent on a property of the first DOM tree associated with a host of the first web content display: the first state component is adjusted in the second web content display according to a corresponding property of the second DOM tree.
    Type: Grant
    Filed: April 17, 2015
    Date of Patent: April 10, 2018
    Assignee: GOOGLE LLC
    Inventor: Fady Samuel
  • Patent number: 9898523
    Abstract: One or more techniques and/or systems are provided for parsing tabular data of a document. That is, a document may comprise arbitrarily formatted content (e.g., an equipment inspection report generated by an engineer). Respective rows of the document may be clustered into one or more row clusters based upon row proximity and/or numeric content (e.g., rows having similar numeric content may comprise logically related information). One or more vertical clusters may be generated within respective row clusters based upon vertical overlap. In this way, row clusters and/or vertical clusters may be searched for one or more values that may be assigned to a search term. For example, a row cluster may comprise a search term “Average temp”. One or more vertical clusters within the row cluster may be searched for a word that matches a pattern criteria (e.g., a two digit number), which may be assigned to the search term.
    Type: Grant
    Filed: April 22, 2013
    Date of Patent: February 20, 2018
    Assignee: ABB Research Ltd.
    Inventor: David Neil Cox
  • Patent number: 9830657
    Abstract: Lists of tradeable objects may be generated and displayed to enable a user to define a trading strategy having multiple legs. The lists of tradeable objects may be used to define and display different combinations of the tradeable objects that are included in each of the lists. Each combination of tradeable objects may define the different legs of a spread that may be tradeable on one or more exchanges. A combination of tradeable objects may be selected to display contract information associated with the different legs of the spread. The contract information for each leg may be used to define and display spread information for the legs of the trading strategy. The spread information may allow the user to view information related to the spreads for different combinations of tradeable objects in a display.
    Type: Grant
    Filed: April 2, 2015
    Date of Patent: November 28, 2017
    Assignee: Trading Technologies International, Inc.
    Inventor: Charles W. Cunnick
  • Patent number: 9824081
    Abstract: The present disclosure includes techniques pertaining to computer implemented systems and methods for automatic generation of data transformations. In one embodiment, a user manipulates a spreadsheet of data in a user interface. On a backend, the user's manipulations trigger actions that cause the data to be modified. Actions may automatically cause data flow objects and data flow graphs to be produced. The transformations defined by the data flow graphs are automatically executed by a software engine and the results are displayed to the user. The user may access and manipulate data from a variety of data sources while the underlying complexities of the transformation process are performed in an automated manner.
    Type: Grant
    Filed: April 30, 2015
    Date of Patent: November 21, 2017
    Assignee: SAP SE
    Inventors: Claudia Lehmann, Michael Alexander, Phil Tinari, Min He, Vei Ming Seah, Barbara Stortz, Daniel Culp
  • Patent number: 9792009
    Abstract: A method for focus management in a software application, wherein at least a subset of Node objects of said software application forms a hierarchy of Node objects and wherein each Node object of said hierarchy of Node objects of said software application comprises: a first routine that when returning true denotes that the Node object is a focused one; and a second routine that when returning true denotes that the Node object is a focused, or at least one of its descendants is a focused; a routine for handling an incoming event; the method comprising the steps of: providing, for each Node object of said hierarchy of Node objects a third routine, that when returning true denotes that the Node object and all descendants of the Node object, excluding these Node objects for which the third routine returns true, forms a single monofocus area having a single focus root.
    Type: Grant
    Filed: February 24, 2015
    Date of Patent: October 17, 2017
    Assignee: ADVANCED DIGITAL BROADCAST S.A.
    Inventors: Piotr Kobzda, Pawel Pingot
  • Patent number: 9740673
    Abstract: Hierarchical data can be consistently presented in multiple different views. One method involves extracting object information describing at least one object from a database. The object information includes hierarchical information indicating a position of the object within a hierarchy of objects and list information usable to sort of list of objects that includes the object. The method also generates a tree view and a list view for display within a hierarchical data presentation window. The tree view identifies the object, and generation of the tree view is based upon the hierarchical information. The list view identifies the at least one object, and generation of the list view is based upon the list information. The method provides the tree and list views to a display device for display within the hierarchical data presentation window.
    Type: Grant
    Filed: September 19, 2011
    Date of Patent: August 22, 2017
    Assignee: Oracle International Corporation
    Inventors: Anadi Upadhyaya, Ty V. Hayden, Krishnaraj Mahadevan
  • Patent number: 9740666
    Abstract: Systems and methods are disclosed herein for resolving a change to a table. A processing circuitry receives, from a user in a collaborative document editing environment, the change to the table, wherein the change comprises an expansion of a first cell in the table. A first state of the first cell is identified, wherein the state is indicative of a number of columns and a number of rows over which the first cell spans, and at least one of the number of columns and the number of rows is greater than one. A second state of a second cell that is adjacent to the first cell is identified, and the processing circuitry selects whether to allow the expansion of the first cell based on the second state of the second cell.
    Type: Grant
    Filed: August 26, 2014
    Date of Patent: August 22, 2017
    Assignee: GOOGLE INC.
    Inventors: Gregory George Galante, Victoria Hsiao-Tsung Chou Fritz, Samuel Benjamin Messing, Luiz Do Amaral De Franca Pereira Filho
  • Patent number: 9727550
    Abstract: The present disclosure includes techniques pertaining to computer implemented systems and methods for transforming data. In one embodiment, data sources are specified by a user and copies of specified data are received in local storage. Data is presented to the user as a spreadsheet of columns and rows and the user manipulates the data in the spreadsheet. The user manipulations are automatically translated into data flow objects and a data flow graph, which is executed to transform the data. The modified data is presented to the user.
    Type: Grant
    Filed: April 30, 2015
    Date of Patent: August 8, 2017
    Assignee: SAP SE
    Inventors: Min He, Ricardo Saito, Vei Ming Seah, Barbara Stortz, Daniel Culp
  • Patent number: 9727551
    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 as 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: Grant
    Filed: May 26, 2016
    Date of Patent: August 8, 2017
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Eric B. Vigesaa, Allan Folting, Bruce Cordell Jones, Robert C. Collie
  • Patent number: 9721321
    Abstract: The computer applications, user devices, methods, and/or systems described herein provide a user with automated tools to facilitate creating dynamic, interactive performances of visualizations that utilize datasets of various digital/web content provided from various data sources and types without loss of access to underlying data used to create the performance.
    Type: Grant
    Filed: April 12, 2013
    Date of Patent: August 1, 2017
    Inventor: Farshad Nayeri
  • Patent number: 9720898
    Abstract: A computer-implemented method for managing row height in an electronic document includes receiving, at a computing device, a request to display a portion of a document that defines a plurality of rows of content and that is represented by a document model; determining heights of the plurality of rows and saving information about the determined heights in a cache that correlates rows to the height information; and using the document model and the cache to generate a view of the document model having the determined row heights.
    Type: Grant
    Filed: September 17, 2013
    Date of Patent: August 1, 2017
    Assignee: GOOGLE INC.
    Inventors: Zachary Lloyd, Nick Santos
  • Patent number: 9720583
    Abstract: A user interface element is displayed for in place editing of values within a document. For example, in response to selecting a value, a user interface is displayed near the value that receives a slide gesture for adjusting the value in place. The user interface may be configured to select one of the discrete parts of the value in response to changing a level of the slide gesture. For example, a user may move the swipe gesture from a level used for adjusting the day value to the level representing the year value. The user interface displayed and method(s) used to adjust the value may be based on the type of value and the structure and content of the document.
    Type: Grant
    Filed: September 22, 2011
    Date of Patent: August 1, 2017
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Benjamin Edward Rampson, Karen Xiaoxu Cheng
  • Patent number: 9715576
    Abstract: A sequential series of methods for optimized searching within a text (or alphanumeric string) database to retrieve specific and relevant results, followed by optimized restructuring and parsing of text data (or alphanumeric string), followed by creation/application of a natural language processing engine, followed by the creation/application of an automated analyzer is presented.
    Type: Grant
    Filed: March 15, 2014
    Date of Patent: July 25, 2017
    Inventor: Robert G. Hayter, II
  • Patent number: 9684877
    Abstract: Described herein are systems and methods for generating user interfaces that include a meta-chart framework for organizing and analyzing multi-dimensional hierarchical data in an efficient and intuitive graphical user interface with which a user can explore and consume prepared analytical elements. The predetermined structure of such user interfaces can include customizable and scalable graphical and/or alphanumeric analytic elements with contextual controls that can guide a user on a preconfigured analytical path, or “drill-down path,” to better explore and understand the multidimensional data. Such embodiments provide a turnkey analytical framework from which users can both immediately understand data and learn how to explore the data in greater depth.
    Type: Grant
    Filed: September 18, 2012
    Date of Patent: June 20, 2017
    Assignee: SAP SE
    Inventor: John Armitage
  • Patent number: 9652446
    Abstract: In some embodiments, a computer-implemented spreadsheet management method is provided that automatically copies formatting and formulas from appropriate peer rows to an updated row. In some embodiments, the method automatically determines which peer rows, if any, should be used as the source of copied formatting and formulas. In some embodiments, the method automatically fixes formulas that are affected by the updated row in order to maintain consistency throughout the spreadsheet.
    Type: Grant
    Filed: December 17, 2014
    Date of Patent: May 16, 2017
    Assignee: Smartsheet Inc.
    Inventors: John D. Creason, Mark P. Mader, Thomas P. Maliska, Jr., Erik Rucker
  • Patent number: 9619454
    Abstract: The present invention relates to a method for controlling an electronic spreadsheet on a handheld touch device, comprising an operation procedure, a display procedure and a recovery procedure. The operation procedure comprises: receiving a selection touch control signal for selecting cells, determining selected cells in an electronic spreadsheet according to the selection touch control signal, calculating according to a preset processing method, and storing the calculation result. The display procedure comprises: receiving a first touch control signal for controlling movement of an electronic spreadsheet from an initial position of the electronic spreadsheet to an interim position, moving the electronic spreadsheet from the initial position of the electronic spreadsheet to the interim position according to the first touch control signal to expose a blank area, querying whether the calculation result exists or not, and if yes, displaying the calculation result in the blank area.
    Type: Grant
    Filed: November 8, 2012
    Date of Patent: April 11, 2017
    Assignees: ZHUHAI KINGSOFT SOFTWARE CO., LTD, ZHUHAI KINGSOFT OFFICE SOFTWARE CO., LTD
    Inventors: Dong Wang, Wei Zhao, Zhiyu Li
  • Patent number: 9600539
    Abstract: Cross tabulation operation is performed within a columnar database management system. The columnar database management system receives a request to perform a cross-tabulation operation on a set of database tables. The columnar database management system determines values of cross tabulation operation for each row of the result. The columnar database management system determines a domain for each value of the row dimension corresponding to a row combination. The columnar database management system determines an intersection set of the domains corresponding to values of the row dimensions for the row combination. The columnar database management system determines a value for the result column for the row combination as an aggregate value based on the records of the intersection set.
    Type: Grant
    Filed: June 18, 2014
    Date of Patent: March 21, 2017
    Assignee: Actuate Corporation
    Inventors: Carles Bayés Martín, Jesús Malo Poyatos, Marc Rodríguez Sierra, Alejandro Sualdea Pérez
  • Patent number: 9600467
    Abstract: A character correcting method of a display apparatus includes displaying a sentence including at least two words in a character input window; displaying, if one of the at least two words is selected, a first user interface (UI) in which the at least one selected word is displayed by a character unit; and, displaying, if one of a plurality of characters displayed in the first UI is selected, a second UI around the selected character, the second UI is configured to edit the selected character.
    Type: Grant
    Filed: October 22, 2013
    Date of Patent: March 21, 2017
    Assignee: SAMSUNG ELECTRONICS CO., LTD.
    Inventors: Byuk-sun Kim, Min-jin Kim, Sung-gook Kim, Yong-Deok Kim, Sang-on Choi