CREATING A SPREADSHEET TEMPLATE FOR GENERATING AN END USER SPREADSHEET WITH DYNAMIC CELL DIMENSIONS RETRIEVED FROM A REMOTE APPLICATION
A method for creating a spreadsheet template to facilitate creation of a spreadsheet is disclosed. The method comprises determining at least one dimension for the spreadsheet; creating logic to dynamically determine a dimension range for each dimension when the spreadsheet template is run and saving said logic in a memory device; and creating logic to map each cell within each dimension range to a remote application object.
1 . A computer-implemented method for creating a spreadsheet template to facilitate creation of a spreadsheet, comprising:
determining at least one dimension for the spreadsheet;
creating logic to dynamically determine a dimension range for each dimension when the spreadsheet template is run, and saving said logic in a memory device; and
creating logic to map each cell within each dimension range to a remote application object.
2 . The method of claim 1 , wherein the logic to dynamically determine the dimension range for each dimension is configured to filter the remote application based on a user-input value for each dimension.
3 . The method of claim 1 , wherein the logic to dynamically determine the dimension range for each dimension comprises a repeat attribute that controls a direction within the spreadsheet in which cells within the dimension are to repeat.
4 . The method of claim 1 , further comprising creating logic to generate at least one menu command for insertion into the spreadsheet, the at least one menu command to perform an action.
5 . The method of claim 4 , wherein the action is to initiate a connection between the spreadsheet and the remote application to authenticate an end user of the spreadsheet template.
6 . The method of claim 4 , wherein the action is to prompt an end user of the spreadsheet template to input values for each dimension.
7 . A computer-readable medium having stored thereon a sequence of instruction which when executed by a system causes the system to perform a method, comprising:
determining at least one dimension for the spreadsheet;
creating logic to dynamically determine a dimension range for each dimension when the spreadsheet template is run, and saving said logic in a memory device; and
creating logic to map each cell within each dimension range to a remote application object.
8 . The computer-readable medium of claim 7 , wherein the logic to dynamically determine the dimension range for each dimension is configured to filter the remote application based on a user-input value for each dimension.
9 . The computer-readable medium of claim 7 , wherein the logic to dynamically determine the dimension range for each dimension comprises a repeat attribute that controls a direction within the spreadsheet in which cells within the dimension are to repeat.
10 . The computer-readable medium of claim 7 , wherein the method further comprises creating logic to generate at least one menu command for insertion into the spreadsheet, the at least one menu command to perform an action.
11 . The computer-readable medium of claim 10 , wherein the action is to initiate a connection between the spreadsheet and the remote application to authenticate an end user of the spreadsheet template.
12 . The computer-readable medium of claim 10 , wherein the action is to prompt an end user of the spreadsheet template to input values for each dimension.
13 . A system, comprising:
a processor; and
a memory coupled to the processor, the memory storing instruction which when executed by the system causes the system to perform a method for creating a spreadsheet template to facilitate creation of a spreadsheet, comprising:
determining at least one dimension for the spreadsheet;
creating logic to dynamically determine a dimension range for each dimension when the spreadsheet template is run, and saving said logic in a memory device; and
creating logic to map each cell within each dimension range to a remote application object.
14 . The system of claim 13 , wherein the logic to dynamically determine the dimension range for each dimension is configured to filter the remote application based on a user-input value for each dimension.
15 . The system of claim 13 , wherein the logic to dynamically determine the dimension range for each dimension comprises a repeat attribute that controls a direction within the spreadsheet in which cells within the dimension are to repeat.
16 . The system of claim 13 , wherein the method further comprises creating logic to generate at least one menu command for insertion into the spreadsheet, the at least one menu command to perform an action.
17 . The system of claim 16 , wherein the action is to initiate a connection between the spreadsheet and the remote application to authenticate an end user of the spreadsheet template.
18 . The system of claim 16 , wherein the action is to prompt an end user of the spreadsheet template to input values for each dimension.