Converting spreadsheet applications to web-based applications
View Patent ↗A networked version of a spreadsheet application can be automatically created from an existing “conventional” spreadsheet. In one implementation, a server may obtain a data file, where the data file represents a networked version of a spreadsheet application that was converted from the “conventional” application and the data file defines characteristics of the networked version of the spreadsheet application including logic and interactivity attributes of cells in the networked version of the spreadsheet application. A remote request may be received from a client to access the networked version of the spreadsheet application. In response, the server may transmit a document to the client that represents a portion of the networked version of the spreadsheet application that the interactivity attributes specify as being displayable to the client.
1. A method performed by one or more server devices, the method comprising:
obtaining, by the one or more server devices, a data file, the data file:
representing a networked version of a spreadsheet application that was converted from another spreadsheet application,
the networked version of the spreadsheet application being converted from the other spreadsheet application by applying a quantity of permissions that are set in the other spreadsheet application,
the quantity of permissions not being applied in the other spreadsheet application, and
defining, based on the quantity of permissions, characteristics of the networked version of the spreadsheet application including attributes of cells in the networked version of the spreadsheet application,
where an attribute of a first set of cells, of the cells, indicates that the first set of cells is displayable, and
where an attribute of a second set of cells, of the cells, indicates that the second set of cells is not displayable;
receiving, by the one or more server devices, a remote request from a client device to access the networked version of the spreadsheet application; and
transmitting, from the one or more server devices and based on the request and to the client device, a document that represents the first set of cells and does not represent the second set of cells.
2. The method of claim 1 , where the other spreadsheet application is a spreadsheet application created by a spreadsheet program that runs locally on a personal computer.
3. The method of claim 1 , where the document is a HyperText Markup Language (HTML) document.
4. The method of claim 1 , where the document includes one or more displayable cells of the networked version of the spreadsheet application.
5. The method of claim 1 , where the data file is an extensible markup language (XML) document.
6. The method of claim 5 , further comprising:
creating a computer program based on the XML document;
requesting information associated with a display screen from the computer program; and
constructing the document based on the information associated with the display screen.
7. The method of claim 5 , where
the information regarding the attributes of the cells is stored in the XML document in an abbreviated form, and
the abbreviated form includes a grouping of cells, having similar interactivity attributes, within the XML document.
8. The method of claim 1 , where the attributes include one or more functions implemented by one or more cells in the spreadsheet application.
9. The method of claim 8 , where the one or more functions include information defining a data interface between the spreadsheet application and one or more other applications.
10. The method of claim 1 , where
the networked version of the spreadsheet application is a first portion, and
the data file includes attribute information for a second portion of the spreadsheet application,
the second portion being:
different from the first portion, and
identified as hidden from the client device.
11. One or more server devices comprising:
a memory to store instructions; and
a processor to execute the instructions to:
obtain a data file from a first client device, the data file:
representing a networked version of a spreadsheet application that was converted from another spreadsheet application that executes on the first client device,
the networked version of the spreadsheet application being converted from the other spreadsheet application by applying a quantity of permissions that are set in the other spreadsheet application,
the quantity of permissions not being applied in the other spreadsheet application, and
defining, based on the quantity of permissions characteristics of the networked version of the spreadsheet application including attributes of cells in the networked version of the spreadsheet application,
where an attribute of a cell, of the cells, indicates that the cell is modifiable, by a second client device, in the networked version of the spreadsheet application, and
where an attribute of another cell, of the cells, indicates that the other cell is not modifiable by the second client device;
receive a remote request from the second client device to access the networked version of the spreadsheet application; and
transmit, based on the request and to the second client device, a document that represents at least a first cell and a second cell in the networked version of the spreadsheet application,
where the first cell is modifiable by the second client device, and
where the second cell is not modifiable by the second client device.
12. The one or more server devices of claim 11 , where the data file is an extensible markup language (XML) file.
13. The one or more server devices of claim 12 , where the XML file comprises information regarding logic of the spreadsheet application and information regarding interactivity of the spreadsheet application.
14. The one or more server devices of claim 13 , where the information regarding the interactivity of the spreadsheet application includes information defining cells of the spreadsheet application that are to be viewable to a user of the networked version of the spreadsheet application.
15. A system comprising:
one or more devices to:
obtain a data file, the data file:
representing a networked version of a spreadsheet application that was converted from another spreadsheet application,
the networked version of a spreadsheet application being converted from the other spreadsheet application by applying a quantity of permissions that are set in the other spreadsheet application,
the quantity of permissions not being applied in the other spreadsheet application, and
defining, based on the quantity of permissions, characteristics of the networked version of the spreadsheet application including attributes of cells in the networked version of the spreadsheet application,
where an attribute of a first set of cells, of the cells, indicates that the first set of cells is displayable, and
where an attribute a second set of cells, of the cells, indicates that the second set of cells is not displayable;
receive a remote request from a client device to access the networked version of the spreadsheet application; and
transmit, based on the request and to the client device, a document that represents the first set of cells and does not represent the second set of cells.
16. The system of claim 15 , where
the document is a HyperText Markup Language (HTML) document, and
the data file is an extensible markup language (XML) document.
17. The system of claim 15 , where the other spreadsheet application is a spreadsheet application created by a spreadsheet program that runs locally on a personal computer.
18. The system of claim 15 , where the document includes one or more displayable cells of the networked version of the spreadsheet application.
19. The system of claim 15 , where the data file is an extensible markup language (XML) document, and the one or more devices are further to:
create a computer program based on the XML document;
request information associated with a display screen from the computer program; and
construct the document based on the information associated with the display screen.
20. The system of claim 15 , where
the attributes include functions implemented by one or more cells in the spreadsheet application, and
where the one or more functions include information defining a data interface between the spreadsheet application and one or more other applications.