Inventors:
Eran Megiddo - Bellevue WA, US
Daniel Y. Parish - Kirkland WA, US
Daniel Battagin - Bellevue WA, US
Robert L. Archer - Seattle WA, US
Amarinder Singh Grewal - Redmond WA, US
Justin Frederick Rockwood - Kirkland WA, US
Sean Boon - Issaquah WA, US
Assignee:
Microsoft Corporation - Redmond WA
International Classification:
G06F 17/21
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.