Abstract: A method displays a first data visualization according to user association of data fields with displayed data visualization properties. The data visualization includes visual data marks corresponding to data values for data fields in a dataset. A user selects a subset of the visual data marks. A popup summary is displayed that includes data value distributions for several data fields from the dataset. In the popup summary, a second user input is detected corresponding to a first data field whose data value distribution is displayed in the popup summary. The second user input associates the first data field with a first visualization property of the displayed data visualization properties. In response, a second data visualization is displayed according to association of data fields, including the first data field, with displayed data visualization properties.

Abstract: A method displays a first data visualization according to user placement of data fields in shelves of a user interface. Each shelf specifies a property of the data visualization and the data visualization includes visual data marks corresponding to data values for data fields in a dataset. A user selects a subset of the visual data marks. A popup summary is displayed that includes data value distributions for several data fields. In the popup summary, a second user input is detected corresponding to a first data field whose data value distribution is displayed in the popup summary. In response, the method displays a moveable icon corresponding to the first data field. The method detects a third user input to place the interactive moveable icon in a shelf in the user interface. In response, a second data visualization is displayed according to placement of data fields, including the first data field.

Abstract: A method displays a first data visualization according to user placement of data fields in shelves of a user interface. Each shelf specifies a property of the data visualization and the data visualization includes visual data marks corresponding to data values for data fields in a dataset. A user selects a subset of the visual data marks. A popup summary is displayed that includes data value distributions for several data fields. In the popup summary, a second user input is detected corresponding to a first data field whose data value distribution is displayed in the popup summary. In response, the method displays a moveable icon corresponding to the first data field. The method detects a third user input to place the interactive moveable icon in a shelf in the user interface. In response, a second data visualization is displayed according to placement of data fields, including the first data field.

Abstract: For standalone spreadsheet applications and/or Web-based spreadsheet services, the ability to designate, discover and set parameters for spreadsheet documents is provided. When creating a spreadsheet document, the ability to designate certain cells or ranges of cells as parameters to a spreadsheet is enabled. Furthermore, whether viewed in a standalone spreadsheet application or via a Web service, the ability to discover these parameters through the user interface or object model is provided. The ability to set or change these parameters one at a time or in bulk and drive the changes into the calculation model is also provided. Accordingly, whether viewed in a standalone spreadsheet application or via a Web rendering service, the effect of the parameters entered by the user can be calculated and viewed at once. The ability to suspend recalculation of a workbook until all relevant values, such as a current set of parameters, are obtained is also enabled.

Abstract: For standalone spreadsheet applications and/or Web-based spreadsheet services, the ability to designate, discover and set parameters for spreadsheet documents is provided. When creating a spreadsheet document, the ability to designate certain cells or ranges of cells as parameters to a spreadsheet is enabled. Furthermore, whether viewed in a standalone spreadsheet application or via a Web service, the ability to discover these parameters through the user interface or object model is provided. The ability to set or change these parameters one at a time or in bulk and drive the changes into the calculation model is also provided. Accordingly, whether viewed in a standalone spreadsheet application or via a Web rendering service, the effect of the parameters entered by the user can be calculated and viewed at once. The ability to suspend recalculation of a workbook until all relevant values, such as a current set of parameters, are obtained is also enabled.

Abstract: A method, system, and computer-readable medium are provided for controlling the calculation of volatile functions in a workbook created in a spreadsheet application program such that the volatile function does not need to be recalculated each time a calculation request is received in the workbook. A volatile function may include a function which is capable of returning a different value each time the function is calculated. The spreadsheet application program determines a calculation mode setting for the workbook, calculates a volatile function timeout value based on the calculation mode setting, and calculates the volatile function based on the volatile function timeout value. The volatile function timeout value may include a time span for which the results of a volatile function are valid.

Abstract: A method, system, and computer-readable medium are provided for determining whether to reproduce a chart image from the contents of a spreadsheet application workbook on a server. A calculation server calculates chart data for defining a chart image from workbook data retrieved from the spreadsheet application workbook, generates a representation of the chart data, and calculates an identifier for the representation of the chart data. A charting component receives the representation of the chart data and the identifier from the calculation server and compares the calculated identifier to a previously stored identifier on the server. If the calculated identifier is equal to the previously stored identifier, then the charting component retrieves a previously produced chart image from the representation of the chart data from the server. If the calculated identifier is not equal to the previously stored identifier, then the charting component produces a chart image from the representation of the chart data.