DESIGNATING, SETTING AND DISCOVERING PARAMETERS FOR SPREADSHEET DOCUMENTS

摘要

FOR STANDALONE SPREADSHEET APPLICATIONS AND/OR WEB-BASED SPREADSHEET SERVICES, THE ABILITY TO DESIGNATE (620), DISCOVER (630) AND SET (640) PARAMETERS FOR SPREADSHEET DOCUMENTS IS PROVIDED. WHEN CREATING A SPREADSHEET DOCUMENT, THE ABILITY TO DESIGNATE (620) CERTAIN CELLS OR RANGES OF CELLS AS PARAMETERS TO A SPREADSHEET IS ENABLED. FURTHERMORE, WHETHER VIEWED IN A STANDALONE SPREADSHEET APPLICATION (26) OR VIA A WEB SERVICE, THE ABILITY TO DISCOVER (630) THESE PARAMETERS THROUGH THE USER INTERFACE OR OBJECT MODEL IS PROVIDED. THE ABILITY TO SET OR CHANGE (640) 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 (670). THE ABILITY TO SUSPEND RECALCULATION OF A WORKBOOK (44) UNTIL ALL RELEVANT VALUES, SUCH AS A CURRENT SET OF PARAMETERS, ARE OBTAINED IS ALSO ENABLED.