Spreadsheet Patents (Class 715/212)
  • Patent number: 9322741
    Abstract: The present invention provides an exhaust gas analyzing system having a function of navigating an adjusting procedure of a gas analyzer, and the system includes an analyzer for analyzing exhaust gas and a manager for managing or controlling the analyzer, and the manager includes a procedure display part for selectively displaying adjustment items necessary for adjustment of the analyzer in a predetermined order in a predetermined area of one screen, and a detail input screen display part for displaying a detail input screen of the selected adjustment item.
    Type: Grant
    Filed: May 23, 2013
    Date of Patent: April 26, 2016
    Assignee: HORIBA, Ltd.
    Inventors: Koji Watanabe, Tetsu Yoshioka
  • Patent number: 9313157
    Abstract: An electronic messaging system and method with reduced traceability. Separate displays are provided at a recipient user device for separately displaying via the user device header information of an electronic message and message content including a media component. The header information is displayed in a message list via a first display. The message content including a media component is displayed via a second display. The display of the message content occurs via the second display without displaying the header information. Methods, systems, and computer readable media with separation of the display of media component and header information in various implementations may provide for reduced traceability of an electronic message.
    Type: Grant
    Filed: December 17, 2014
    Date of Patent: April 12, 2016
    Assignee: VAPORSTREAM, INC.
    Inventors: Joseph Collins, Amit Jindas Shah
  • Patent number: 9313155
    Abstract: An electronic messaging system and method with reduced traceability. Message content and an identifier of a recipient are associated with an electronic message at a sending user device. The message content is associated via a first display and the identifier of a recipient is associated via a second display. The first and second displays are not displayed at the same time. The identifier of the recipient is not displayed at the same time as a media component of the message content via the first display. Methods, systems, and computer readable media with separation of the display of media component and recipient identifier in various implementations may provide for reduced traceability of an electronic message.
    Type: Grant
    Filed: December 17, 2014
    Date of Patent: April 12, 2016
    Assignee: Vaporstream, Inc.
    Inventors: Joseph Collins, Amit Jindas Shah
  • Patent number: 9313156
    Abstract: An electronic messaging system and method with reduced traceability. Message content and an identifier of a recipient are associated with an electronic message at a sending user device. The message content is associated via a first display and the identifier of a recipient is associated via a second display. The first and second displays are not displayed at the same time. The identifier of the recipient is part of header information for the electronic message and the header information is not displayed at the same time as a media component of the message content via the first display. Transmission of recipient identifier and message content including a media component occurs separately from the sending user device. Methods, systems, and computer readable media with separation of the display of media component and recipient identifier in various implementations may provide for reduced traceability of an electronic message.
    Type: Grant
    Filed: December 17, 2014
    Date of Patent: April 12, 2016
    Assignee: VAPORSTREAM, INC.
    Inventors: Joseph Collins, Amit Jindas Shah
  • Patent number: 9311349
    Abstract: A database management system stores data form a plurality of logical tables as independent copies in different format. In one specific example the system organizes tables into table groups and de-normalizes the table in each table group. It also organizes data in a second format including vertical column containers that store all the data for one attribute, there being one column container for each table and each attribute within that table. The receipt of a query causes the system to develop a query plan that can interact with either or both of the container sets.
    Type: Grant
    Filed: June 4, 2011
    Date of Patent: April 12, 2016
    Assignee: FoundationDB, LLC
    Inventor: Ori Herrnstadt
  • Patent number: 9306885
    Abstract: An electronic messaging system and method with reduced traceability. Message content and an identifier of a recipient are associated with an electronic message at a sending user device. The message content including a media component is associated via a first display and the identifier of a recipient is associated via a second display. The first and second displays are not displayed at the same time. The identifier of the recipient and the media component are not displayed at the same time via the second display. Transmission of recipient identifier and message content including a media component occurs separately from the sending user device. Methods, systems, and computer readable media with separation of the display of media component and recipient identifier in various implementations may provide for reduced traceability of an electronic message.
    Type: Grant
    Filed: December 17, 2014
    Date of Patent: April 5, 2016
    Assignee: VAPORSTREAM, INC.
    Inventors: Joseph Collins, Amit Jindas Shah
  • Patent number: 9306886
    Abstract: An electronic messaging system and method with reduced traceability. Separate displays are provided at a recipient user device for separately displaying via the user device header information of an electronic message and message content including a media component. The message content and the header information are correlated with a unique identifier. The header information is displayed in a message list via a first display. The message content including a media component is displayed via a second display. The display of the message content occurs via the second display without displaying the header information. Methods, systems, and computer readable media with separation of the display of media component and header information in various implementations may provide for reduced traceability of an electronic message.
    Type: Grant
    Filed: December 17, 2014
    Date of Patent: April 5, 2016
    Assignee: VAPORSTREAM, INC.
    Inventors: Joseph Collins, Amit Jindas Shah
  • Patent number: 9262035
    Abstract: A system for displaying an embedded intelligence applet comprises a processor and a memory. The processor is configured to provide display information to display in the embedded intelligence applet window and to provide an indication to display the embedded intelligence applet window in an opaque mode. The processor is configured to determine whether an indication to activate a window other than the embedded intelligence applet window is received. The processor is configured to provide an indication to display the embedded intelligence applet window in a partially transparent mode in the event that an indication to activate a window other than the embedded intelligence applet window is received. The memory is coupled to the processor and is configured to provide the processor with instructions.
    Type: Grant
    Filed: April 10, 2012
    Date of Patent: February 16, 2016
    Assignee: Workday, Inc.
    Inventors: Paul Gustafson, Hob Anthony Spillane, Jun Chen, Khurram Mahmood
  • Patent number: 9256297
    Abstract: A handheld electronic device includes a reduced QWERTY keyboard and is enabled with disambiguation software. The device provides output in the form of a default output and a number of variants. The output is based largely upon the frequency, i.e., the likelihood that a user intended a particular output, but various features of the device provide additional variants that are not based solely on frequency and rather are provided by various logic structures resident on the device. The device enables editing during text entry and also provides a learning function that allows the disambiguation function to adapt to provide a customized experience for the user. The disambiguation function can be selectively disabled and an alternate keystroke interpretation system provided. During text entry, a user is able to delimit a language entry session, such as the entering of a word, by actuating a multiple-axis input device or another input device.
    Type: Grant
    Filed: April 25, 2011
    Date of Patent: February 9, 2016
    Assignee: BlackBerry Limited
    Inventors: Vadim Fux, Michael Elizarov, Sergey V. Kolomiets
  • Patent number: 9171098
    Abstract: Embodiments prepare a markup language (ML) element for animation. A request to perform at least one animation on at least one ML element is intercepted or received. One or more animation preparation attribute values are defined based at least on the requested animation and current attribute values of the ML element. The ML element is altered to include the defined animation preparation attribute values, and an animation engine performs the animation of the altered ML element. The animation preparation attributes and values (e.g., style elements) may be reset, removed, or otherwise modified after animation. In some embodiments, a library of application programming interfaces (APIs) enable web browsers to request animations of legacy hypertext markup language (HTML) elements for consumption by animation engines based on JAVASCRIPT scripting or cascading style sheets (CSS).
    Type: Grant
    Filed: September 30, 2011
    Date of Patent: October 27, 2015
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Aditi Mandal, Arye Gittelman, Lionel Robinson, Joy Seth
  • Patent number: 9165112
    Abstract: System and methods are provided for displaying objects at a treatment display screen coupled to an apparatus for performing a treatment. A first arrangement of the objects is presented at the treatment display screen. At least some objects of the first arrangement of the objects are in a fixed state on the treatment display screen. A rearrangement mode of operation of the treatment display screen is activated. The objects of the first arrangement of the objects are changed from the fixed state to a fluid state that allows for rearrangement of the objects of the first arrangement of the objects to a second arrangement of the objects that is different than the first arrangement of the objects. The treatment is prevented from being performed during operation in the rearrangement mode. The second arrangement of the objects is presented at the treatment display screen during operation in the rearrangement mode.
    Type: Grant
    Filed: February 3, 2012
    Date of Patent: October 20, 2015
    Assignee: Fresenius Medical Care Holdings, Inc.
    Inventors: Matthew J. Doyle, Nathan Parnell, Alex Brown
  • Patent number: 9152618
    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: August 31, 2012
    Date of Patent: October 6, 2015
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Rajat Bhargav, Pankaj Jain, Mitushi Jain, Abhijit Kumar Bairagi
  • Patent number: 9143821
    Abstract: A program information acquisition unit 60 acquires program information of each of a plurality of channels over a plurality of broadcasting types, among which a transmitting form of a broadcasting signal is different. A program table displaying unit 88 causes a program table, in which program information of the plurality of channels is juxtaposed in a classified state for each channel, to be displayed. The program table displaying unit 88 causes both of program information of channels belonging to a first broadcasting type and program information of channels belonging to a second broadcasting type to be displayed in a juxtaposed relationship in the same program table.
    Type: Grant
    Filed: April 1, 2013
    Date of Patent: September 22, 2015
    Assignees: SONY CORPORATION, SONY COMPUTER ENTERTAINMENT INC.
    Inventors: Masakazu Hayashi, Kensaku Ishizuka, Yuki Kobayashi, Manabu Nishizawa
  • Patent number: 9106792
    Abstract: A conference supporting system includes plural input terminals and a control apparatus connected through a network. Each input terminal includes a processor and a display screen configured to allow a user to perform handwriting input thereon and to display the data. The processor of each input terminal is configured to perform making a user to choose who acquires an access right, making a request to acquire the access right to the control apparatus, and transmitting handwriting data to the control apparatus. The processor of the control apparatus is configured to perform granting an access right of a part or whole of the area determined by the user, giving one of the input terminals a notice about the granted access right, transmitting the handwriting data to other input terminals and operating the display screen of each of the other input terminals to display the handwriting data.
    Type: Grant
    Filed: September 3, 2013
    Date of Patent: August 11, 2015
    Assignee: KONICA MINOLTA, INC.
    Inventor: Tatsuya Kawano
  • Publication number: 20150149876
    Abstract: In various embodiments, methods, systems, and non-transitory computer-readable media are disclosed that allow developers to providing spreadsheets in a desktop integration framework that include error reports for validations. In various embodiments, a modeless error viewer is provided that allows end users to view an errors list for any failed row at the same time as the user corrects these errors.
    Type: Application
    Filed: August 26, 2014
    Publication date: May 28, 2015
    Inventors: Edmund Alexander Davis, Yuandi Jin, Kelsey Von Tish
  • Patent number: 9042653
    Abstract: A spreadsheet application associates data obtained from a captured image with a spreadsheet. For example, one or more images of physical data may be captured and translated into electronic data that is automatically associated with one or more spreadsheets. The formatting and underlying formulas of the data included within the captured image may be represented within a spreadsheet (e.g. highlighted data remains highlighted within the electronic spreadsheet). The data may also be compared with existing electronic data. For example, differences between the data in the captured image with the data in an existing spreadsheet may be used to update the existing spreadsheet. A display of a captured image may be also be augmented using data that is obtained from the captured image. For example, a chart may be created and displayed using data that is obtained from the captured image.
    Type: Grant
    Filed: January 24, 2011
    Date of Patent: May 26, 2015
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Amy Lin, Shahar Prish, Sherman Der, John Campbell
  • 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: 9037959
    Abstract: In some embodiments, a spreadsheet application provides an option for collectively displaying the formulas associated with a set of cells in a separate view. In some embodiments, the view provides an option to search within the formulas (and/or other content) provided by the view. In some embodiments, a find and replace user interface of a spreadsheet application includes an option to search only in formulas.
    Type: Grant
    Filed: September 30, 2008
    Date of Patent: May 19, 2015
    Assignee: APPLE INC.
    Inventors: Peter William Rapp, Shou-Shan Yeh, Christopher Douglas Weeldreyer
  • Patent number: 9037961
    Abstract: The dependency graph spreadsheet system allows for the capture of a sequence of calculations or formulas as a function. The function is stored as a function definition in a spreadsheet application. The function definition provides the ability to call or select a name or code associated with the function or function definition in the spreadsheet application by placing the name in a cell of the spreadsheet application. If the form of the calculation needs to be verified or modified, the function is reviewed and/or modified in the function definition worksheet, eliminating the need to seek out each invocation of the function in the spreadsheet application. The dependency graph spreadsheet system also provides the ability to invoke a higher order function that uses a defined function as an input and generates an output from the higher order function on a range of data inputs for the defined function in the spreadsheet.
    Type: Grant
    Filed: May 2, 2011
    Date of Patent: May 19, 2015
    Assignee: Credit Suisse Securities (USA) LLC
    Inventor: Howard Christopher Mansell
  • Patent number: 9037960
    Abstract: The present description refers to a computer-implemented method, a computer program product and a computer system for monitoring and tracking application usage, the method comprising: determining, during a first interval, a first indication of whether a first user has provided a first input. The method further comprising obtaining, during the first interval, a first identifier of an active window in a first graphical user interface (GUI), and selectively storing the first identifier and the first indication. For this purpose a specific tracking tool may be implemented on the computer on which the first graphical user interface is executed.
    Type: Grant
    Filed: December 14, 2010
    Date of Patent: May 19, 2015
    Assignee: Accenture Global Services Limited
    Inventors: Tanmoy Mukhopadhyay, Venumadhava Ganapaya Bhat
  • 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: 20150128018
    Abstract: A method and system electronically pull, using an extension of a launched program, accounting data from a launched accounting software application. The pulled data is converted, by the extension, into a format compatible with a second accounting software application. The converted data is written into the launched application associated with the extension. The written data is converted, by another extension, into a format compatible for importing into another accounting software application. The format compatible data is pushed into the second accounting software application by the extension.
    Type: Application
    Filed: November 3, 2014
    Publication date: May 7, 2015
    Inventor: Craig Hurlbut
  • Publication number: 20150121185
    Abstract: A method for displaying a graphical representation of a classification of a set of patent applications into a plurality of categories according to an attribute includes receiving, by a processor, a request to generate the graphical representation of the classification of the set of patent applications into the plurality of categories according to the attribute. The method further includes, in response to receiving the request, automatically displaying the graphical representation of the classification of the set of patent applications into the plurality of categories according to the attribute on a display device. The graphical representation includes a plurality of patent document icons. Each of the plurality of patent document icons corresponds to one of the set of patent applications. Each of the plurality of patent document icons graphically represents that the patent application associated with the patent document icon is classified in a category of the plurality of categories.
    Type: Application
    Filed: October 27, 2014
    Publication date: April 30, 2015
    Applicant: Reed Technology and Information Services, Inc.
    Inventors: Christopher L. Holt, Katherine M. Scholz
  • Publication number: 20150113377
    Abstract: Various technologies and techniques are disclosed for displaying and managing spreadsheets on mobile devices. An optimized search can be performed. A selection is received from a user to open a spreadsheet. A find selection is received from the use along with keywords for which to the user wishes to search. Any matching keywords are found in the spreadsheet and the cell location of the keywords is retrieved. A results page is constructed that shows search result listings with the keywords along with data surrounding the one or more keywords. The results page is displayed. Navigation options are provided for allowing a user to navigate around the spreadsheet. Right, left, downward, and upward navigation options can be used to change the current view of the spreadsheet by a pre-defined number of cells. Techniques are described for optimizing the display of charts in the spreadsheet.
    Type: Application
    Filed: December 30, 2014
    Publication date: April 23, 2015
    Inventors: Tsui-Ying Fu, Hung Ju King, Shao Yi Hung, Yung-Yu Tseng
  • Patent number: 9015572
    Abstract: Grouping a set of data is disclosed. In some embodiments, a set of data is grouped with respect to a column and/or a row associated with the set of data in response to receiving a selection of an option to group the set of data with respect to the column and/or the row. In some embodiments, the grouping of the set of data is based on real time values of the set of data and is automatically and dynamically updated in response to changes in the set of data.
    Type: Grant
    Filed: September 30, 2008
    Date of Patent: April 21, 2015
    Assignee: Apple Inc.
    Inventors: Nathaniel Cleverly Lanza, Christopher Douglas Weeldreyer
  • Patent number: 9015591
    Abstract: Embodiments are directed to selecting and applying data-specific presentations, to adaptively selecting visual presentations based on historical data and to providing rendering hints for data presentations. In one scenario, a computer system receives an indication that a visual presentation is to be applied to a specified portion of data. The computer system analyzes the specified data to determine which of a plurality of data presentations is most relevant for the specified data. The relevance is based on relevancy factors including one or more of the following: end-user profile, structure of the specified data and patterns within the specified data. The computer system then applies the determined appropriate visual presentation to the specified data.
    Type: Grant
    Filed: June 13, 2012
    Date of Patent: April 21, 2015
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Moe Khosravy, Christian Liensberger, Anthony Nino Bice
  • Patent number: 9009582
    Abstract: A networked version of a spreadsheet application can be automatically created from an existing “conventional” spreadsheet. In one implementation, a server may obtain a data file, where the data file represents a networked version of a spreadsheet application that was converted from the “conventional” application and the data file defines characteristics of the networked version of the spreadsheet application including logic and interactivity attributes of cells in the networked version of the spreadsheet application. A remote request may be received from a client to access the networked version of the spreadsheet application. In response, the server may transmit a document to the client that represents a portion of the networked version of the spreadsheet application that the interactivity attributes specify as being displayable to the client.
    Type: Grant
    Filed: November 18, 2005
    Date of Patent: April 14, 2015
    Assignee: Google Inc.
    Inventors: Jonathan P. Rochelle, Micah G. Lemonik, Farzad Khosrowshahi, John Danaher
  • Patent number: 9009583
    Abstract: Cross-tabular reports may be automatically created by a computer from received source data. After receiving the source data, the computer may determine different information types associated with fields contained in the source data. The computer may then score each field based on the information types. A score describes a suitable placement of each field as a cross-tabular report row, a cross-tabular report column or a cross-tabular report value field. The computer may then select the fields having the highest score for placement as cross-tabular report rows, cross-tabular report columns or cross-tabular report value fields in a cross-tabular report. Finally, the computer may build the cross-tabular report with the selected fields.
    Type: Grant
    Filed: December 27, 2010
    Date of Patent: April 14, 2015
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Gavin N. Shearer, Jingxia Xing, Fergal P. Condron
  • Publication number: 20150095752
    Abstract: Specifying rules for processing data included in fields of elements of a dataset includes rendering user interface elements associated with a respective condition. The user interface elements include: first subsets of user interface elements, at least some of which are associated with an input value derived from at least one field, and second subsets of user interface elements, each configured to receive user input associated with a respective condition. Conditions are applied to at least a first element of the dataset based on user input received from at least some of the user interface elements, in response to receiving user input for a first user interface element associated with a first field. Instructions are generated for applying one or more selected conditions associated with fewer than all of the user interface elements, the selected conditions including at least a condition associated with the first user interface element.
    Type: Application
    Filed: September 25, 2014
    Publication date: April 2, 2015
    Inventors: Scott Studer, David Phillimore, Amit Weisman
  • Patent number: 8996978
    Abstract: This disclosure provides examples of computerized methods and software for performing analytical procedures by interacting with visual representations of datasets. In one aspect, a visualization of a first dataset is displayed in a first portion of a GUI, where that visualization is associated with a set of criteria applied to the first dataset. A visualization of a second dataset is displayed in a second portion of the GUI. A selection of at least a portion of the data from the visualization of the first dataset is received, the selection associated with at least one set of set of criteria from the first dataset. A request to apply the selection to the second dataset is received, and, based thereon, the set of criteria from the first dataset is applied to the second dataset to generate a third dataset. A visual representation of the third dataset is then displayed in the GUI.
    Type: Grant
    Filed: May 14, 2010
    Date of Patent: March 31, 2015
    Assignee: SAP SE
    Inventors: Hans-Juergen Richstein, Eckhard Farrenkopf
  • Publication number: 20150089341
    Abstract: In various embodiments, methods, systems, and non-transitory computer-readable media are disclosed that allow developers to place date pickers on columns, rows, and cells using a desktop integration framework. The date picker can be tied to components, forms, or model metadata. In one aspect, date picker metadata is provided separately from the document to which one or more date pickers will eventually be added.
    Type: Application
    Filed: July 16, 2014
    Publication date: March 26, 2015
    Inventors: Edmund Alexander Davis, Yuandi Jin
  • Publication number: 20150089340
    Abstract: In various embodiments, methods, systems, and non-transitory computer-readable media are disclosed that allow developers to provide automatic column resizing in spreadsheet software using a desktop integration framework. The width of a column usually can only be set at or to hard-wired widths or manually adjusted to fit (even with a manually triggered auto adjustment function). This feature adds the ability to control column widths in tables at run time.
    Type: Application
    Filed: July 16, 2014
    Publication date: March 26, 2015
    Inventors: Shaun Logan, Edmund Alexander Davis
  • Publication number: 20150089343
    Abstract: Aspects of the present invention provide a solution for reducing cycle time of automatically created spreadsheets. Specifically, an embodiment of the present invention provides a way to create a spreadsheet from data that is in a native format more quickly and/or efficiently. To do so, the invention accesses a control file using optimized settings to create the spreadsheet. Then, after creation of the spreadsheet, the invention uses a second control file having the final settings to modify the spreadsheet in preparation for output. The invention may use agents to perform all or a portion of these activities.
    Type: Application
    Filed: November 12, 2014
    Publication date: March 26, 2015
    Inventors: Scott D. Hicks, James A. Martin, Douglas G. Murray
  • Publication number: 20150089342
    Abstract: In various embodiments, methods, systems, and non-transitory computer-readable media are disclosed that allow developers to place tooltips on components and columns headers using a desktop integration framework. The tooltips can be tied to translatable resources or model metadata. In one aspect, the tool tip metadata is provided separately from the document to which the tool tip will eventually be tied.
    Type: Application
    Filed: July 16, 2014
    Publication date: March 26, 2015
    Inventors: Edmund Alexander Davis, Freddy Nole Bafuka
  • Patent number: 8990675
    Abstract: A system for automatically detecting relationships in spreadsheet data is disclosed. The system may be configured to analyze data items in the spreadsheet to determine whether two or more data items are unrelated. If the two or more data items are unrelated, then the system may notify a user of a need to define the relationship, and automatically defines the relationship for the two or more data items, or suggests the relationship to the user.
    Type: Grant
    Filed: October 4, 2011
    Date of Patent: March 24, 2015
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Allan Folting, Stephen Van de Walker Handy, Diego M. Oppenheimer, Anatoly V. Grabar
  • Publication number: 20150082137
    Abstract: Methods, systems, and computer-readable storage media for providing a calculated measure from one or more existing measures of a data object. Actions include receiving data associated with the data object, displaying a data visualization based on the data, the data visualization being displayed within a graphical user interface (GUI), receiving user input, the user input defining the calculated measure, the calculated measure being a function of at least one existing measure of the data object, at least one dimension of the data object, and an aggregation schema, and providing a modified data visualization for display, the modified data visualization including the calculated measure.
    Type: Application
    Filed: September 17, 2013
    Publication date: March 19, 2015
    Applicant: Business Objects Software Ltd.
    Inventor: Emmanuel Zarpas
  • Patent number: 8983901
    Abstract: Systems and methods are provided for determining mutation regions for a spreadsheet. Mutation regions are iteratively assigned to a first region of cells in the spreadsheet. To assign a mutation region, a column is selected from the first region. A first row in the first region of cells is associated with the selected column that is not assigned to a mutation region and that is not included in a second region of the spreadsheet is determined. A largest region contained within the first region that does not overlap with the second region for which the cell in the selected column and the first row is in a designated position is determined. The largest region is assigned as a mutation region for the spreadsheet.
    Type: Grant
    Filed: February 5, 2013
    Date of Patent: March 17, 2015
    Assignee: Google Inc.
    Inventor: Benjamin Wolfe Simon
  • Publication number: 20150067463
    Abstract: A method and computer-executable program code for displaying data in a table having columns, rows and a plurality of cells defined by the columns and rows. The method involves the steps of creating a first and a second sub-tables positioned one above another or side-by-side. The top sub-table defines a non-scrollable, fixed header, while the bottom table defines a scrollable data table. The top table has a visible part and a hidden part, which contains records copied, without re-positioning or re-ordering, from a maximum width cell in the top or bottom table corresponding to each individual column. To form a fixed sidebar, the code computer-executable program code adjusts the height of the rows based on the parameters of a maximum height cell in the row.
    Type: Application
    Filed: August 28, 2013
    Publication date: March 5, 2015
    Inventor: Philip K. Chin
  • Patent number: 8972335
    Abstract: A system and method of extracting information from electronic data sources that includes generating a list of file names containing the information to be extracted. Each file name in the list is read into memory, the file that corresponds to the file name is read into memory, and the information is extracted from the file by executing a series of programming instructions. The information is saved to an extracted file, and one or more file names in the list is identified to correspond to an extracted file.
    Type: Grant
    Filed: August 2, 2012
    Date of Patent: March 3, 2015
    Assignee: Ryan, LLC
    Inventors: Timothy Michael Kirkpatrick, Kyle Day Meredith
  • Patent number: 8966357
    Abstract: A solution is provided that allows a user to provide an alternate set of metadata for any number of data points within a report, while in a report design environment. They may lay down a grid on the work area and specify the data by placing the relevant dimensional metadata, extracted from the source, in the grid as row headings and column headings. The user may then select either a column or a row from the grid and upon doing so may be provided with a mechanism to define alternate metadata that can describe all data points that are in the column or row in the target system. This allows for a much more user-friendly environment in which to specify metadata mappings between internal sources and external sources.
    Type: Grant
    Filed: March 9, 2011
    Date of Patent: February 24, 2015
    Assignee: Oracle International Corporation
    Inventors: Paul Tangen, Sekhar Marasanapalle, Hugh Wallis, Carlos R. Rivas
  • Publication number: 20150052038
    Abstract: Systems and methods for providing a customizable spreadsheet application interface for an electronic trading system or market data source. A customizable spreadsheet application using the application interface according to the invention may be executed or stored either at the client or at a server. In either case, a user is preferably provided with an spreadsheet interface that allows the user to implement a real time electronic trading model. The trading model may preferably be used to trade in the electronic trading system without additional user intervention.
    Type: Application
    Filed: July 23, 2014
    Publication date: February 19, 2015
    Inventor: John P. Bartolucci
  • Patent number: 8959424
    Abstract: Provided are techniques for comparing data. User selection of first data to be compared is received. User input of one or more formulas used in making comparisons is received. The user is allowed to move a Comparative and Analytic (CA) lens window to float over second data, wherein the CA lens window displays a floating, transparent document. In response to the CA lens floating over the second data, in real-time, the first data and the second data are compared according to the one or more formulas, and the CA lens window is displayed showing the first data and the comparison between the first data and the second data.
    Type: Grant
    Filed: June 28, 2011
    Date of Patent: February 17, 2015
    Assignee: International Business Machines Corporation
    Inventor: Amer Hammoud
  • Patent number: 8959423
    Abstract: Provided are techniques for providing drill-through information. User input of locations of one or more target documents and values of parameters for those one or more target documents is received. A user is allowed to move a drill-through lens window across a source document, wherein the drill-through lens window displays a floating, transparent target document. In response to the drill-through lens window floating over the data in the source document, in real time: the data is selected in the source document, the selected data is identified as a parameter for a target document, the parameter is used to obtain further details from the target document, and the drill-through lens window is displayed showing the further details.
    Type: Grant
    Filed: June 28, 2011
    Date of Patent: February 17, 2015
    Assignee: International Business Machines Corporation
    Inventor: Amer Hammoud
  • 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
  • Publication number: 20150039985
    Abstract: A document processor for associating mentioned items with each other in two documents. A conversion unit converts at least a portion of mentioned items expressed in table format among the mentioned items included in the two documents. An association processing unit associates mentioned items with each other in the two documents including at least some mentioned items converted to text format. The conversion unit converts each of a plurality of cells included in the mentioned items expressed in table format to separate mentioned items in text format.
    Type: Application
    Filed: April 22, 2014
    Publication date: February 5, 2015
    Applicant: International Business Machines Corporation
    Inventors: Yusuke Hara, Masatoshi Nogo, Eiichi Tazoe
  • Publication number: 20150033105
    Abstract: A method to create and to permit multilingual cell formulas to be written and translated concurrently into any human language within Microsoft Excel, including those that are not representable in ANSI. This method enables multiple ad-hoc concurrent semantically complete and extensible non-Roman and non-English natural language function sets and function names available for presentation and execution within cell formulas within MS Excel and to provide real-time translation of presentation and execution between nominated language function sets.
    Type: Application
    Filed: May 25, 2010
    Publication date: January 29, 2015
    Inventors: Diarmuid Pigott, Stephen Poulson
  • Patent number: 8943397
    Abstract: A method including receiving input from a user, retrieving data based on the input, generating a tabular display of the data according to default settings and adjustable user settings, and transmitting the tabular display to the user. A system having a server application structured and arranged to receive input from a user, retrieve data based on the input, generate a tabular display of the data according to default settings and adjustable user settings, and transmit the tabular display to the user, and a client application structured and arranged to display the tabular display.
    Type: Grant
    Filed: October 13, 2006
    Date of Patent: January 27, 2015
    Assignee: International Business Machines Corporation
    Inventors: Giancarlo Palleschi, Prasannakumar Parigivenkata
  • Publication number: 20150026554
    Abstract: An electronic device having a display and a touch-sensitive surface, displays a table having a plurality of rows, a plurality of columns, and a plurality of cells. The device detects a gesture on the touch-sensitive surface that includes movement of one or more of a first contact and a second contact. When the detected gesture is a pinch gesture at a location that corresponds to one or more respective columns in the table and has a component that is perpendicular to the one or more respective columns, the device decreases the width of the one or more respective columns. When the detected gesture is a de-pinch gesture at a location that corresponds to one or more respective columns in the table and has a component that is perpendicular to the one or more respective columns, the device increases the width of the one or more respective columns.
    Type: Application
    Filed: July 21, 2014
    Publication date: January 22, 2015
    Inventor: Edward P. A. HOGAN
  • Patent number: 8938669
    Abstract: A computer-implemented method is executed on a server having one or more processors and memory storing one or more programs to be executed by the one or more processors. The method includes receiving document editing commands, for editing a respective document, from one or more users in a document editing session, and editing the respective document in accordance with the commands received from the users. The received commands including document text for the document. The method further includes detecting, within the respective document text, an embedded request to invite a specified user to access the respective document, and responding by sending an invitation to the specified user, and, if needed, adding the specified user to an access control list of the respective document to enable the specified user to access the document in response to detecting the embedded request.
    Type: Grant
    Filed: June 22, 2011
    Date of Patent: January 20, 2015
    Assignee: Google Inc.
    Inventor: Gabriel Cohen
  • Patent number: 8938667
    Abstract: Disclosed are a method and system for grouping columns of data into different levels for subsequent multiple level operations. The method comprises the steps of providing sub-columns within a single table column, said table columns and each of the sub-columns having an associated header; and using multiple dummy tables and displaying them separately on different locations, one of the dummy tables including one or more of the associated headers. The preferred embodiment of the invention uses a tool, referred to as the Jtable class, which is used to display and edit regular two-dimensional tables of cells. The present invention is able to support multilevel headers and column spanning by using multiple tables and displaying them separately. Preferably, this is done using another tool, GridBagLayout, which is associated with Jpanel tool.
    Type: Grant
    Filed: May 7, 2012
    Date of Patent: January 20, 2015
    Assignee: International Business Machines Corporation
    Inventors: Linda Van Patten Benhase, Maria S. Rajakannimariyan