Creating a spreadsheet template for generating an end user spreadsheet with dynamic cell dimensions retrieved from a remote application
View Patent ↗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:
connecting to a remote application which is communicably connected to a database;
determining at least one dimension for the spreadsheet based on user input, wherein the user input corresponds to selecting from a list of predefined dimensions associated with predefined tables included in the remote application;
creating logic to dynamically determine a dimension range for each dimension selected by the user when the spreadsheet template is run and saving said logic in a memory device, wherein
the logic to dynamically determine the dimension range for each of the dimension comprises a repeat attribute that controls a direction within the spreadsheet in which cells within the dimension are to repeat; and
mapping each cell within each dimension range to the selected predefined dimensions associated with the predefined tables included in the 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 , 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.
4. The method of claim 3 , wherein the action is to initiate a connection between the spreadsheet and the remote application to authenticate an end user of the spreadsheet template.
5. The method of claim 3 , wherein the action is to prompt an end user of the spreadsheet template to input values for each dimension.
6. A non-transitory computer-readable medium having stored thereon a sequence of instruction which when executed by a system causes the system to perform a method, comprising:
connecting to a remote application which is communicably connected to a database;
determining at least one dimension for the spreadsheet based on user input, wherein the user input corresponds to selecting from a list of predefined dimensions associated with predefined tables included in the remote application;
creating logic to dynamically determine a dimension range for each dimension selected by the user when the spreadsheet template is run, and saving said logic in a memory device, wherein
the logic to dynamically determine the dimension range for each of the dimension comprises a repeat attribute that controls a direction within the spreadsheet in which cells within the dimension are to repeat; and
mapping each cell within each dimension range to the selected predefined dimensions associated with the predefined tables included in the remote application object.
7. The computer-readable medium of claim 6 , 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.
8. The computer-readable medium of claim 6 , 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.
9. The computer-readable medium of claim 8 , wherein the action is to initiate a connection between the spreadsheet and the remote application to authenticate an end user of the spreadsheet template.
10. The computer-readable medium of claim 8 , wherein the action is to prompt an end user of the spreadsheet template to input values for each dimension.
11. 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:
connecting to a remote application which is communicably connected to a database;
determining at least one dimension for the spreadsheet based on user input, wherein the user input corresponds to selecting from a list of predefined dimensions associated with predefined tables included in the remote application;
creating logic to dynamically determine a dimension range for each dimension selected by the user when the spreadsheet template is run, and saving said logic in a memory device, wherein
the logic to dynamically determine the dimension range for each of the dimension comprises a repeat attribute that controls a direction within the spreadsheet in which cells within the dimension are to repeat; and
mapping each cell within each dimension range to the selected predefined dimensions associated with the predefined tables included in the remote application object.
12. The system of claim 11 , 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.
13. The system of claim 11 , 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.
14. The system of claim 13 , wherein the action is to initiate a connection between the spreadsheet and the remote application to authenticate an end user of the spreadsheet template.
15. The system of claim 13 , wherein the action is to prompt an end user of the spreadsheet template to input values for each dimension.