Granted Patent B1

US 9,672,200 · App. 14/073,295 · Granted Jun 6, 2017

Abstract

Claims (45)

1. A method for a spreadsheet program, comprising:

capturing user inputs for dimensions of a spreadsheet;

initiating a connection to a remote application for transmitting user information and the user inputs for the dimensions of the spreadsheet to the remote application;

receiving, in response to the initiated connection, header information from the remote application wherein the header information was generated dynamically by the remote application based on the user inputs for the dimensions of the spreadsheet; and

creating the spreadsheet comprising generating a row header and a column header for the spreadsheet based on the header information.

2. The method of claim 1 , wherein the user information comprises information to identify a user, for whom the spreadsheet is to be created, to the remote application.

3. The of method of claim 2 , wherein the user information further comprises input captured from the user, the input to facilitate generation of a header.

4. The method of claim 3 , further comprising prompting the user for the input by displaying a list of options for the input, which correspond to tables of the remote application.

5. The method of claim 1 , further comprising locking selected cells of the spreadsheet to prevent input into the cells until the row header and the column header for the cells have been generated.

6. The method of claim 5 , farther comprising transmitting information input into the selected cells, when unlocked, to the remote application.

7. A method for a spreadsheet program, comprising:

locking a grid area comprising a selection of cells to prevent data entry into the cells by a user;

performing an authentication operation to authenticate the user with a remote application;

if the authentication, operation authenticates the user then:

retrieving row and column header information from the remote application;

generating a spreadsheet comprising the row and column header information from the remote application; and

selectively unlocking cells of the grid area with row and column header information.

8. The method of claim 7 , wherein the row and column header information is retrieved by the remote application based on identifying information for the user.

9. The method of claim 7 , further comprising prompting the user to input spreadsheet configuration information; and communicating the spreadsheet configuration information to the remote application.

10. The method of claim 9 , wherein the row and column header information is retrieved by the remote application based on the spreadsheet configuration information.

11. The method of claim 7 , further comprising capturing input data from the user; and transmitting same to the remote application.

12. The method of claim 11 , wherein the row and column header information is retrieved by the remote application responsive to a query based on input data.

13. A non-transitory computer-readable storage medium, having stored thereon, a sequence of computer-executable instructions which causes a computer to perform a method, comprising:

locking a grid area comprising a selection of cells to prevent data entry into the cells by a user;

performing an authentication operation to authenticate the user with a remote application, wherein

if the authentication operation authenticates the user then:

prompting the user to input spreadsheet configuration information,

communicating the spreadsheet configuration information to the remote application,

retrieving row and column header information from the remote application in response to the communication;

generating a spreadsheet comprising the row and column header information from the remote application; and

selectively unlocking cells of the grid area with the row and column header information.

14. The non-transitory computer-readable storage medium of claim 13 , wherein the row and column header information is retrieved by the remote application based on identifying information for the user.

15. The non-transitory computer-readable storage medium of claim 13 , wherein the method further comprises prompting the user to input spreadsheet configuration information; and communicating the spreadsheet configuration information to the remote application; wherein the row and column header information is retrieved by the remote application based on the spreadsheet configuration information.

16. A system, comprising:

a processor; and

a memory coupled to the processor, the memory storing instructions which when executed by the system causes the system to perform a method, comprising:

locking a grid area comprising a selection of cells to prevent data entry into the cells by a user;

performing an authentication operation to authenticate the user with a remote application;

if the authentication operation authenticates the user then:

retrieving row and column header information from the remote application in response to the communication;

generating spreadsheet comprising the row and column header information from the remote application; and

selectively unlocking cells of the grid area with row and column header information.

17. The system of claim 16 , wherein the row and column header information retrieved by the remote application based on identifying information for the user.

18. The system of claim 16 , wherein the method further comprises prompting the user to input spreadsheet configuration information; and communicating the spreadsheet configuration information to the remote application.

19. The system of claim 18 , wherein the row and column header information is retrieved by the remote application based on the spreadsheet configuration information.

Assignments (11)