Cell Format Patents (Class 715/217)
  • Patent number: 10095678
    Abstract: A simulation system includes at least one processor configured to execute a computer program product, stored upon a storage medium. The computer program product includes a database application, a process simulation application, and an integration tool, where the database application and the process simulation application are discrete, stand alone products. The process simulation application can simulate industry processes using at least one flowsheet, which models a general flow of industry processes. The integration tool can map process simulation application objects and properties to database application objects, can convey information between mapped objects, can perform case management functions, and can perform orchestrated calculation functions.
    Type: Grant
    Filed: May 29, 2015
    Date of Patent: October 9, 2018
    Assignee: Honeywell International Inc.
    Inventors: Christophe Romatier, Richard Huang, Ronald Klecka, Bryan Anderson
  • Patent number: 9557880
    Abstract: This disclosure provides various embodiments for providing UI services. An application-independent, reusable UI framework receives a request from a first application, to perform a first operation on a first set of data relating to presentation of the first set of data on a UI. A subset of the first set of data is received from a data provider independent of the UI framework. At least one first service is identified in response, the first service hosted by the UI framework and adapted to perform the first operation on the first set of data. The first operation is performed on the subset of the first set of data using the at least one identified first service to produce a first processed set of data adapted for presentation on a UI of the first application. The first processed set of data is sent to the first application.
    Type: Grant
    Filed: March 6, 2013
    Date of Patent: January 31, 2017
    Assignee: SAP SE
    Inventors: Ivo Vollrath, Klaus-Dieter Scherer, Petr Novak, Michelle Braun
  • Patent number: 9507765
    Abstract: Approaches are described for displaying rotated character strings within cells of tables. In particular embodiments, the display of the rotated character string is handled such that the character string does not extend beyond the edges of the cell. Further, in certain implementations, the character string may be displayed as wrapped and rotated text within the cell, wherein each line of the wrapped character string does not extend beyond the edges of the cell.
    Type: Grant
    Filed: December 21, 2012
    Date of Patent: November 29, 2016
    Assignee: APPLE INC.
    Inventors: Edward Patrick Anthony Hogan, Paul Hankes Drieslma
  • Patent number: 9460444
    Abstract: A system causes display of a visual representation of a cell-based calendar having cells representing data records, where the cells have corresponding visual indicators corresponding to values of the respective data records. The cells are arranged in plural blocks corresponding to time intervals of the cell-based calendar. Event visual indicators transparently overlay cells in at least some of the plural blocks, where the event visual indicators represent events that occurred in time intervals corresponding to the at least some blocks. The events are separate from activities represented by the data records. Providing the event visual indicators transparently overlaid over the cells in the at least some blocks depict a relationship and relative impact between the data records and the events.
    Type: Grant
    Filed: September 3, 2010
    Date of Patent: October 4, 2016
    Assignee: Hewlett Packard Enterprise Development LP
    Inventors: Ming C. Hao, Umeshwar Dayal, Lars-Erik Haug, Christian Rohrdantz
  • Patent number: 9069747
    Abstract: In one embodiment, a method comprises: providing an electronic spreadsheet having a plurality of cells arranged in an array having a plurality of rows and a plurality of columns; receiving information defining a plurality of items, each of the plurality of items representing a respective set of data usable in populating at least a portion of the plurality of cells of the electronic spreadsheet, at least one of the plurality of items including a table having a plurality of rows and a plurality of columns; associating each of the plurality of items with a respective location in the electronic spreadsheet; associating each of the plurality of items with a respective position in a stack, each of the plurality of items being able to be associated with any position in the stack; and rendering the electronic spreadsheet in accordance with the information defining the plurality of items, the respective location associated with each item and the respective stack position associated with each item.
    Type: Grant
    Filed: August 26, 2010
    Date of Patent: June 30, 2015
    Assignee: SAP SE
    Inventors: Thorsten Ueberschaer, Gilbert Karbach
  • 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: 9032283
    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: September 29, 2008
    Date of Patent: May 12, 2015
    Assignee: Apple Inc.
    Inventor: Tsurishaddai Williamson
  • Publication number: 20150121186
    Abstract: A method for increasing the information density in providing information on a progress of at least one project, comprises providing at least one project related goal and at least one project related information, the project related information being related to the project related goal. The information characterizing the project related goal is arranged in a first cell in one element of the group of the cells of a first row of a table and the cells of a first column of the table and the information characterizing the project related information is arranged in a second cell of the other element of the group. An information cell of the table is colored in a first color when the goal is achieved and in a second, different color when the goal is not achieved.
    Type: Application
    Filed: October 24, 2013
    Publication date: April 30, 2015
    Applicant: Aktiebolaget SKF
    Inventors: Christian Genheimer, Armin Herbert Emil August Olschewski, Jasper Vennemann
  • Patent number: 9009598
    Abstract: A plurality of users participate (S1) in an interactive service. A subset of the users is determined (S2) according to the outcomes of the participation. The subset is then displayed in a further participation with the interactive service, within a broadcast.
    Type: Grant
    Filed: March 17, 2008
    Date of Patent: April 14, 2015
    Assignee: British Sky Broadcasting Ltd.
    Inventor: Stuart J. McCarthy
  • Publication number: 20150100871
    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: Application
    Filed: December 15, 2014
    Publication date: April 9, 2015
    Inventors: Benjamin C. Chamberlain, Bruce Cordell Jones, Christopher M. Street, Eric B. Vigesaa
  • Patent number: 8977950
    Abstract: Techniques to select and manipulate table borders as discrete objects are described. In particular, a table border may be selected without having to select a cell that includes the desired border. In one embodiment, for example, a technique may include detecting a selector in proximity to a border in a table. The border in proximity to the selector may be highlighted visually on a display to show which part of the table border may be selected. A selection may cause the highlighted border to be selected. The now-selected border may then be manipulated. Other embodiments are described and claimed.
    Type: Grant
    Filed: October 4, 2011
    Date of Patent: March 10, 2015
    Assignee: Microsoft Corporation
    Inventors: Caitlin Ashley-Rollman, Jessica Best, Levent Kartaltepe, Tristan Davis, Charles Walker, Susan Baker
  • 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
  • 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
  • Patent number: 8914717
    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: June 7, 2010
    Date of Patent: December 16, 2014
    Assignee: Microsoft Corporation
    Inventors: Benjamin C. Chamberlain, Bruce Cordell Jones, Christopher M. Street, Eric B. Vigesaa
  • Patent number: 8880995
    Abstract: The present invention discloses a method for localized scrolling table display in a webpage. The method includes: dividing a table being displayed into at least a 2×2 array of an upper left table, a lower left table, an upper right table and a lower right table; setting the lower left table and the upper right table to hide portions that are beyond display area; and setting the lower right table to hide portions that are beyond the display area and to include a vertical scrollbar and a horizontal scrollbar. The upper right table and the lower right table are controlled by the horizontal scrollbar, and the lower left table and the lower right table are controlled by the vertical scrollbar. The present invention is able to display a table in a webpage with a localized scrolling display and a partial frozen display, and allows unlimited number of data columns and rows in the webpage and still maintains good readability.
    Type: Grant
    Filed: February 1, 2007
    Date of Patent: November 4, 2014
    Assignee: Alibaba Group Holding Limited
    Inventor: Qi Chen
  • Publication number: 20140289601
    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: Application
    Filed: November 8, 2012
    Publication date: September 25, 2014
    Applicants: ZHUHAI KINGSOFT SOFTWARE CO., LTD, ZHUHAI KINGSOFT OFFICE SOFTWARE CO., LTD
    Inventors: Dong Wang, Wei Zhao, Zhiyu LI
  • Publication number: 20140281869
    Abstract: Described herein are Interactive Size Tables, Variable Size Table Templates, Distributable Size Tables, and related systems and methods that execute and enable generating, publishing, distributing, displaying, modifying, viewing, and interacting with online Interactive Size Tables. Interactive Size Tables are client customizable size tables with interactive features, and, may be generated using Variable Size Table Templates. An example of an executable user interactive feature is size selection by tapping a size displayed on an Interactive Size Table. Another interactive feature is the multiple format feedback feature, which allows users to choose from several different feedback formats and to leave user feedback in sections proximate utilized Interactive Size Tables. User feedback is then made available online and reportable back to generating clients, along with other metrics and usage fees, through a client data purchase and billing interface.
    Type: Application
    Filed: March 14, 2014
    Publication date: September 18, 2014
    Inventor: Susan Yob
  • Patent number: 8832544
    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: August 16, 2010
    Date of Patent: September 9, 2014
    Assignee: Microsoft Corporation
    Inventors: Eric B. Vigesaa, Allan Folting, Bruce Cordell Jones, Robert C. Collie
  • Patent number: 8832543
    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: June 8, 2010
    Date of Patent: September 9, 2014
    Assignee: Microsoft Corporation
    Inventors: Paul Broman, Glenn Frankel, Roberto C. Taboada
  • Publication number: 20140237339
    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: April 28, 2014
    Publication date: August 21, 2014
    Applicant: MICROSOFT CORPORATION
    Inventors: Benjamin C. Chamberlain, Bruce Cordell Jones, Christopher M. Street, Eric B. Vigesaa
  • Patent number: 8799760
    Abstract: A system and method for assisting a user to enter data are provided. The method includes detecting a user's selection of a moveable input zone on each of one or more input documents displayed on the user's screen and detecting a user's selection of a moveable target zone on a target document displayed on the user's screen. Data in the input zone(s) and the target zone is captured for one or more locations of the respective zones and a pattern is learned automatically for filling additional data in the target document based on the captured data. A fill arrangement for filling the additional data in the target document based on the learned pattern is generated, which can be presented to the user for validation.
    Type: Grant
    Filed: December 8, 2011
    Date of Patent: August 5, 2014
    Assignee: Xerox Corporation
    Inventors: Denys Proux, Claude Roux
  • Patent number: 8782511
    Abstract: Lines drawn on a touch screen with an inputting window opened are recognized as ruled lines which are parallel with a row or column of a spreadsheet, and a square formed by the ruled lines is set to a cell in the spreadsheet when the square is formed. Consequently, it is possible to create the spreadsheet when a user of a computer simply draws a line with a fingertip or the like over the touch screen, and furthermore, it is also possible to input a value to the cell by specifying the square part drawn with the lines to carry out an operation for inputting data. Thus, there is provided a spreadsheet creating interface which makes the most of a visibility and an operability of the touch screen.
    Type: Grant
    Filed: December 21, 2011
    Date of Patent: July 15, 2014
    Assignee: Ubiquitous Entertainment Inc.
    Inventor: Ryo Shimizu
  • Patent number: 8782510
    Abstract: Disclosed are methods and systems for cell content alignment. The methods and systems involve retrieving one or more table parameters, the one or more table parameters including size of currently invisible cells in a display window, size of merged cells, the display window size and text size in the merged cells, calculating a position of a text in a visible portion of merged cells based on the table parameters and displaying the text in the merged cells based on the calculated position of the text.
    Type: Grant
    Filed: December 21, 2010
    Date of Patent: July 15, 2014
    Assignee: Business Objects Software Limited
    Inventor: Jean Christophe Cros
  • Patent number: 8756204
    Abstract: Architecture for multi-level undo on a client in grid-based applications. The architecture is a control driven cascading changes system where change tracking works seamlessly in asynchronous (and synchronous) scenarios. A client application is associated with a grid object and, instantiates and configures the grid object. The application can initiate a change to data in the grid and/or the user can edit the data in the grid directly. A result of the change is a notification to the application, the notification including an order key. The application consumes the notification and can then append new changes based on synchronous or asynchronous computations by calling an update function using the order key. The application uses the key to attach further updates which are properly collected together for undo/redo.
    Type: Grant
    Filed: January 8, 2008
    Date of Patent: June 17, 2014
    Assignee: Microsoft Corporation
    Inventors: Andrew R. Cuneo, Ben Worline, Eric M. Zenz
  • Publication number: 20140164896
    Abstract: The invention relates to a method for expanding data cells in a spreadsheet or a report which is associated with a spreadsheet having a number of cells that are displayed in rows and columns wherein at least some of the cells may contain data which is member of a hierarchic structure comprising different hierarchic levels, the methods comprising the following steps: detecting a user request to expand a certain cell, wherein the user request comprises the selection of a cell to be expanded, further detecting a dragging movement performed by the user by means of an input means and expanding the selected cell in reaction to the dragging movement, thereby displaying one or more cells proximate to the selected cell, depending on the length of the dragging movement.
    Type: Application
    Filed: December 6, 2012
    Publication date: June 12, 2014
    Applicant: CAN DO GMBH
    Inventor: Thomas Schlereth
  • Patent number: 8745482
    Abstract: The present invention comprises methods and user interfaces for organizing data displayed within a data application. Specifically, the present invention provides methods and systems for arranging the display of the data by a format applied to one or more portions of the data. The formats comprise different visual characteristics of the displayed data. In exemplary embodiments, the data application organizes the data by the fill color of the cell, the font color of the data within the cell, or the type of icon inserted into the cell. The organizations comprise any type of rearrangement of the data. In exemplary embodiments, the data application sorts or filters the displayed data according to the format.
    Type: Grant
    Filed: August 26, 2010
    Date of Patent: June 3, 2014
    Assignee: Microsoft Corporation
    Inventors: Charles D. Ellis, David F. Gainer, Samuel C. Radakovitz, Yonghong Zeng, Dave McDonald
  • Publication number: 20140149838
    Abstract: Formulas in dashboards can be executed at a client executing web technologies such as HTML5 and JavaScript. The formulas specified by a spreadsheet file are transformed into a pre-defined notation format and then recursively evaluated. 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: 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: 8718364
    Abstract: An apparatus according to the present invention comprises: a region extraction unit configured to extract region data for each object from document image data including tables; a table structure analysis unit configured to analyze the region data relating to table objects out of the extracted region data and extract table structure information on each of the table objects; a sheet generation unit configured to generate a display sheet for reproducing a layout of the object in the document image data and an edit sheet for each table for editing the table, by using the region data and the table structure information on each object; and an electronic-document generation unit configured to generate an electronic document which associated the display sheet with the edit sheet.
    Type: Grant
    Filed: December 29, 2010
    Date of Patent: May 6, 2014
    Assignee: Canon Kabushiki Kaisha
    Inventor: Makoto Enomoto
  • Patent number: 8713422
    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: Grant
    Filed: November 13, 2009
    Date of Patent: April 29, 2014
    Assignee: Microsoft Corporation
    Inventors: Benjamin C. Chamberlain, Bruce Cordell Jones, Christopher M. Street, Eric B. Vigesaa
  • Publication number: 20140115434
    Abstract: Block properties and improved calculated columns properties are provided in a spreadsheet application. Once block properties are set for a group of spreadsheet cells or a spreadsheet list, the properties may be applied to the entire group of selected cells or list as opposed to requiring application of properties to individual cells. If rows or columns are added to the group of selected cells or list, properties applied to the group of cells or list are automatically applied to the new rows or columns. Block properties also provide for intelligent-behaving list borders where list borders are not corrupted by the movement or changing of columns or rows sharing edges with a list border. Calculated columns are a type of block property that extends the functionality of formulas throughout an entire column of an associated group of cells or list.
    Type: Application
    Filed: December 30, 2013
    Publication date: April 24, 2014
    Applicant: Microsoft Corporation
    Inventors: Joseph N. Chirilov, Dennis R. Newland, Eoin J. Burke, Hannah W. Zhou, John C. Haymond, Juha P. Niemisto, Robert C. Collie, Robert W. Coffen, Thao Moua
  • 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: 20140089774
    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: Application
    Filed: September 17, 2013
    Publication date: March 27, 2014
    Applicant: Google Inc.
    Inventors: Zachary Lloyd, Nick Santos
  • Publication number: 20140082470
    Abstract: A method of managing a spreadtree hierarchy comprises storing at least one spreadsheet in a network environment accessible to a plurality of users, and storing at least one data object in the network responsive to an edit of the at least one spreadsheet, the at least one data object having a unique ID and data associated with the edit. A spreadtree system comprises an application server configured to operate within a network (Internet or Intranet), and further configured to communicate with a plurality of clients and manage a spreadtree hierarchy. The spreadtree hierarchy comprises a plurality of linked spreadsheets having reference files stored within the network, and a plurality of data objects associated with the plurality of linked spreadsheets. Each data object of the plurality includes a change to at least one cell in at least one linked spreadsheet of the plurality. A method for operating a spreadtree hierarchy system is also disclosed.
    Type: Application
    Filed: September 19, 2012
    Publication date: March 20, 2014
    Applicant: 4CLICKS SOLUTIONS, LLC
    Inventors: David Trebas, William Trout, Michael Brown
  • Patent number: 8621340
    Abstract: Block properties and improved calculated columns properties are provided in a spreadsheet application. Once block properties are set for a group of spreadsheet cells or a spreadsheet list, the properties may be applied to the entire group of selected cells or list as opposed to requiring application of properties to individual cells. If rows or columns are added to the group of selected cells or list, properties applied to the group of cells or list are automatically applied to the new rows or columns. Block properties also provide for intelligent-behaving list borders where list borders are not corrupted by the movement or changing of columns or rows sharing edges with a list border. Calculated columns are a type of block property that extends the functionality of formulas throughout an entire column of an associated group of cells or list.
    Type: Grant
    Filed: December 20, 2004
    Date of Patent: December 31, 2013
    Assignee: Microsoft Corporation
    Inventors: Joseph M. Chirilov, Dennis R. Newland, Eoin J. Burke, Hannah W. Zhou, John C. Haymond, Juha P. Niemisto, Robert C. Collie, Robert W. Coffen, Thao Moua
  • Publication number: 20130339832
    Abstract: Table styles provide a way to format an entire spreadsheet table quickly and easily. According to described implementations, table styles can be created and customized for repeated use in a spreadsheet application. As a result, a user does not have to manually modify multiple formatting options for each table included in one or more spreadsheets. A graphical user interface is also described that provides simple user access to existing table styles that can be modified according to the user's requirements.
    Type: Application
    Filed: August 26, 2013
    Publication date: December 19, 2013
    Applicant: Microsoft Corporation
    Inventors: Roy Simkhay, David F. Gainer, Tom J. Hoke, Benjamin C. Chamberlain, Paavany Jayanty, Charles D. Ellis
  • Publication number: 20130332811
    Abstract: Concepts and technologies are described herein for progressive loading for web-based spreadsheet applications. In accordance with the concepts and technologies disclosed herein, a user device can access data from a remote source such as a server computer. The user device can determine dimensions of a viewport corresponding to a viewable portion of the data, a window associated with the viewport, and a preloaded area associated with the window. The user device can request the data associated with the window and the preloaded area and store the data in a cache associated with the user device. The cached data can be used by the user device to generate UIs for displaying the spreadsheet. If the user device detects movement of the viewport, the user device can render a new UI in response to the movement. The user device also can be configured to update and/or clean the cache.
    Type: Application
    Filed: June 7, 2012
    Publication date: December 12, 2013
    Applicant: MICROSOFT CORPORATION
    Inventors: Ming-Hsiung Chang, Shao-Yi Hung, Peng-Jen Chen, Li-Hui Chen, Hung-Ju King, Hsin Hui Huang
  • Publication number: 20130290823
    Abstract: Data cells in a spreadsheet report are collapsed and expanded without disrupting other spreadsheet data. A user may want to drill down on data corresponding to a parent member of the report to display more detailed information about the parent member. Likewise, a user may want to drill up the displayed information corresponding to the parent member to hide detailed information associated with the parent member. Before expanding or collapsing a report, the spreadsheet is scanned for information to determine whether the display of other data in the spreadsheet would be disrupted by the expansion/collapse. The information may include cross join information associated with the parent member, the number of child members associated with the parent member, the dimension of the report created by the parent member and the associated child members, and other reports that may be linked to the report that includes the parent member.
    Type: Application
    Filed: June 20, 2013
    Publication date: October 31, 2013
    Inventors: Lakshmi N. Thanu, Peter Eberhardy, Dylan Hai Huang, Xiaohong Mark Yang
  • Publication number: 20130275847
    Abstract: Described herein are mechanisms for automatically generating a computer-executable program that transforms a first table in a first format to a second table in a second format by way of user-provided examples. A user provides an exemplary input table of a first format, where the input table may be a portion of the first table. The user also provides an exemplary output table of a second format, wherein contents of the output table correspond to contents of the input table. Based upon these user-provided examples, a table transform program is automatically generated, wherein the table transform program, when executed over the first table generates the second table.
    Type: Application
    Filed: June 6, 2013
    Publication date: October 17, 2013
    Inventors: Sumit Gulwani, William Robert Harris
  • Patent number: 8560300
    Abstract: The disclosed system and method apply stores of factual information to correct errors in digital text, for example, generated from OCR, speech and/or handwriting recognition devices, and other automatic recognition devices. A text produced by OCR, speech recognition, handwriting recognition, and others may be processed to extract discussed facts. Databases of facts are searched based on information in the text. After comparing facts asserted in the text with the factual data from the databases, suggested corrections of the text are produced.
    Type: Grant
    Filed: September 9, 2009
    Date of Patent: October 15, 2013
    Assignee: International Business Machines Corporation
    Inventors: David A. Ferrucci, David C. Gondek, Wlodek W. Zadrozny
  • Publication number: 20130262974
    Abstract: Disclosed herein are systems, methods, and non-transitory computer-readable storage media for managing spreadsheets with decision tables. The exemplary method includes generating an underlying data model associated with a visual data model of a spreadsheet containing a decision table, populating the underlying data model based on information contained in the visual data model and based on the decision table, generating a first index for mapping cells in the visual data model to cells in the underlying data model consistent with the decision table, and generating a second index for mapping cells in the underlying data model to cells in the visual data model consistent with the decision table.
    Type: Application
    Filed: March 29, 2012
    Publication date: October 3, 2013
    Applicant: RED HAT, INC.
    Inventors: Michael Anstis, Mark Proctor
  • Patent number: 8521857
    Abstract: Systems and methods for providing, sharing, storing and playing widgets and associated media content on a personal audiovisual device, such as a digital photo frame, are described. In one implementation, widgets may be selected by a user for rendering based on capabilities of a user's device, with the widgets then provided to the device for playback. Digital content such as audio files, images, and/or video may be rendered in conjunction with playback of the widget. Widgets may be shared between users so as to facilitate sharing of media content.
    Type: Grant
    Filed: March 1, 2010
    Date of Patent: August 27, 2013
    Assignee: BBY Solutions, Inc.
    Inventors: Duane Stewart Maxwell, Andrew S. Huang, Kenneth Earl Steele, Stephen L. Tomlin, Steven Michael Adler
  • 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
  • Publication number: 20130212458
    Abstract: Disclosed is a display control device including a selection information acquiring part 2 for acquiring a program ID showing a program currently being selected from among a plurality of cells which construct an electronic program guide, a cell searching part 3 for referring to attribution information stored in a cell attribute information storage unit 1 to search through the plurality of programs for programs each having the same attribute as the program currently being selected, and a reallocation processing part 4 for deleting the cells other than the cell currently being selected and one or more cells found by the cell searching part 3 from the plurality of cells, and for shifting the cell currently being selected and the one or more cells found by the cell searching part 3 forward in a vertical direction or in a horizontal direction to display these cells.
    Type: Application
    Filed: December 12, 2012
    Publication date: August 15, 2013
    Inventors: Asami OKADA, Takehiko ISHIZUKA
  • Patent number: 8484550
    Abstract: Described herein are mechanisms for automatically generating a computer-executable program that transforms a first table in a first format to a second table in a second format by way of user-provided examples. A user provides an exemplary input table of a first format, where the input table may be a portion of the first table. The user also provides an exemplary output table of a second format, wherein contents of the output table correspond to contents of the input table. Based upon these user-provided examples, a table transform program is automatically generated, wherein the table transform program, when executed over the first table generates the second table.
    Type: Grant
    Filed: January 27, 2011
    Date of Patent: July 9, 2013
    Assignee: Microsoft Corporation
    Inventors: Sumit Gulwani, William Robert Harris
  • Publication number: 20130117650
    Abstract: A method and system that generate reproducible reports describing one or more analytical functions are disclosed. The reports describe a sequence of analytical functions and allow subsequent executions of the sequence of analytical functions. The matrix space that is inherent in worksheets is used to record a sequence of operations as a tabular report that can be interpreted by a computer program.
    Type: Application
    Filed: March 27, 2012
    Publication date: May 9, 2013
    Inventors: C. James MacLennan, Ioan Bogdan Crivat
  • Patent number: 8436871
    Abstract: A sortable and space efficient graphical user interface and a system for the efficient display of sortable data are disclosed herein. The graphical user interface may include at least one column, at least one row and a data cell defined by the intersection of at least one column and at least one row. First and second data may be displayed in the data cell. A first header is associated with the first column and identifies the first data. A second header is associated with the first column and identifies the second data. In the system for displaying sortable data, a graphical user interface is displayed upon a graphical display. A table is displayed as at least a portion of the graphical user interface, the table having a column with a plurality of rows, each row displaying first and second data and a first header associated with a first data and a second header associated with the second data.
    Type: Grant
    Filed: April 18, 2008
    Date of Patent: May 7, 2013
    Assignee: General Electric Company
    Inventor: Robert Joseph Alberte
  • Patent number: 8423909
    Abstract: A system applies an interactive filter. The system includes a data storage device, a display device, a user interface input device, and a processor. The data storage device stores data. The display device displays an initial representation of the data. The user interface input device facilitates a localized selection of a portion of the initial representation displayed on the display device. The localized selection is determined by hovering a navigation icon in alignment with a selection area corresponding to the portion of the initial representation. The processor dynamically applies a filter parameter to the portion of the initial representation based on the localized selection from the user interface input device.
    Type: Grant
    Filed: July 26, 2010
    Date of Patent: April 16, 2013
    Assignee: International Business Machines Corporation
    Inventor: Robert S Zabielski
  • Publication number: 20130086461
    Abstract: Techniques to select and manipulate table borders as discrete objects are described. In particular, a table border may be selected without having to select a cell that includes the desired border. In one embodiment, for example, a technique may include detecting a selector in proximity to a border in a table. The border in proximity to the selector may be highlighted visually on a display to show which part of the table border may be selected. A selection may cause the highlighted border to be selected. The now-selected border may then be manipulated. Other embodiments are described and claimed.
    Type: Application
    Filed: October 4, 2011
    Publication date: April 4, 2013
    Applicant: MICROSOFT CORPORATION
    Inventors: Caitlin Ashley-Rollman, Jessica Best, Levent Kartaltepe, Tristan Davis, Charles Walker, Susan Baker