IP Library Granted Patent US 7,840,889
Granted Patent B2
US 7,840,889 · App. 11/695,502 · Granted Nov 23, 2010

Apparatus and method for generating spreadsheet function source code for use in a source code application

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 7,840,889
App. No.
11/695,502
Granted
Nov 23, 2010
Kind
B2
Abstract

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.

Claims (26)

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.

Assignments (3)
CHANGE OF NAME Recorded Jan 26, 2026
From: BUSINESS OBJECTS SOFTWARE LIMITED
To: SAP IRELAND LIMITED
Reel/Frame 074510/0354 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 8, 2007
From: BUSINESS OBJECTS, S.A.
To: BUSINESS OBJECTS SOFTWARE LTD.
Reel/Frame 020156/0411 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Apr 2, 2007
From: MANTUANO, BRIAN ERIC; BECERRA, SANTIAGO E., JR.; TSAI, SHAWN; CALDERON, JESSE
To: BUSINESS OBJECTS, S.A.
Reel/Frame 019104/0028 →