Apparatus and method for generating spreadsheet function source code for use in a source code application
View Patent ↗A computer-implemented method includes designating selected spreadsheet cells within a spreadsheet document. Spreadsheet function source code characterizing the functionality associated with the selected spreadsheet cells is generated. The spreadsheet function source code is incorporated into a source code application.
1. A computer-implemented method, comprising:
designating selected spreadsheet cells within a spreadsheet document;
generating spreadsheet function source code characterizing the functionality associated with the selected spreadsheet cells, wherein generating includes designating a selected source code format consistent with a target source code application and wherein generating includes explicitly defining in the selected source code format cell dependencies; and
incorporating the spreadsheet function source code into the target source code application.
2. The method of claim 1 wherein generating includes generating spreadsheet function source code characterizing formulae and data associated with, but not displayed within, the selected spreadsheet cells.
3. The method of claim 1 wherein incorporating includes calling the spreadsheet function source code from the target source code application.
4. The method of claim 1 further comprising creating source code bindings between a graphical component created by the target source code application and the selected spreadsheet cells.
5. The method of claim 4 further comprising updating the selected spreadsheet cell values in response to manipulation of the graphical component.
6. A computer readable storage medium, comprising executable instructions to:
receive selected spreadsheet cells; and
generate spreadsheet function source code characterizing the functionality associated with the selected spreadsheet cells, wherein the executable instructions to generate include executable instructions to designate a selected source code format consistent with a target source code application and executable instructions to explicitly define in the selected source code format cell dependencies.
7. The computer readable storage medium of claim 6 wherein the executable instructions to generate include executable instructions to generate spreadsheet function source code characterizing formulae and data associated with, but not displayed within, the selected spreadsheet cells.
8. The computer readable storage medium of claim 6 further comprising executable instructions to incorporate the spreadsheet function source code into the target source code application.
9. The computer readable storage medium of claim 8 wherein the executable instructions to incorporate include executable instructions to call the spreadsheet function source code from the target source code application.
10. The computer readable storage medium of claim 8 wherein the executable instructions to incorporate include executable instructions to copy the spreadsheet function source code into the target source code application.
11. The computer readable storage medium of claim 6 further comprising executable instructions to execute the target spreadsheet function source code.
12. The computer readable storage medium of claim 6 further comprising executable instructions to create source code bindings between a graphical component created by the target source code application and the selected spreadsheet cells.
13. The computer readable storage medium of claim 12 further comprising executable instructions to update the selected spreadsheet cell values in response to manipulation of the graphical component.
14. A computer readable storage medium, comprising executable instructions to:
designate spreadsheet cells within a spreadsheet document;
generate spreadsheet function source code characterizing the functionality associated with the spreadsheet cells, wherein the executable instructions to generate include executable instructions to designate a selected source code format consistent with a target source code application and the executable instructions explicitly define in the selected source code format cell dependencies; and
incorporate the spreadsheet function source code into the target source code application.
15. The computer readable storage medium of claim 14 , wherein the executable instructions to generate include executable instructions to generate spreadsheet function source code characterizing formulae and data associated with, but not displayed within, the selected spreadsheet cells.
16. The computer readable storage medium of claim 14 wherein the executable instructions to incorporate include executable instructions to call the spreadsheet function source code from the target source code application.
17. The computer readable storage medium of claim 14 further comprising executable instructions to create source code bindings between a graphical component created by the target source code application and the selected spreadsheet cells.
18. The computer readable storage medium of claim 17 further comprising executable instructions to update the selected spreadsheet cell values in response to manipulation of the graphical component.