×

Spreadsheet cell dependency management

  • US 9,703,767 B2
  • Filed: 11/29/2012
  • Issued: 07/11/2017
  • Est. Priority Date: 11/29/2012
  • Status: Active Grant
First Claim
Patent Images

1. A computer-implemented method comprising:

  • receiving a spreadsheet file and a separate dashboard structure file comprising metadata characterizing a dashboard;

    rendering, using the spreadsheet file and the dashboard structure file, the dashboard, wherein the rendered dashboard includes a plurality of visual components, and wherein one or more of the plurality of visual components are adapted to provide visual representations of at least a portion of data from the spreadsheet file;

    analyzing the spreadsheet file and the dashboard structure file to determine at least one dependency between one or more cells in the spreadsheet file and a first visual component comprising the rendered dashboard;

    registering, for the at least one dependency, an event listener, wherein the event listener is paired with an event source comprising the one or more cells in the spreadsheet file, wherein the first visual component comprises a dependent component and the one or more cells comprise a dependee of the at least one dependency, and wherein the event listener is notified of an event from the event source when the dependee is changed;

    notifying the event source that data is required for updating the dependent component in response to an event notification received at the event listener, wherein the first visual component is configured to continue a flow of execution independently of the event listener such that a second visual component is rendered while the event source schedules fetching of the data used to update the dependent component; and

    rendering, within the dashboard, the first visual component comprising the dependent component upon the event listener receiving notification that the event source has finished fetching the data required to update the dependent component.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×