Back to results
US 10,311,141 B1Granted
Data driven spreadsheet chart system
AssigneeWorkday, Inc.
InventorTerry M. Olkin
Life of this patent
Estimating the term…
Abstract
A data-driven spreadsheet chart system includes an interface and a processor. The interface is to receive a formula entered into a cell of a spreadsheet document, wherein the formula includes a function that references a set of data. The processor is to host the spreadsheet document and render a visual representation of the data for display entirely within the cell.
Claims13
A data-driven spreadsheet chart system, comprising
- an interface to:
- receive a formula entered into a cell of a spreadsheet document, wherein the formula includes a function that references a set of data, wherein the formula takes as arguments a chart-type parameter and a primary-data parameter, wherein the formula takes a base configuration parameter, the base configuration parameter including a location of a legend, a title, a format and a location of an axis, or any combination thereof, and wherein the formula takes an override parameter to override the base configuration parameter, the base configuration parameter corresponding to a standard formatting style;
- and
- a processor to:
- host the spreadsheet document;
- compile the formula into a byte code version, comprising to:
- perform a syntactic check, a semantic check, or both on the formula;
- and
- in response to a determination that syntactic check, a semantic check, or both are completed without error, generate the byte code version from the formula using a compiler;
- and
- render a visual representation of the data for display entirely within the cell based on the base configuration parameter, wherein the rendering of the visual representation is performed using the byte code version, wherein the visual representation comprises the legend, the title, the axis, or any combination thereof, wherein the visual representation comprises a chart, wherein the visual representation exists in the same plane as neighboring cells of the cell, and wherein the visual representation exists in the same sheet of the spreadsheet document as the neighboring cells of the cell.
8 more elements
A method for data-driven spreadsheet chart system, comprising:
- receiving a formula entered into a cell of a spreadsheet document, wherein the formula includes a function that references a set of data, wherein the formula takes as arguments a chart-type parameter and a primary-data parameter wherein the formula takes a base configuration parameter, the base configuration parameter including a location of a legend, a title, a format and a location of an axis, or any combination thereof, and wherein the formula takes an override parameter to override the base configuration parameter, the base configuration parameter corresponding to a standard formatting style;
- hosting the spreadsheet document;
- compiling the formula into a byte code version, comprising:
- performing a syntactic check, a semantic check, or both on the formula;
- and
- in response to a determination that syntactic check, a semantic check, or both are completed without error, generating the byte code version from the formula using a compiler;
- and
- rendering, using a processor, a visual representation of the data for display entirely within the cell based on the base configuration parameter, wherein the rendering of the visual representation is performed using the byte code version, wherein the visual representation comprises a chart, wherein the visual representation comprises the legend, the title, the axis, or any combination thereof, wherein the visual representation exists in the same plane as neighboring cells of the cell, and wherein the visual representation exists in the same sheet of the spreadsheet document as the neighboring cells of the cell.
5 more elements
A computer program product for data-driven spreadsheet chart system, the computer program product being embodied in a non-transitory computer readable storage medium and comprising computer instructions for:
- receiving a formula entered into a cell of a spreadsheet document, wherein the formula includes a function that references a set of data, wherein the formula takes as arguments a chart-type parameter and a primary-data parameter, wherein the formula takes a base configuration parameter, the base configuration parameter including a location of a legend, a title, a format and a location of an axis, or any combination thereof, and wherein the formula takes an override parameter to override the base configuration parameter, the base configuration parameter corresponding to a standard formatting style;
- hosting the spreadsheet document;
- compiling the formula into a byte code version, comprising:
- performing a syntactic check, a semantic check, or both on the formula;
- and
- in response to a determination that syntactic check, a semantic check, or both are completed without error, generating the byte code version from the formula using a compiler;
- and
- rendering, using a processor, a visual representation of the data for display entirely within the cell based on the base configuration parameter, wherein the rendering of the visual representation is performed using the byte code version, wherein the visual representation comprises a chart, wherein the visual representation comprises the legend, the title, the axis, or any combination thereof, wherein the visual representation exists in the same plane as neighboring cells of the cell, and wherein the visual representation exists in the same sheet of the spreadsheet document as the neighboring cells of the cell.
5 more elements
Dependencies are inferred from the claim text.